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_ASSIGNMENT_ACTIONS

Line 156: l_assignment_action_id pay_assignment_actions.assignment_action_id%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
160: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

Line 157: l_assignment_id pay_assignment_actions.assignment_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
160: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
161: l_gre_name hr_organization_units.name%type;

Line 166: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%type;

162: l_organization_id hr_organization_units.organization_id%type;
163: l_org_name hr_organization_units.name%type;
164: l_location_id hr_locations.location_id%type;
165: l_location_code hr_locations.location_code%type;
166: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%type;
167: l_bal_value number(20,2);
168: l_leg_param varchar2(240);
169: l_leg_start_date date;
170: l_leg_end_date date;

Line 733: FROM pay_assignment_actions paa

729: '4' sub_class,
730: pqp_us_ff_functions.get_nonw2_bal('Non W2 FIT Withheld','run',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
731: null,
732: null
733: FROM pay_assignment_actions paa
734: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
735: AND assignment_action_id = l_assignment_action_id
736: UNION ALL
737: SELECT 'EE Non W2 SIT Withheld',

Line 742: FROM pay_assignment_actions paa,

738: '4',
739: pqp_us_ff_functions.get_nonw2_bal('SIT Alien Withheld','run',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,
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

Line 803: FROM pay_assignment_actions paa

799: '4' sub_class,
800: pqp_us_ff_functions.get_nonw2_bal('Non W2 FIT Withheld','run',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
801: null,
802: null
803: FROM pay_assignment_actions paa
804: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
805: AND assignment_action_id = l_assignment_action_id
806: UNION ALL
807: SELECT 'EE Non W2 SIT Withheld',

Line 812: FROM pay_assignment_actions paa,

808: '4',
809: pqp_us_ff_functions.get_nonw2_bal('SIT Alien Withheld','run',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,
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

Line 869: FROM pay_assignment_actions paa

865: ''4'' sub_class,
866: pqp_us_ff_functions.get_nonw2_bal(''Non W2 FIT Withheld'',''run'',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
867: null,
868: null
869: FROM pay_assignment_actions paa
870: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = ''TRUE''
871: AND assignment_action_id = '||l_assignment_action_id ||' UNION ALL
872: SELECT ''EE Non W2 SIT Withheld'' ,
873: ''4'',

Line 878: pay_assignment_actions paa,

874: pqp_us_ff_functions.get_nonw2_bal(''SIT Alien Withheld'',''run'',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,
875: null,
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

Line 1884: pay_assignment_actions paa_ppp,

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
1888: and paa_ppp.action_status = 'C'

Line 1899: pay_assignment_actions paa_chk

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')
1903: and ppa_chk.action_status = 'C';

Line 1998: pay_assignment_actions paa_ppp,

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
2002: and paa_ppp.action_status = 'C'

Line 2063: PAY_ASSIGNMENT_ACTIONS PAA_PPP,

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,
2067: PAY_ACTION_INTERLOCKS PAI_CHK,

Line 2066: PAY_ASSIGNMENT_ACTIONS PAA_CHK,

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
2070: WHERE PAI_RUN.LOCKED_ACTION_ID = p_max_seq_aaid

Line 2090: PAY_ASSIGNMENT_ACTIONS PAA_VOID,

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
2094: AND PAA_VOID.ACTION_STATUS = 'C'

Line 2113: from pay_assignment_actions paa_outer

2109: -- Determine is this assignment_action is the max action sequence.
2110:
2111: select paa_outer.assignment_action_id
2112: into l_max_sequence_aaid
2113: from pay_assignment_actions paa_outer
2114: where (paa_outer.payroll_action_id, paa_outer.action_sequence) =
2115: (select paa1.payroll_action_id,
2116: max(paa1.action_sequence)
2117: from pay_assignment_actions paa1,

Line 2117: from pay_assignment_actions paa1,

2113: from pay_assignment_actions paa_outer
2114: where (paa_outer.payroll_action_id, paa_outer.action_sequence) =
2115: (select paa1.payroll_action_id,
2116: max(paa1.action_sequence)
2117: from pay_assignment_actions paa1,
2118: pay_assignment_actions paa2
2119: where paa1.payroll_action_id = paa2.payroll_action_id
2120: and paa2.assignment_action_id =p_assignment_action_id
2121: and paa1.assignment_id = paa2.assignment_id

Line 2118: pay_assignment_actions paa2

2114: where (paa_outer.payroll_action_id, paa_outer.action_sequence) =
2115: (select paa1.payroll_action_id,
2116: max(paa1.action_sequence)
2117: from pay_assignment_actions paa1,
2118: pay_assignment_actions paa2
2119: where paa1.payroll_action_id = paa2.payroll_action_id
2120: and paa2.assignment_action_id =p_assignment_action_id
2121: and paa1.assignment_id = paa2.assignment_id
2122: -- Bug No 4429173 and paa1.source_action_id is not null

Line 2259: pay_assignment_actions paa,

2255: from
2256: pay_balance_types pbt,
2257: pay_element_types_f pet,
2258: pay_element_classifications pec,
2259: pay_assignment_actions paa,
2260: per_all_assignments_f paf,
2261: pay_us_emp_fed_tax_rules_F pftr,
2262: pay_us_states pst,
2263: pay_run_balances prb,

Line 2308: pay_assignment_actions paa,

2304: from
2305: pay_balance_types pbt,
2306: pay_element_types_f pet,
2307: pay_element_classifications pec,
2308: pay_assignment_actions paa,
2309: per_all_assignments_f paf,
2310: pay_us_emp_fed_tax_rules_F pftr,
2311: pay_us_states pst,
2312: pay_run_results prr

Line 2356: pay_assignment_actions paa,

2352: from
2353: pay_balance_types pbt,
2354: pay_element_types_f pet,
2355: pay_element_classifications pec,
2356: pay_assignment_actions paa,
2357: per_all_assignments_f paf,
2358: pay_us_emp_fed_tax_rules_F pftr,
2359: pay_us_states pst,'
2360: ||l_wc_er_liab_from||

Line 2545: pay_assignment_actions paa1,

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
2549: where ppa_arch.payroll_action_id = l_pactid

Line 2547: pay_assignment_actions paa,

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
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

Line 2568: ,pay_assignment_actions paa

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:
2572: l_future_process_mode VARCHAR2(2) := 'N';

Line 2852: pay_assignment_actions paa1,

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
2856: and paa.chunk_number = l_chunk_no

Line 2882: ,pay_assignment_actions paa

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:
2886: l_future_process_mode VARCHAR2(2) := 'N';