You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Guidance Needed: Migrating Logic from CMP_ASG_SALARY_V (Package-Based Columns)

in Compensation 6 comments

Summary:

We are currently using the Oracle-delivered view CMP_ASG_SALARY_V, which derives most of its columns from package functions such as:

  • cmp_ff_dbi_pkg.get_fte_value
  • cmp_salary_entry_api.get_salary_chg_percent
  • cmp_salary_entry_api.get_annualized_salary
  • cmp_salary_entry_api.get_annualized_ft_salary
  • cmp_ff_dbi_pkg.get_quintile
  • cmp_ff_dbi_pkg.get_quartile
  • cmp_ff_dbi_pkg.get_comparatio
  • cmp_ff_dbi_pkg.get_range_position
  • cmp_ff_dbi_pkg.get_grade_min
  • cmp_ff_dbi_pkg.get_grade_mid
  • cmp_ff_dbi_pkg.get_grade_max
  • cmp_ff_dbi_pkg.get_zone_name
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!