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_GTNLOD_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 150: l_start_date pay_payroll_actions.start_date%type;

146: which are not eligible for Pre-payments will not get dislayed in
147: 'Unprocessed Pre-Payments' section in US Gross To Net Report.
148: */
149: ------------------------------------- Global Varaibles ---------------------------
150: l_start_date pay_payroll_actions.start_date%type;
151: l_end_date pay_payroll_actions.effective_date%type;
152: l_business_group_id pay_payroll_actions.business_group_id%type;
153: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
154: l_effective_date pay_payroll_actions.effective_date%type;

Line 151: l_end_date pay_payroll_actions.effective_date%type;

147: 'Unprocessed Pre-Payments' section in US Gross To Net Report.
148: */
149: ------------------------------------- Global Varaibles ---------------------------
150: l_start_date pay_payroll_actions.start_date%type;
151: l_end_date pay_payroll_actions.effective_date%type;
152: l_business_group_id pay_payroll_actions.business_group_id%type;
153: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
154: l_effective_date pay_payroll_actions.effective_date%type;
155: l_action_type pay_payroll_actions.action_type%type;

Line 152: l_business_group_id pay_payroll_actions.business_group_id%type;

148: */
149: ------------------------------------- Global Varaibles ---------------------------
150: l_start_date pay_payroll_actions.start_date%type;
151: l_end_date pay_payroll_actions.effective_date%type;
152: l_business_group_id pay_payroll_actions.business_group_id%type;
153: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
154: l_effective_date pay_payroll_actions.effective_date%type;
155: l_action_type pay_payroll_actions.action_type%type;
156: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

Line 153: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

149: ------------------------------------- Global Varaibles ---------------------------
150: l_start_date pay_payroll_actions.start_date%type;
151: l_end_date pay_payroll_actions.effective_date%type;
152: l_business_group_id pay_payroll_actions.business_group_id%type;
153: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
154: l_effective_date pay_payroll_actions.effective_date%type;
155: l_action_type pay_payroll_actions.action_type%type;
156: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
157: l_assignment_id pay_assignment_actions.assignment_id%type;

Line 154: l_effective_date pay_payroll_actions.effective_date%type;

150: l_start_date pay_payroll_actions.start_date%type;
151: l_end_date pay_payroll_actions.effective_date%type;
152: l_business_group_id pay_payroll_actions.business_group_id%type;
153: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
154: l_effective_date pay_payroll_actions.effective_date%type;
155: l_action_type pay_payroll_actions.action_type%type;
156: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
157: l_assignment_id pay_assignment_actions.assignment_id%type;
158: l_tax_unit_id hr_organization_units.organization_id%type;

Line 155: l_action_type pay_payroll_actions.action_type%type;

151: l_end_date pay_payroll_actions.effective_date%type;
152: l_business_group_id pay_payroll_actions.business_group_id%type;
153: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
154: l_effective_date pay_payroll_actions.effective_date%type;
155: l_action_type pay_payroll_actions.action_type%type;
156: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
157: l_assignment_id pay_assignment_actions.assignment_id%type;
158: l_tax_unit_id hr_organization_units.organization_id%type;
159: l_person_id per_all_people_f.person_id%TYPE; -- #1937448

Line 174: t_payroll_action_id pay_payroll_actions.payroll_action_id%type;

170: l_leg_end_date date;
171: t_payroll_id number(15);
172: t_consolidation_set_id number(15);
173: t_gre_id number(15);
174: t_payroll_action_id pay_payroll_actions.payroll_action_id%type;
175: l_defined_balance_id number;
176: l_row_count number;
177: l_full_name per_all_people_f.full_name%TYPE;
178: l_asg_flag varchar2(1);

Line 744: pay_payroll_actions ppa

740: null,
741: null
742: FROM pay_assignment_actions paa,
743: pay_us_emp_state_tax_rules_f state,
744: pay_payroll_actions ppa
745: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
746: AND state.assignment_id = paa.assignment_id
747: AND ppa.payroll_action_id = paa.payroll_action_id
748: AND paa.assignment_action_id =l_assignment_action_id

Line 814: pay_payroll_actions ppa

810: null,
811: null
812: FROM pay_assignment_actions paa,
813: pay_us_emp_state_tax_rules_f state,
814: pay_payroll_actions ppa
815: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
816: AND state.assignment_id = paa.assignment_id
817: AND ppa.payroll_action_id = paa.payroll_action_id
818: AND paa.assignment_action_id =l_assignment_action_id

