APPS.GHR_MSL_PKG dependencies on GHR_MASS_SALARY_CRITERIA_EXT

Line 1816: FROM ghr_mass_salary_criteria criteria, ghr_mass_salary_criteria_ext ext

1812: p_prd NUMBER,
1813: p_msl_id NUMBER
1814: ) IS
1815: SELECT ext.increase_percent percent
1816: FROM ghr_mass_salary_criteria criteria, ghr_mass_salary_criteria_ext ext
1817: WHERE criteria.mass_salary_id = p_msl_id
1818: AND criteria.mass_salary_criteria_id=ext.mass_salary_criteria_id
1819: AND criteria.pay_plan = p_pay_plan
1820: AND criteria.PAY_RATE_DETERMINANT = p_prd

Line 1839: -- Get the value from the table ghr_mass_salary_criteria_ext.

1835: -- To calculate percent increase from From Pay and To Pay if rpa_type = 'MPC'.
1836: IF pa_req_rec.rpa_type = 'MPC' THEN
1837: -- Bug#3964284 Get the customized increase percent from History using get_extra_info_comments procedure.
1838: -- If the value is NULL THEN
1839: -- Get the value from the table ghr_mass_salary_criteria_ext.
1840: -- End If;
1841: get_extra_info_comments
1842: (p_person_id => p_person_id,
1843: p_effective_date => p_effective_date,

Line 5184: FROM ghr_mass_salary_criteria criteria, ghr_mass_salary_criteria_ext ext

5180: SELECT criteria.pay_plan pay_plan,
5181: criteria.pay_rate_determinant prd,
5182: ext.increase_percent percent,
5183: ext.grade grade
5184: FROM ghr_mass_salary_criteria criteria, ghr_mass_salary_criteria_ext ext
5185: WHERE criteria.mass_salary_id=p_msl_id
5186: AND criteria.mass_salary_criteria_id=ext.mass_salary_criteria_id;
5187:
5188:

Line 5199: l_pay_calc_msl_percentage ghr_mass_salary_criteria_ext.increase_percent%type;

5195: l_elig_flag BOOLEAN := FALSE;
5196: --
5197: -- Defining the record type variable
5198: --
5199: l_pay_calc_msl_percentage ghr_mass_salary_criteria_ext.increase_percent%type;
5200: l_ses_basic_pay NUMBER;
5201: --
5202: --
5203: