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.PAY_US_RSRW_UPGREV dependencies on PAY_ELEMENT_TYPES_F

Line 2337: FROM pay_element_types_f

2333: CURSOR get_ele_typ_id(cp_ele_name IN VARCHAR2) IS
2334: SELECT element_type_id
2335: ,element_name
2336: ,proration_group_id
2337: FROM pay_element_types_f
2338: WHERE element_name = cp_ele_name
2339: AND legislation_code = 'US'
2340: AND business_group_id IS NULL
2341: AND element_information_category = 'US_EARNINGS'

Line 2368: lv_rs_ele_name pay_element_types_f.element_name%TYPE;

2364: -- Local Variable Declaration
2365: l_date_of_mig date;
2366: ln_proration_event_grp_id pay_event_groups.event_group_id%TYPE;
2367: ln_rs_ele_typ_id number;
2368: lv_rs_ele_name pay_element_types_f.element_name%TYPE;
2369: ln_rs_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2370: ln_rw_ele_typ_id number;
2371: lv_rw_ele_name pay_element_types_f.element_name%TYPE;
2372: ln_rw_proration_grp_id pay_element_types_f.proration_group_id%TYPE;

Line 2369: ln_rs_proration_grp_id pay_element_types_f.proration_group_id%TYPE;

2365: l_date_of_mig date;
2366: ln_proration_event_grp_id pay_event_groups.event_group_id%TYPE;
2367: ln_rs_ele_typ_id number;
2368: lv_rs_ele_name pay_element_types_f.element_name%TYPE;
2369: ln_rs_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2370: ln_rw_ele_typ_id number;
2371: lv_rw_ele_name pay_element_types_f.element_name%TYPE;
2372: ln_rw_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2373: lv_upg_status varchar2(30);

Line 2371: lv_rw_ele_name pay_element_types_f.element_name%TYPE;

2367: ln_rs_ele_typ_id number;
2368: lv_rs_ele_name pay_element_types_f.element_name%TYPE;
2369: ln_rs_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2370: ln_rw_ele_typ_id number;
2371: lv_rw_ele_name pay_element_types_f.element_name%TYPE;
2372: ln_rw_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2373: lv_upg_status varchar2(30);
2374: ln_dbg_step number;
2375:

Line 2372: ln_rw_proration_grp_id pay_element_types_f.proration_group_id%TYPE;

2368: lv_rs_ele_name pay_element_types_f.element_name%TYPE;
2369: ln_rs_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2370: ln_rw_ele_typ_id number;
2371: lv_rw_ele_name pay_element_types_f.element_name%TYPE;
2372: ln_rw_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2373: lv_upg_status varchar2(30);
2374: ln_dbg_step number;
2375:
2376: begin

Line 2448: update pay_element_types_f

2444: BEGIN
2445:
2446: ln_dbg_step := 1;
2447:
2448: update pay_element_types_f
2449: set proration_group_id = ln_proration_event_grp_id
2450: where element_name in ('Regular Salary', 'Regular Wages')
2451: AND business_group_id IS NULL
2452: AND legislation_code = 'US'

Line 2538: update pay_element_types_f

2534: BEGIN
2535:
2536: ln_dbg_step := 4;
2537:
2538: update pay_element_types_f
2539: set proration_group_id = ln_proration_event_grp_id
2540: where element_name in ('Regular Salary', 'Regular Wages')
2541: AND business_group_id IS NULL
2542: AND legislation_code = 'US'

Line 2588: FROM pay_element_types_f

2584: CURSOR get_ele_typ_id(cp_ele_name IN VARCHAR2) IS
2585: SELECT element_type_id
2586: ,element_name
2587: ,proration_group_id
2588: FROM pay_element_types_f
2589: WHERE element_name = cp_ele_name
2590: AND legislation_code = 'US'
2591: AND business_group_id IS NULL
2592: AND element_information_category = 'US_EARNINGS'

Line 2609: lv_rs_ele_name pay_element_types_f.element_name%TYPE;

2605:
2606: -- Local Variable Declaration
2607: l_date_of_mig date;
2608: ln_rs_ele_typ_id number;
2609: lv_rs_ele_name pay_element_types_f.element_name%TYPE;
2610: ln_rs_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2611: ln_rw_ele_typ_id number;
2612: lv_rw_ele_name pay_element_types_f.element_name%TYPE;
2613: ln_rw_proration_grp_id pay_element_types_f.proration_group_id%TYPE;

Line 2610: ln_rs_proration_grp_id pay_element_types_f.proration_group_id%TYPE;

2606: -- Local Variable Declaration
2607: l_date_of_mig date;
2608: ln_rs_ele_typ_id number;
2609: lv_rs_ele_name pay_element_types_f.element_name%TYPE;
2610: ln_rs_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2611: ln_rw_ele_typ_id number;
2612: lv_rw_ele_name pay_element_types_f.element_name%TYPE;
2613: ln_rw_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2614: ln_proration_event_grp_id pay_event_groups.event_group_id%TYPE;

Line 2612: lv_rw_ele_name pay_element_types_f.element_name%TYPE;

2608: ln_rs_ele_typ_id number;
2609: lv_rs_ele_name pay_element_types_f.element_name%TYPE;
2610: ln_rs_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2611: ln_rw_ele_typ_id number;
2612: lv_rw_ele_name pay_element_types_f.element_name%TYPE;
2613: ln_rw_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2614: ln_proration_event_grp_id pay_event_groups.event_group_id%TYPE;
2615: lv_upg_status varchar2(30);
2616: ln_upg_defn_id NUMBER;

Line 2613: ln_rw_proration_grp_id pay_element_types_f.proration_group_id%TYPE;

2609: lv_rs_ele_name pay_element_types_f.element_name%TYPE;
2610: ln_rs_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2611: ln_rw_ele_typ_id number;
2612: lv_rw_ele_name pay_element_types_f.element_name%TYPE;
2613: ln_rw_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2614: ln_proration_event_grp_id pay_event_groups.event_group_id%TYPE;
2615: lv_upg_status varchar2(30);
2616: ln_upg_defn_id NUMBER;
2617: ln_dbg_step NUMBER;

Line 2675: update pay_element_types_f

2671: /* Update Proration Group */
2672:
2673: ln_dbg_step := 1;
2674:
2675: update pay_element_types_f
2676: set proration_group_id = NULL
2677: where element_name in ('Regular Salary', 'Regular Wages')
2678: and business_group_id is null
2679: and legislation_code = 'US'

Line 2795: FROM pay_element_types_f pet

2791:
2792: CURSOR csr_get_ele_xtra_info(cp_eletyp_ctx_id in number)
2793: IS
2794: SELECT petei.eei_information11
2795: FROM pay_element_types_f pet
2796: ,pay_element_type_extra_info petei
2797: where pet.element_type_id = cp_eletyp_ctx_id
2798: and pet.element_type_id = petei.element_type_id
2799: and petei.information_type = 'US_EARNINGS'