Line 880: pay_payroll_actions ppa

876: null
877: FROM
878: pay_assignment_actions paa,
879: pay_us_emp_state_tax_rules_f state,
880: pay_payroll_actions ppa
881: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = ''TRUE''
882: AND state.assignment_id = paa.assignment_id
883: AND ppa.payroll_action_id = paa.payroll_action_id
884: AND paa.assignment_action_id ='|| l_assignment_action_id||

Line 1883: pay_payroll_actions ppa_ppp,

1879:
1880: cursor ppp_action is
1881: select ppp.pre_payment_id pre_payment_id
1882: from pay_pre_payments ppp,
1883: pay_payroll_actions ppa_ppp,
1884: pay_assignment_actions paa_ppp,
1885: pay_action_interlocks pai
1886: where pai.locked_action_id = l_assignment_action_id
1887: and paa_ppp.assignment_action_id = pai.locking_action_id

Line 1898: from pay_payroll_actions ppa_chk,

1894:
1895:
1896: cursor chk_ppp ( l_ppp_pre_payment_id number) is
1897: select '1' found
1898: from pay_payroll_actions ppa_chk,
1899: pay_assignment_actions paa_chk
1900: where paa_chk.pre_payment_id = l_ppp_pre_payment_id
1901: and ppa_chk.payroll_action_id = paa_chk.payroll_action_id
1902: and ppa_chk.action_type in ('H','M','E')

Line 1997: from pay_payroll_actions ppa_ppp,

1993: BEGIN
1994: /* bug 3774591 first change */
1995: select 'X'
1996: into l_dummy_var
1997: from pay_payroll_actions ppa_ppp,
1998: pay_assignment_actions paa_ppp,
1999: pay_action_interlocks pai
2000: where pai.locked_action_id = l_assignment_action_id
2001: and paa_ppp.assignment_action_id = pai.locking_action_id

Line 2062: from PAY_PAYROLL_ACTIONS PPA_PPP,

2058: select PAA_PPP.ASSIGNMENT_ACTION_ID PRE_PAY_AAID,
2059: POPM.ORG_PAYMENT_METHOD_NAME PMT_NAME,
2060: PPP.VALUE VALUE,
2061: PPP.PRE_PAYMENT_ID PMT_ID
2062: from PAY_PAYROLL_ACTIONS PPA_PPP,
2063: PAY_ASSIGNMENT_ACTIONS PAA_PPP,
2064: PAY_ACTION_INTERLOCKS PAI_RUN,
2065: PAY_PAYROLL_ACTIONS PPA_CHK,
2066: PAY_ASSIGNMENT_ACTIONS PAA_CHK,

Line 2065: PAY_PAYROLL_ACTIONS PPA_CHK,

2061: PPP.PRE_PAYMENT_ID PMT_ID
2062: from PAY_PAYROLL_ACTIONS PPA_PPP,
2063: PAY_ASSIGNMENT_ACTIONS PAA_PPP,
2064: PAY_ACTION_INTERLOCKS PAI_RUN,
2065: PAY_PAYROLL_ACTIONS PPA_CHK,
2066: PAY_ASSIGNMENT_ACTIONS PAA_CHK,
2067: PAY_ACTION_INTERLOCKS PAI_CHK,
2068: PAY_ORG_PAYMENT_METHODS_F POPM,
2069: PAY_PRE_PAYMENTS PPP

Line 2089: FROM PAY_PAYROLL_ACTIONS PPA_VOID,

