[Home] [Help]
773: )
774: AND EXISTS (SELECT /*+ ORDERED */
775: /* the ordered hint will force the paa table to be joined to first */
776: NULL
777: FROM pay_assignment_actions paa
778: , pay_payroll_actions ppa
779: , per_time_periods ptp
780: WHERE paa.assignment_id = asg.assignment_id
781: AND paa.payroll_action_id = ppa.payroll_action_id
905: */
906: if asg_include = TRUE then
907: -- Create one assignment action for every assignment
908: hr_utility.set_location('Archiving for assignment_id '||asgrec.assignment_id, 50);
909: select pay_assignment_actions_s.nextval
910: into lockingactid
911: from dual;
912:
913: -- Insert assignment into pay_assignment_actions
909: select pay_assignment_actions_s.nextval
910: into lockingactid
911: from dual;
912:
913: -- Insert assignment into pay_assignment_actions
914: hr_nonrun_asact.insact
915: (
916: lockingactid,
917: asgrec.assignment_id,
1041: cursor curdirnum (p_ass_id in number, p_tax_year varchar2, p_period_recon_last_date date, p_period_recon varchar2) is
1042: select distinct prrv.result_value directive_number
1043: from pay_payroll_actions ppa
1044: , per_time_periods ptp
1045: , pay_assignment_actions paa
1046: , pay_run_results prr
1047: , pay_run_result_values prrv
1048: , pay_element_types_f peef
1049: , pay_input_values_f piv
1071: pay_link_input_values_f plivf,
1072: pay_input_values_f pivf,
1073: pay_element_types_f petf,
1074: pay_payroll_actions ppa,
1075: pay_assignment_actions paa
1076: where paa.assignment_action_id = p_run_assact_id
1077: and ppa.payroll_action_id = paa.payroll_action_id
1078: and petf.element_name = 'ZA_Tax'
1079: and petf.legislation_code = 'ZA'
1231: , paa.assignment_id
1232: into l_leg_param
1233: , l_assignment_id
1234: from pay_payroll_actions ppa
1235: , pay_assignment_actions paa
1236: where paa.assignment_action_id = p_assactid
1237: and ppa.payroll_action_id = paa.payroll_action_id;
1238:
1239: select max(paaf.person_id)
1315: -- Fetch assignment_action_id for last payroll run for that assignment
1316: -- in this tax year
1317: select max(paa.action_sequence)
1318: into l_run_action_seq
1319: from pay_assignment_actions paa,
1320: pay_payroll_actions ppa,
1321: per_time_periods ptp
1322: where paa.assignment_id = l_assignment_id
1323: and paa.action_status IN ('C','S') --10376999
1329: and ptp.end_date <= decode(l_period_recon, '02', ptp.end_date, l_period_recon_last_date); -- 9877034 fix
1330:
1331: select assignment_action_id
1332: into l_run_assact_id
1333: from pay_assignment_actions
1334: where assignment_id = l_assignment_id
1335: and action_sequence = l_run_action_seq;
1336:
1337: hr_utility.trace('Last payroll run assignment_action_id : '|| l_run_assact_id);
2301: select pai.action_information30
2302: , pai.action_context_id
2303: , pai.action_context_type
2304: from pay_payroll_actions ppa
2305: , pay_assignment_actions paa
2306: , pay_action_information pai
2307: where ppa.payroll_action_id = pactid
2308: and ppa.action_status = 'C'
2309: and paa.payroll_action_id = ppa.payroll_action_id
2609: , aei.aei_information15 foreign_income
2610: , aei.aei_information13 payment_type
2611: , aei.aei_information14 personal_pay_method_id
2612: from per_assignment_extra_info aei
2613: , pay_assignment_actions paa
2614: where paa.assignment_action_id = p_assactid
2615: and aei.assignment_id = paa.assignment_id
2616: and aei.aei_information_category = 'ZA_SPECIFIC_INFO';
2617:
2761: , paa.assignment_id
2762: into l_leg_param
2763: , l_assignment_id
2764: from pay_payroll_actions ppa
2765: , pay_assignment_actions paa
2766: where paa.assignment_action_id = p_assactid
2767: and ppa.payroll_action_id = paa.payroll_action_id ;
2768:
2769: l_tax_year := get_parameter('TAX_YEAR', l_leg_param);
2802: -- payroll_id for which payroll process for this assignment
2803: -- was run in this tax year
2804: select max(paa.action_sequence)
2805: into l_max_act_seq
2806: from pay_assignment_actions paa
2807: , pay_payroll_actions ppa
2808: , per_time_periods ptp
2809: where paa.assignment_id = l_assignment_id
2810: and paa.payroll_action_id = ppa.payroll_action_id
2817:
2818: select ppa.payroll_id, paa.assignment_action_id, ptp.start_date
2819: into l_payroll_id, l_run_assact_id, p_lumpsum_date
2820: from pay_payroll_actions ppa
2821: , pay_assignment_actions paa
2822: , per_time_periods ptp
2823: where paa.assignment_id = l_assignment_id
2824: and paa.action_sequence = l_max_act_seq
2825: and ppa.payroll_action_id = paa.payroll_action_id