APPS.GHR_MSL_PKG dependencies on GHR_MASS_SALARY_CRITERIA

Line 168: -- from ghr_mass_salary_criteria

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

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

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

Line 345: FROM ghr_mass_salary_criteria

341: --
342: CURSOR cur_pp_prd(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)
343: IS
344: SELECT pay_plan ,pay_rate_determinant prd
345: FROM ghr_mass_salary_criteria
346: WHERE mass_salary_id=p_msl_id;
347:
348:
349: rec_pp_prd pp_prd;

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

2826:
2827:
2828: CURSOR msl_dtl_cur (cur_pay_plan varchar2, cur_prd varchar2) IS
2829: SELECT count(*) cnt
2830: FROM ghr_mass_salary_criteria
2831: WHERE mass_salary_id = p_mass_salary_id
2832: AND pay_plan = cur_pay_plan
2833: AND pay_rate_determinant = cur_prd;
2834:

Line 3192: FROM ghr_mass_salary_criteria

3188: ) IS
3189:
3190: CURSOR msl_dtl_cur (cur_pay_plan varchar2, cur_prd varchar2) IS
3191: SELECT count(*) cnt
3192: FROM ghr_mass_salary_criteria
3193: WHERE mass_salary_id = p_mass_salary_id
3194: AND pay_plan = cur_pay_plan
3195: AND pay_rate_determinant = cur_prd;
3196:

Line 3590: from ghr_mass_salary_criteria

3586: return boolean is
3587:
3588: cursor msl_dtl_cur (cur_pay_plan varchar2, cur_prd varchar2) is
3589: select count(*) count
3590: from ghr_mass_salary_criteria
3591: where mass_salary_id = p_mass_salary_id
3592: and pay_plan = cur_pay_plan
3593: and pay_rate_determinant = cur_prd;
3594:

Line 5015: -- from ghr_mass_salary_criteria

5011:
5012: --
5013: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
5014: -- Before executing this package
5015: -- from ghr_mass_salary_criteria
5016:
5017: cursor ghr_msl (p_msl_id number) is
5018: select name, effective_date, mass_salary_id, user_table_id, submit_flag,
5019: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,

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

5174: l_org_name hr_organization_units.name%type;
5175:
5176: -- Bug 3315432 Madhuri
5177: --
5178: CURSOR cur_pp_prd_per_gr(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)
5179: IS
5180: SELECT criteria.pay_plan pay_plan,
5181: criteria.pay_rate_determinant prd,
5182: ext.increase_percent percent,

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:

Line 6616: FROM ghr_mass_salary_criteria

6612:
6613:
6614: CURSOR msl_dtl_cur (cur_pay_plan varchar2, cur_prd varchar2) IS
6615: SELECT count(*) cnt
6616: FROM ghr_mass_salary_criteria
6617: WHERE mass_salary_id = p_mass_salary_id
6618: AND pay_plan = cur_pay_plan
6619: AND pay_rate_determinant = cur_prd;
6620:

Line 7067: -- from ghr_mass_salary_criteria

7063:
7064: --
7065: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
7066: -- Before executing this package
7067: -- from ghr_mass_salary_criteria
7068:
7069: cursor ghr_msl (p_msl_id number) is
7070: select name, effective_date, mass_salary_id, user_table_id, submit_flag,
7071: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,

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

7235:
7236: l_essl_table BOOLEAN := FALSE;
7237: l_org_name hr_organization_units.name%type;
7238:
7239: CURSOR cur_pp_prd(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)
7240: IS
7241: SELECT pay_plan ,pay_rate_determinant prd
7242: FROM ghr_mass_salary_criteria
7243: WHERE mass_salary_id=p_msl_id;

Line 7242: FROM ghr_mass_salary_criteria

7238:
7239: CURSOR cur_pp_prd(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)
7240: IS
7241: SELECT pay_plan ,pay_rate_determinant prd
7242: FROM ghr_mass_salary_criteria
7243: WHERE mass_salary_id=p_msl_id;
7244:
7245: rec_pp_prd pp_prd;
7246: