APPS.GHR_MSL_PKG dependencies on GHR_MASS_SALARY_CRITERIA

Line 172: -- from ghr_mass_salary_criteria

168:
169: --
170: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
171: -- Before executing this package
172: -- from ghr_mass_salary_criteria
173: --
174:
175: cursor ghr_msl (p_msl_id number) is
176: select name, effective_date, mass_salary_id, user_table_id, submit_flag,

Line 346: CURSOR cur_pp_prd(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)

342: l_org_name hr_organization_units.name%type;
343:
344: -- Bug 3315432 Madhuri
345: --
346: CURSOR cur_pp_prd(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)
347: IS
348: SELECT pay_plan ,pay_rate_determinant prd
349: FROM ghr_mass_salary_criteria
350: WHERE mass_salary_id=p_msl_id;

Line 349: FROM ghr_mass_salary_criteria

345: --
346: CURSOR cur_pp_prd(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)
347: IS
348: SELECT pay_plan ,pay_rate_determinant prd
349: FROM ghr_mass_salary_criteria
350: WHERE mass_salary_id=p_msl_id;
351:
352:
353: rec_pp_prd pp_prd;

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 2860: FROM ghr_mass_salary_criteria

2856:
2857:
2858: CURSOR msl_dtl_cur (cur_pay_plan varchar2, cur_prd varchar2) IS
2859: SELECT count(*) cnt
2860: FROM ghr_mass_salary_criteria
2861: WHERE mass_salary_id = p_mass_salary_id
2862: AND pay_plan = cur_pay_plan
2863: AND pay_rate_determinant = cur_prd;
2864:

Line 3225: FROM ghr_mass_salary_criteria

3221: ) IS
3222:
3223: CURSOR msl_dtl_cur (cur_pay_plan varchar2, cur_prd varchar2) IS
3224: SELECT count(*) cnt
3225: FROM ghr_mass_salary_criteria
3226: WHERE mass_salary_id = p_mass_salary_id
3227: AND pay_plan = cur_pay_plan
3228: AND pay_rate_determinant = cur_prd;
3229:

Line 3624: from ghr_mass_salary_criteria

3620: return boolean is
3621:
3622: cursor msl_dtl_cur (cur_pay_plan varchar2, cur_prd varchar2) is
3623: select count(*) count
3624: from ghr_mass_salary_criteria
3625: where mass_salary_id = p_mass_salary_id
3626: and pay_plan = cur_pay_plan
3627: and pay_rate_determinant = cur_prd;
3628:

Line 5077: -- from ghr_mass_salary_criteria

5073:
5074: --
5075: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
5076: -- Before executing this package
5077: -- from ghr_mass_salary_criteria
5078:
5079: cursor ghr_msl (p_msl_id number) is
5080: select name, effective_date, mass_salary_id, user_table_id, submit_flag,
5081: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,

Line 5240: CURSOR cur_pp_prd_per_gr(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)

5236: l_org_name hr_organization_units.name%type;
5237:
5238: -- Bug 3315432 Madhuri
5239: --
5240: CURSOR cur_pp_prd_per_gr(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)
5241: IS
5242: SELECT criteria.pay_plan pay_plan,
5243: criteria.pay_rate_determinant prd,
5244: ext.increase_percent percent,

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:

Line 6757: FROM ghr_mass_salary_criteria

6753:
6754:
6755: CURSOR msl_dtl_cur (cur_pay_plan varchar2, cur_prd varchar2) IS
6756: SELECT count(*) cnt
6757: FROM ghr_mass_salary_criteria
6758: WHERE mass_salary_id = p_mass_salary_id
6759: AND pay_plan = cur_pay_plan
6760: AND pay_rate_determinant = cur_prd;
6761:

Line 7213: -- from ghr_mass_salary_criteria

7209:
7210: --
7211: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
7212: -- Before executing this package
7213: -- from ghr_mass_salary_criteria
7214:
7215: cursor ghr_msl (p_msl_id number) is
7216: select name, effective_date, mass_salary_id, user_table_id, submit_flag,
7217: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,

Line 7385: CURSOR cur_pp_prd(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)

7381:
7382: l_essl_table BOOLEAN := FALSE;
7383: l_org_name hr_organization_units.name%type;
7384:
7385: CURSOR cur_pp_prd(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)
7386: IS
7387: SELECT pay_plan ,pay_rate_determinant prd
7388: FROM ghr_mass_salary_criteria
7389: WHERE mass_salary_id=p_msl_id;

Line 7388: FROM ghr_mass_salary_criteria

7384:
7385: CURSOR cur_pp_prd(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)
7386: IS
7387: SELECT pay_plan ,pay_rate_determinant prd
7388: FROM ghr_mass_salary_criteria
7389: WHERE mass_salary_id=p_msl_id;
7390:
7391: rec_pp_prd pp_prd;
7392: