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
            Tagged:
            
        
0