[Home] [Help]
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
136: l_assignment_number per_all_assignments_f.assignment_number%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
136: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
137: l_gre_name hr_organization_units.name%type;
138: l_organization_id hr_organization_units.organization_id%type;
139: l_org_name hr_organization_units.name%type;
140: l_location_id hr_locations.location_id%type;
141: l_location_code hr_locations.location_code%type;
142: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%type;
143: l_bal_value number(20,2);
144: l_leg_param varchar2(240);
145: l_leg_start_date date;
146: l_leg_end_date date;
613: '4' sub_class,
614: pqp_us_ff_functions.get_nonw2_bal('Non W2 FIT Withheld','run',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
615: null,
616: null
617: FROM pay_assignment_actions paa
618: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
619: AND assignment_action_id = l_assignment_action_id
620: UNION ALL
621: SELECT 'EE Non W2 SIT Withheld',
622: '4',
623: pqp_us_ff_functions.get_nonw2_bal('SIT Alien Withheld','run',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,
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
665: '4' sub_class,
666: pqp_us_ff_functions.get_nonw2_bal('Non W2 FIT Withheld','run',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
667: null,
668: null
669: FROM pay_assignment_actions paa
670: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
671: AND assignment_action_id = l_assignment_action_id
672: UNION ALL
673: SELECT 'EE Non W2 SIT Withheld',
674: '4',
675: pqp_us_ff_functions.get_nonw2_bal('SIT Alien Withheld','run',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,
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
730: ''4'' sub_class,
731: pqp_us_ff_functions.get_nonw2_bal(''Non W2 FIT Withheld'',''run'',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
732: null,
733: null
734: FROM pay_assignment_actions paa
735: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = ''TRUE''
736: AND assignment_action_id = '||l_assignment_action_id ||' UNION ALL
737: SELECT ''EE Non W2 SIT Withheld'' ,
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
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
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
1709: and paa_ppp.action_status = 'C'
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')
1724: and ppa_chk.action_status = 'C';
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
1823: and paa_ppp.action_status = 'C'
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,
1888: PAY_ACTION_INTERLOCKS PAI_CHK,
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
1891: WHERE PAI_RUN.LOCKED_ACTION_ID = p_max_seq_aaid
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
1915: AND PAA_VOID.ACTION_STATUS = 'C'
1930: -- Determine is this assignment_action is the max action sequence.
1931:
1932: select paa_outer.assignment_action_id
1933: into l_max_sequence_aaid
1934: from pay_assignment_actions paa_outer
1935: where (paa_outer.payroll_action_id, paa_outer.action_sequence) =
1936: (select paa1.payroll_action_id,
1937: max(paa1.action_sequence)
1938: from pay_assignment_actions paa1,
1934: from pay_assignment_actions paa_outer
1935: where (paa_outer.payroll_action_id, paa_outer.action_sequence) =
1936: (select paa1.payroll_action_id,
1937: max(paa1.action_sequence)
1938: from pay_assignment_actions paa1,
1939: pay_assignment_actions paa2
1940: where paa1.payroll_action_id = paa2.payroll_action_id
1941: and paa2.assignment_action_id =p_assignment_action_id
1942: and paa1.assignment_id = paa2.assignment_id
1935: where (paa_outer.payroll_action_id, paa_outer.action_sequence) =
1936: (select paa1.payroll_action_id,
1937: max(paa1.action_sequence)
1938: from pay_assignment_actions paa1,
1939: pay_assignment_actions paa2
1940: where paa1.payroll_action_id = paa2.payroll_action_id
1941: and paa2.assignment_action_id =p_assignment_action_id
1942: and paa1.assignment_id = paa2.assignment_id
1943: -- Bug No 4429173 and paa1.source_action_id is not null
2074: from
2075: pay_balance_types pbt,
2076: pay_element_types_f pet,
2077: pay_element_classifications pec,
2078: pay_assignment_actions paa,
2079: per_all_assignments_f paf,
2080: pay_us_emp_fed_tax_rules_F pftr,
2081: pay_us_states pst,
2082: pay_run_balances prb,
2121: from
2122: pay_balance_types pbt,
2123: pay_element_types_f pet,
2124: pay_element_classifications pec,
2125: pay_assignment_actions paa,
2126: per_all_assignments_f paf,
2127: pay_us_emp_fed_tax_rules_F pftr,
2128: pay_us_states pst,
2129: pay_run_results prr
2169: from
2170: pay_balance_types pbt,
2171: pay_element_types_f pet,
2172: pay_element_classifications pec,
2173: pay_assignment_actions paa,
2174: per_all_assignments_f paf,
2175: pay_us_emp_fed_tax_rules_F pftr,
2176: pay_us_states pst,'
2177: ||l_wc_er_liab_from||
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
2366: where ppa_arch.payroll_action_id = l_pactid
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
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
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
2644: and paa.chunk_number = l_chunk_no