[Home] [Help]
475: ,pay_element_entry_values_f EV_SCON
476: ,pay_element_entries_f E_NI
477: ,pay_element_links_f EL_NI
478: ,pay_payroll_actions PACT
479: ,pay_assignment_actions ASSACT
480: ,pay_payroll_actions BACT
481: ,per_time_periods BPTP
482: ,per_time_periods PPTP
483: ,pay_assignment_actions BAL_ASSACT
479: ,pay_assignment_actions ASSACT
480: ,pay_payroll_actions BACT
481: ,per_time_periods BPTP
482: ,per_time_periods PPTP
483: ,pay_assignment_actions BAL_ASSACT
484: where BAL_ASSACT.assignment_action_id = cp_l_asg_id
485: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
486: and FEED.balance_type_id = BAL.balance_type_id
487: and BAL.balance_name like 'NI%'
1063: SET (LAST_ASG_ACTION_ID, LAST_EFFECTIVE_DATE) = (
1064: select assact.assignment_action_id,
1065: pact.effective_date
1066: from pay_payroll_actions pact,
1067: pay_assignment_actions assact
1068: where assact.payroll_action_id = pact.payroll_action_id
1069: and ye_asg.assignment_id = assact.assignment_id
1070: and ye_asg.request_id = p_request_id
1071: and assact.action_sequence =
1070: and ye_asg.request_id = p_request_id
1071: and assact.action_sequence =
1072: (
1073: select max(assact2.action_sequence)
1074: from pay_assignment_actions assact2,
1075: pay_payroll_actions pact2,
1076: pay_gb_year_end_payrolls ye_roll
1077: where assact2.assignment_id = ye_asg.assignment_id
1078: and assact2.payroll_action_id = pact2.payroll_action_id
1085: and ye_roll.END_YEAR
1086: and not exists(
1087: select '1'
1088: from pay_action_interlocks pai,
1089: pay_assignment_actions assact3,
1090: pay_payroll_actions pact3
1091: where pai.locked_action_id = assact2.assignment_action_id
1092: and pai.locking_action_id = assact3.assignment_action_id
1093: and pact3.payroll_action_id = assact3.payroll_action_id
1233: SET (PREVIOUS_YEAR_ASG_ACTION_ID, PREVIOUS_YEAR_EFFECTIVE_DATE) = (
1234: select assact.assignment_action_id,
1235: pact.effective_date
1236: from pay_payroll_actions pact,
1237: pay_assignment_actions assact
1238: where assact.payroll_action_id = pact.payroll_action_id
1239: and ye_asg.assignment_id = assact.assignment_id
1240: and ye_asg.request_id = p_request_id
1241: and assact.action_sequence =
1240: and ye_asg.request_id = p_request_id
1241: and assact.action_sequence =
1242: (
1243: select max(assact2.action_sequence)
1244: from pay_assignment_actions assact2,
1245: pay_payroll_actions pact2,
1246: pay_gb_year_end_payrolls ye_roll
1247: where assact2.assignment_id = ye_asg.assignment_id
1248: and assact2.payroll_action_id = pact2.payroll_action_id
1255: and ye_roll.END_PREVIOUS_YEAR
1256: and not exists(
1257: select '1'
1258: from pay_action_interlocks pai,
1259: pay_assignment_actions assact3,
1260: pay_payroll_actions pact3
1261: where pai.locked_action_id = assact2.assignment_action_id
1262: and pai.locking_action_id = assact3.assignment_action_id
1263: and pact3.payroll_action_id = assact3.payroll_action_id
1665: hr_utility.set_location('PAY_YEAR_END_EXTRACT.EXTRACT',32);
1666: hr_utility.trace( 'find the latest tax calculation in the year' );
1667: update pay_gb_year_end_assignments ye_asg set ( TAX_RUN_RESULT_ID ) =
1668: (select r.RUN_RESULT_ID
1669: from pay_assignment_actions assact,
1670: pay_run_results r
1671: where r.element_type_id+0 = l_paye_details_id + decode(assact.assignment_id,null,0,0)
1672: and r.assignment_action_id = assact.assignment_action_id
1673: and r.status in ('P', 'PA')
1673: and r.status in ('P', 'PA')
1674: and assact.assignment_id = ye_asg.assignment_id
1675: and assact.action_sequence = (
1676: select max(assact2.action_sequence)
1677: from pay_assignment_actions assact2,
1678: pay_payroll_actions pact,
1679: pay_gb_year_end_payrolls ye_roll
1680: where assact2.assignment_id = ye_asg.assignment_id
1681: and ye_roll.payroll_id = pact.payroll_id