eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PAY_ACCRUAL_PLANS

Line 327: FROM pay_accrual_plans

323: ,c_business_group_id NUMBER) IS
324: SELECT accrual_plan_id
325: ,accrual_plan_element_type_id
326: ,co_formula_id
327: FROM pay_accrual_plans
328: WHERE accrual_plan_name = c_accrual_plan
329: AND business_group_id = c_business_group_id;
330: --
331: CURSOR suspended_asg_end_dt(c_assignment_id NUMBER

Line 353: l_Base_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;

349: l_sort_2 VARCHAR2(30);
350: l_incl_excl NUMBER;
351: l_effective_date DATE;
352:
353: l_Base_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
354: l_childcare_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
355: l_other_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
356: l_sickness_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
357:

Line 354: l_childcare_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;

350: l_incl_excl NUMBER;
351: l_effective_date DATE;
352:
353: l_Base_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
354: l_childcare_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
355: l_other_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
356: l_sickness_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
357:
358: l_accrual_plan_id_1 pay_accrual_plans.accrual_plan_id%TYPE;

Line 355: l_other_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;

351: l_effective_date DATE;
352:
353: l_Base_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
354: l_childcare_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
355: l_other_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
356: l_sickness_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
357:
358: l_accrual_plan_id_1 pay_accrual_plans.accrual_plan_id%TYPE;
359: l_accrual_plan_id_2 pay_accrual_plans.accrual_plan_id%TYPE;

Line 356: l_sickness_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;

352:
353: l_Base_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
354: l_childcare_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
355: l_other_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
356: l_sickness_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
357:
358: l_accrual_plan_id_1 pay_accrual_plans.accrual_plan_id%TYPE;
359: l_accrual_plan_id_2 pay_accrual_plans.accrual_plan_id%TYPE;
360: l_accrual_plan_id_3 pay_accrual_plans.accrual_plan_id%TYPE;

Line 358: l_accrual_plan_id_1 pay_accrual_plans.accrual_plan_id%TYPE;

354: l_childcare_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
355: l_other_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
356: l_sickness_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
357:
358: l_accrual_plan_id_1 pay_accrual_plans.accrual_plan_id%TYPE;
359: l_accrual_plan_id_2 pay_accrual_plans.accrual_plan_id%TYPE;
360: l_accrual_plan_id_3 pay_accrual_plans.accrual_plan_id%TYPE;
361: l_accrual_plan_id_4 pay_accrual_plans.accrual_plan_id%TYPE;
362:

Line 359: l_accrual_plan_id_2 pay_accrual_plans.accrual_plan_id%TYPE;

355: l_other_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
356: l_sickness_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
357:
358: l_accrual_plan_id_1 pay_accrual_plans.accrual_plan_id%TYPE;
359: l_accrual_plan_id_2 pay_accrual_plans.accrual_plan_id%TYPE;
360: l_accrual_plan_id_3 pay_accrual_plans.accrual_plan_id%TYPE;
361: l_accrual_plan_id_4 pay_accrual_plans.accrual_plan_id%TYPE;
362:
363: l_base_holiday NUMBER;

Line 360: l_accrual_plan_id_3 pay_accrual_plans.accrual_plan_id%TYPE;

356: l_sickness_ele_type_id pay_accrual_plans.accrual_plan_element_type_id%TYPE;
357:
358: l_accrual_plan_id_1 pay_accrual_plans.accrual_plan_id%TYPE;
359: l_accrual_plan_id_2 pay_accrual_plans.accrual_plan_id%TYPE;
360: l_accrual_plan_id_3 pay_accrual_plans.accrual_plan_id%TYPE;
361: l_accrual_plan_id_4 pay_accrual_plans.accrual_plan_id%TYPE;
362:
363: l_base_holiday NUMBER;
364: l_base_holiday_prev NUMBER;

Line 361: l_accrual_plan_id_4 pay_accrual_plans.accrual_plan_id%TYPE;

357:
358: l_accrual_plan_id_1 pay_accrual_plans.accrual_plan_id%TYPE;
359: l_accrual_plan_id_2 pay_accrual_plans.accrual_plan_id%TYPE;
360: l_accrual_plan_id_3 pay_accrual_plans.accrual_plan_id%TYPE;
361: l_accrual_plan_id_4 pay_accrual_plans.accrual_plan_id%TYPE;
362:
363: l_base_holiday NUMBER;
364: l_base_holiday_prev NUMBER;
365: l_child_care_holiday NUMBER;

Line 416: l_co_formula_id_1 pay_accrual_plans.co_formula_id%TYPE;

412: l_job_name per_job_definitions.segment1%TYPE;
413:
414: l_calculation_date DATE;
415: l_term_end_date DATE;
416: l_co_formula_id_1 pay_accrual_plans.co_formula_id%TYPE;
417: l_co_formula_id_2 pay_accrual_plans.co_formula_id%TYPE;
418: l_co_formula_id_3 pay_accrual_plans.co_formula_id%TYPE;
419: l_co_formula_id_4 pay_accrual_plans.co_formula_id%TYPE;
420: l_max_co NUMBER;

Line 417: l_co_formula_id_2 pay_accrual_plans.co_formula_id%TYPE;

413:
414: l_calculation_date DATE;
415: l_term_end_date DATE;
416: l_co_formula_id_1 pay_accrual_plans.co_formula_id%TYPE;
417: l_co_formula_id_2 pay_accrual_plans.co_formula_id%TYPE;
418: l_co_formula_id_3 pay_accrual_plans.co_formula_id%TYPE;
419: l_co_formula_id_4 pay_accrual_plans.co_formula_id%TYPE;
420: l_max_co NUMBER;
421: l_dummy DATE;

Line 418: l_co_formula_id_3 pay_accrual_plans.co_formula_id%TYPE;

414: l_calculation_date DATE;
415: l_term_end_date DATE;
416: l_co_formula_id_1 pay_accrual_plans.co_formula_id%TYPE;
417: l_co_formula_id_2 pay_accrual_plans.co_formula_id%TYPE;
418: l_co_formula_id_3 pay_accrual_plans.co_formula_id%TYPE;
419: l_co_formula_id_4 pay_accrual_plans.co_formula_id%TYPE;
420: l_max_co NUMBER;
421: l_dummy DATE;
422: l_sus_asg_end_dt DATE;

Line 419: l_co_formula_id_4 pay_accrual_plans.co_formula_id%TYPE;

415: l_term_end_date DATE;
416: l_co_formula_id_1 pay_accrual_plans.co_formula_id%TYPE;
417: l_co_formula_id_2 pay_accrual_plans.co_formula_id%TYPE;
418: l_co_formula_id_3 pay_accrual_plans.co_formula_id%TYPE;
419: l_co_formula_id_4 pay_accrual_plans.co_formula_id%TYPE;
420: l_max_co NUMBER;
421: l_dummy DATE;
422: l_sus_asg_end_dt DATE;
423: l_emp_enrolment NUMBER;