APPS.GHR_MSL_PKG dependencies on GHR_MASS_SALARY_CRITERIA_EXT

Line 1840: FROM ghr_mass_salary_criteria criteria, ghr_mass_salary_criteria_ext ext

1836: p_prd NUMBER,
1837: p_msl_id NUMBER
1838: ) IS
1839: SELECT ext.increase_percent percent
1840: FROM ghr_mass_salary_criteria criteria, ghr_mass_salary_criteria_ext ext
1841: WHERE criteria.mass_salary_id = p_msl_id
1842: AND criteria.mass_salary_criteria_id=ext.mass_salary_criteria_id
1843: AND criteria.pay_plan = p_pay_plan
1844: AND criteria.PAY_RATE_DETERMINANT = p_prd

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

1859: -- To calculate percent increase from From Pay and To Pay if rpa_type = 'MPC'.
1860: IF pa_req_rec.rpa_type = 'MPC' THEN
1861: -- Bug#3964284 Get the customized increase percent from History using get_extra_info_comments procedure.
1862: -- If the value is NULL THEN
1863: -- Get the value from the table ghr_mass_salary_criteria_ext.
1864: -- End If;
1865: get_extra_info_comments
1866: (p_person_id => p_person_id,
1867: p_effective_date => p_effective_date,

Line 5246: FROM ghr_mass_salary_criteria criteria, ghr_mass_salary_criteria_ext ext

5242: SELECT criteria.pay_plan pay_plan,
5243: criteria.pay_rate_determinant prd,
5244: ext.increase_percent percent,
5245: ext.grade grade
5246: FROM ghr_mass_salary_criteria criteria, ghr_mass_salary_criteria_ext ext
5247: WHERE criteria.mass_salary_id=p_msl_id
5248: AND criteria.mass_salary_criteria_id=ext.mass_salary_criteria_id;
5249:
5250:

Line 5261: l_pay_calc_msl_percentage ghr_mass_salary_criteria_ext.increase_percent%type;

5257: l_elig_flag BOOLEAN := FALSE;
5258: --
5259: -- Defining the record type variable
5260: --
5261: l_pay_calc_msl_percentage ghr_mass_salary_criteria_ext.increase_percent%type;
5262: l_ses_basic_pay NUMBER;
5263: --
5264: --
5265: