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 126: l_start_date pay_payroll_actions.start_date%type;

122: 16-OCT-2006 jdevasah 115.46 Bug 6998211: Restricted GRE Name to 228 chars as report showing
123: blank when we give gre_name more than 228 chars.
124: */
125: ------------------------------------- Global Varaibles ---------------------------
126: l_start_date pay_payroll_actions.start_date%type;
127: l_end_date pay_payroll_actions.effective_date%type;
128: l_business_group_id pay_payroll_actions.business_group_id%type;
129: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
130: l_effective_date pay_payroll_actions.effective_date%type;

Line 127: l_end_date pay_payroll_actions.effective_date%type;

123: blank when we give gre_name more than 228 chars.
124: */
125: ------------------------------------- Global Varaibles ---------------------------
126: l_start_date pay_payroll_actions.start_date%type;
127: l_end_date pay_payroll_actions.effective_date%type;
128: l_business_group_id pay_payroll_actions.business_group_id%type;
129: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
130: l_effective_date pay_payroll_actions.effective_date%type;
131: l_action_type pay_payroll_actions.action_type%type;

Line 128: l_business_group_id pay_payroll_actions.business_group_id%type;

124: */
125: ------------------------------------- Global Varaibles ---------------------------
126: l_start_date pay_payroll_actions.start_date%type;
127: l_end_date pay_payroll_actions.effective_date%type;
128: l_business_group_id pay_payroll_actions.business_group_id%type;
129: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
130: l_effective_date pay_payroll_actions.effective_date%type;
131: l_action_type pay_payroll_actions.action_type%type;
132: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

Line 129: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

125: ------------------------------------- Global Varaibles ---------------------------
126: l_start_date pay_payroll_actions.start_date%type;
127: l_end_date pay_payroll_actions.effective_date%type;
128: l_business_group_id pay_payroll_actions.business_group_id%type;
129: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
130: l_effective_date pay_payroll_actions.effective_date%type;
131: l_action_type pay_payroll_actions.action_type%type;
132: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
133: l_assignment_id pay_assignment_actions.assignment_id%type;

Line 130: l_effective_date pay_payroll_actions.effective_date%type;

126: l_start_date pay_payroll_actions.start_date%type;
127: l_end_date pay_payroll_actions.effective_date%type;
128: l_business_group_id pay_payroll_actions.business_group_id%type;
129: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
130: l_effective_date pay_payroll_actions.effective_date%type;
131: l_action_type pay_payroll_actions.action_type%type;
132: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
133: l_assignment_id pay_assignment_actions.assignment_id%type;
134: l_tax_unit_id hr_organization_units.organization_id%type;

Line 131: l_action_type pay_payroll_actions.action_type%type;

127: l_end_date pay_payroll_actions.effective_date%type;
128: l_business_group_id pay_payroll_actions.business_group_id%type;
129: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
130: l_effective_date pay_payroll_actions.effective_date%type;
131: l_action_type pay_payroll_actions.action_type%type;
132: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
133: l_assignment_id pay_assignment_actions.assignment_id%type;
134: l_tax_unit_id hr_organization_units.organization_id%type;
135: l_person_id per_all_people_f.person_id%TYPE; -- #1937448

Line 150: t_payroll_action_id pay_payroll_actions.payroll_action_id%type;

146: l_leg_end_date date;
147: t_payroll_id number(15);
148: t_consolidation_set_id number(15);
149: t_gre_id number(15);
150: t_payroll_action_id pay_payroll_actions.payroll_action_id%type;
151: l_defined_balance_id number;
152: l_row_count number;
153: l_full_name per_all_people_f.full_name%TYPE;
154: l_asg_flag varchar2(1);

Line 628: pay_payroll_actions ppa

624: null,
625: null
626: FROM pay_assignment_actions paa,
627: pay_us_emp_state_tax_rules_f state,
628: pay_payroll_actions ppa
629: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
630: AND state.assignment_id = paa.assignment_id
631: AND ppa.payroll_action_id = paa.payroll_action_id
632: AND paa.assignment_action_id =l_assignment_action_id

Line 680: pay_payroll_actions ppa

676: null,
677: null
678: FROM pay_assignment_actions paa,
679: pay_us_emp_state_tax_rules_f state,
680: pay_payroll_actions ppa
681: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
682: AND state.assignment_id = paa.assignment_id
683: AND ppa.payroll_action_id = paa.payroll_action_id
684: AND paa.assignment_action_id =l_assignment_action_id

Line 745: pay_payroll_actions ppa

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

Line 1704: pay_payroll_actions ppa_ppp,

1700:
1701: cursor ppp_action is
1702: select ppp.pre_payment_id pre_payment_id
1703: from pay_pre_payments ppp,
1704: pay_payroll_actions ppa_ppp,
1705: pay_assignment_actions paa_ppp,
1706: pay_action_interlocks pai
1707: where pai.locked_action_id = l_assignment_action_id
1708: and paa_ppp.assignment_action_id = pai.locking_action_id

Line 1719: from pay_payroll_actions ppa_chk,

1715:
1716:
1717: cursor chk_ppp ( l_ppp_pre_payment_id number) is
1718: select '1' found
1719: from pay_payroll_actions ppa_chk,
1720: pay_assignment_actions paa_chk
1721: where paa_chk.pre_payment_id = l_ppp_pre_payment_id
1722: and ppa_chk.payroll_action_id = paa_chk.payroll_action_id
1723: and ppa_chk.action_type in ('H','M','E')

