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

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