2085: AND PPA_CHK.ACTION_STATUS = 'C'
2086: AND PPA_CHK.ACTION_TYPE IN ('H', 'M')
2087: AND NOT EXISTS
2088: (SELECT NULL
2089: FROM PAY_PAYROLL_ACTIONS PPA_VOID,
2090: PAY_ASSIGNMENT_ACTIONS PAA_VOID,
2091: PAY_ACTION_INTERLOCKS PAI_VOID
2092: WHERE PAI_VOID.LOCKED_ACTION_ID = PAA_CHK.ASSIGNMENT_ACTION_ID
2093: AND PAA_VOID.ASSIGNMENT_ACTION_ID = PAI_VOID.LOCKING_ACTION_ID

Line 2544: pay_payroll_actions ppa,

2540: from hr_locations_all hrl,
2541: hr_all_organization_units hou1,
2542: hr_all_organization_units hou,
2543: per_assignments_f paf,
2544: pay_payroll_actions ppa,
2545: pay_assignment_actions paa1,
2546: pay_action_interlocks pai,
2547: pay_assignment_actions paa,
2548: pay_payroll_actions ppa_arch

Line 2548: pay_payroll_actions ppa_arch

2544: pay_payroll_actions ppa,
2545: pay_assignment_actions paa1,
2546: pay_action_interlocks pai,
2547: pay_assignment_actions paa,
2548: pay_payroll_actions ppa_arch
2549: where ppa_arch.payroll_action_id = l_pactid
2550: and paa.payroll_action_id = ppa_arch.payroll_action_id
2551: and paa.chunk_number = l_chnkno
2552: and pai.locking_action_id = paa.assignment_action_id

Line 2563: pay_payroll_actions table. */

2559: and hou1.organization_id = paf.organization_id
2560: and hou.organization_id = paa1.tax_unit_id;
2561:
2562: /* Bug 14733154 - This cursor fetch 'future_process_mode' value from
2563: pay_payroll_actions table. */
2564: cursor get_future_process_mode(l_asgactid number)
2565: is
2566: SELECT ppa.future_process_mode
2567: FROM pay_payroll_actions ppa

Line 2567: FROM pay_payroll_actions ppa

2563: pay_payroll_actions table. */
2564: cursor get_future_process_mode(l_asgactid number)
2565: is
2566: SELECT ppa.future_process_mode
2567: FROM pay_payroll_actions ppa
2568: ,pay_assignment_actions paa
2569: WHERE paa.assignment_action_id = l_asgactid
2570: AND ppa.payroll_action_id = paa.payroll_action_id;
2571:

Line 2610: from pay_payroll_actions ppa

2606: t_consolidation_set_id,
2607: t_payroll_id,
2608: t_gre_id,
2609: t_payroll_action_id
2610: from pay_payroll_actions ppa
2611: where ppa.payroll_action_id = pactid;
2612: exception when no_data_found then
2613: hr_utility.trace('Legislative Details not found...');
2614: raise;

Line 2851: pay_payroll_actions ppa,

2847: from hr_locations_all hrl,
2848: hr_all_organization_units hou1,
2849: hr_all_organization_units hou,
2850: per_assignments_f paf,
2851: pay_payroll_actions ppa,
2852: pay_assignment_actions paa1,
2853: pay_temp_object_actions paa,
2854: pay_payroll_actions ppa_arch
2855: where paa.payroll_action_id = l_pactid

Line 2854: pay_payroll_actions ppa_arch

2850: per_assignments_f paf,
2851: pay_payroll_actions ppa,
2852: pay_assignment_actions paa1,
2853: pay_temp_object_actions paa,
2854: pay_payroll_actions ppa_arch
2855: where paa.payroll_action_id = l_pactid
2856: and paa.chunk_number = l_chunk_no
2857: and paa.payroll_action_id = ppa_arch.payroll_action_id
2858: and paa.object_id = paa1.assignment_action_id

Line 2877: pay_payroll_actions table. */

2873: and l_effective_date between ppf.effective_start_date and ppf.effective_end_date;
2874: l_chnk_number number;
2875:
2876: /* Bug 14733154 - This cursor fetch 'future_process_mode' value from
2877: pay_payroll_actions table. */
2878: cursor get_future_process_mode(l_asgactid number)
2879: is
2880: SELECT ppa.future_process_mode
2881: FROM pay_payroll_actions ppa

Line 2881: FROM pay_payroll_actions ppa

2877: pay_payroll_actions table. */
2878: cursor get_future_process_mode(l_asgactid number)
2879: is
2880: SELECT ppa.future_process_mode
2881: FROM pay_payroll_actions ppa
2882: ,pay_assignment_actions paa
2883: WHERE paa.assignment_action_id = l_asgactid
2884: AND ppa.payroll_action_id = paa.payroll_action_id;
2885:

Line 2976: from pay_payroll_actions ppa

2972: t_consolidation_set_id,
2973: t_payroll_id,
2974: t_gre_id,
2975: t_payroll_action_id
2976: from pay_payroll_actions ppa
2977: where ppa.payroll_action_id = l_payroll_action_id;
2978: exception when no_data_found then
2979: hr_utility.trace('Legislative Details not found...');
2980: raise;