Line 1818: from pay_payroll_actions ppa_ppp,

1814: BEGIN
1815: /* bug 3774591 first change */
1816: select 'X'
1817: into l_dummy_var
1818: from pay_payroll_actions ppa_ppp,
1819: pay_assignment_actions paa_ppp,
1820: pay_action_interlocks pai
1821: where pai.locked_action_id = l_assignment_action_id
1822: and paa_ppp.assignment_action_id = pai.locking_action_id

Line 1883: from PAY_PAYROLL_ACTIONS PPA_PPP,

1879: select PAA_PPP.ASSIGNMENT_ACTION_ID PRE_PAY_AAID,
1880: POPM.ORG_PAYMENT_METHOD_NAME PMT_NAME,
1881: PPP.VALUE VALUE,
1882: PPP.PRE_PAYMENT_ID PMT_ID
1883: from PAY_PAYROLL_ACTIONS PPA_PPP,
1884: PAY_ASSIGNMENT_ACTIONS PAA_PPP,
1885: PAY_ACTION_INTERLOCKS PAI_RUN,
1886: PAY_PAYROLL_ACTIONS PPA_CHK,
1887: PAY_ASSIGNMENT_ACTIONS PAA_CHK,

Line 1886: PAY_PAYROLL_ACTIONS PPA_CHK,

1882: PPP.PRE_PAYMENT_ID PMT_ID
1883: from PAY_PAYROLL_ACTIONS PPA_PPP,
1884: PAY_ASSIGNMENT_ACTIONS PAA_PPP,
1885: PAY_ACTION_INTERLOCKS PAI_RUN,
1886: PAY_PAYROLL_ACTIONS PPA_CHK,
1887: PAY_ASSIGNMENT_ACTIONS PAA_CHK,
1888: PAY_ACTION_INTERLOCKS PAI_CHK,
1889: PAY_ORG_PAYMENT_METHODS_F POPM,
1890: PAY_PRE_PAYMENTS PPP

Line 1910: FROM PAY_PAYROLL_ACTIONS PPA_VOID,

1906: AND PPA_CHK.ACTION_STATUS = 'C'
1907: AND PPA_CHK.ACTION_TYPE IN ('H', 'M')
1908: AND NOT EXISTS
1909: (SELECT NULL
1910: FROM PAY_PAYROLL_ACTIONS PPA_VOID,
1911: PAY_ASSIGNMENT_ACTIONS PAA_VOID,
1912: PAY_ACTION_INTERLOCKS PAI_VOID
1913: WHERE PAI_VOID.LOCKED_ACTION_ID = PAA_CHK.ASSIGNMENT_ACTION_ID
1914: AND PAA_VOID.ASSIGNMENT_ACTION_ID = PAI_VOID.LOCKING_ACTION_ID

Line 2361: pay_payroll_actions ppa,

2357: from hr_locations_all hrl,
2358: hr_all_organization_units hou1,
2359: hr_all_organization_units hou,
2360: per_assignments_f paf,
2361: pay_payroll_actions ppa,
2362: pay_assignment_actions paa1,
2363: pay_action_interlocks pai,
2364: pay_assignment_actions paa,
2365: pay_payroll_actions ppa_arch

Line 2365: pay_payroll_actions ppa_arch

2361: pay_payroll_actions ppa,
2362: pay_assignment_actions paa1,
2363: pay_action_interlocks pai,
2364: pay_assignment_actions paa,
2365: pay_payroll_actions ppa_arch
2366: where ppa_arch.payroll_action_id = l_pactid
2367: and paa.payroll_action_id = ppa_arch.payroll_action_id
2368: and paa.chunk_number = l_chnkno
2369: and pai.locking_action_id = paa.assignment_action_id

Line 2415: from pay_payroll_actions ppa

2411: t_consolidation_set_id,
2412: t_payroll_id,
2413: t_gre_id,
2414: t_payroll_action_id
2415: from pay_payroll_actions ppa
2416: where ppa.payroll_action_id = pactid;
2417: exception when no_data_found then
2418: hr_utility.trace('Legislative Details not found...');
2419: raise;

Line 2639: pay_payroll_actions ppa,

2635: from hr_locations_all hrl,
2636: hr_all_organization_units hou1,
2637: hr_all_organization_units hou,
2638: per_assignments_f paf,
2639: pay_payroll_actions ppa,
2640: pay_assignment_actions paa1,
2641: pay_temp_object_actions paa,
2642: pay_payroll_actions ppa_arch
2643: where paa.payroll_action_id = l_pactid

Line 2642: pay_payroll_actions ppa_arch

2638: per_assignments_f paf,
2639: pay_payroll_actions ppa,
2640: pay_assignment_actions paa1,
2641: pay_temp_object_actions paa,
2642: pay_payroll_actions ppa_arch
2643: where paa.payroll_action_id = l_pactid
2644: and paa.chunk_number = l_chunk_no
2645: and paa.payroll_action_id = ppa_arch.payroll_action_id
2646: and paa.object_id = paa1.assignment_action_id

Line 2751: from pay_payroll_actions ppa

2747: t_consolidation_set_id,
2748: t_payroll_id,
2749: t_gre_id,
2750: t_payroll_action_id
2751: from pay_payroll_actions ppa
2752: where ppa.payroll_action_id = l_payroll_action_id;
2753: exception when no_data_found then
2754: hr_utility.trace('Legislative Details not found...');
2755: raise;