[Home] [Help]
860: CURSOR cur_get_prev_run_seq is
861: select paa.action_sequence
862: from pay_assignment_actions paa,
863: pay_payroll_actions ppa,
864: pay_action_interlocks pai,
865: pay_assignment_actions paa1
866: where paa1.source_action_id = p_last_p45_act
867: and pai.locking_action_id = paa1.assignment_action_id
868: and pai.locked_action_id = paa.assignment_action_id
1366: CURSOR cur_get_prev_run_seq is
1367: select paa.action_sequence
1368: from pay_assignment_actions paa,
1369: pay_payroll_actions ppa,
1370: pay_action_interlocks pai,
1371: pay_assignment_actions paa1
1372: where paa1.source_action_id = p_last_p45_action
1373: and pai.locking_action_id = paa1.assignment_action_id
1374: and pai.locked_action_id = paa.assignment_action_id
1968: where ppos.person_id = p_person_id
1969: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
1970: from per_all_assignments_f paf,
1971: pay_assignment_actions paa,
1972: pay_action_interlocks pai
1973: where pai.locking_action_id = p_action_context_id
1974: and pai.locked_action_id = paa.assignment_action_id
1975: and paa.action_status = 'C'
1976: and paa.assignment_id = paf.assignment_id
2008:
2009: cursor cur_supp_run is
2010: select act_inf.action_information3
2011: from pay_assignment_actions paa_run,
2012: pay_action_interlocks pai,
2013: pay_assignment_actions paa,
2014: pay_payroll_actions ppa,
2015: pay_action_information act_inf
2016: where ppa.payroll_action_id = paa.payroll_action_id
2142: where ppos.person_id = p_person_id
2143: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
2144: from per_all_assignments_f paf,
2145: pay_assignment_actions paa,
2146: pay_action_interlocks pai
2147: where pai.locking_action_id = p_action_context_id
2148: and pai.locked_action_id = paa.assignment_action_id
2149: and paa.action_status = 'C'
2150: and paa.assignment_id = paf.assignment_id
2263:
2264: /* cursor cur_supp_run is
2265: select act_inf.action_information3
2266: from pay_assignment_actions paa_run,
2267: pay_action_interlocks pai,
2268: pay_assignment_actions paa,
2269: pay_payroll_actions ppa,
2270: pay_action_information act_inf
2271: where ppa.payroll_action_id = paa.payroll_action_id
2577: -- AND org.org_information2 = g_paye_ref
2578: AND org.organization_id = g_paye_ref
2579: AND exists (SELECT NULL
2580: FROM pay_assignment_actions paa,
2581: pay_action_interlocks pai,
2582: pay_assignment_actions paa_arc
2583: WHERE pai.locked_action_id = paa.assignment_action_id
2584: AND pai.locking_action_id = paa_arc.assignment_action_id
2585: AND paa_arc.payroll_action_id = p_pact_id
2639: CURSOR csr_all_payroll_info(p_pact_id NUMBER) IS
2640: SELECT pact.payroll_action_id payroll_action_id,
2641: pact.effective_date effective_date
2642: FROM pay_assignment_actions paa,
2643: pay_action_interlocks pai,
2644: pay_assignment_actions paa_arc,
2645: pay_payroll_actions pact
2646: WHERE pai.locked_action_id = paa.assignment_action_id
2647: AND pai.locking_action_id = paa_arc.assignment_action_id
2931: FROM --per_periods_of_service ppos,
2932: per_all_assignments_f as1,
2933: pay_assignment_actions act,
2934: pay_payroll_actions appa,
2935: pay_action_interlocks pai,
2936: pay_assignment_actions act1,
2937: pay_payroll_actions appa2
2938: WHERE /*appa.consolidation_set_id = p_consolidation_id*/
2939: act.tax_unit_id = p_paye_ref
3002: -- refer bug 5233518 for more details.
3003: AND NOT EXISTS (SELECT /*+ ORDERED use_nl(appa3)*/ null
3004: from pay_assignment_actions act3,
3005: pay_payroll_actions appa3,
3006: pay_action_interlocks pai, --bug 4208273
3007: pay_assignment_actions act2, --bug 4208273
3008: pay_payroll_actions appa4 --bug 4208273
3009: where pai.locked_action_id= act3.assignment_action_id
3010: and pai.locking_action_id=act2.assignment_action_id
3164: paa.effective_date effective_date,
3165: ppaa.effective_date pre_effective_date,
3166: paa.date_earned date_earned,
3167: ptp.time_period_id time_period_id
3168: FROM pay_action_interlocks pre,
3169: pay_action_interlocks pay,
3170: pay_payroll_actions paa,
3171: pay_payroll_actions ppaa,
3172: pay_assignment_actions assact,
3165: ppaa.effective_date pre_effective_date,
3166: paa.date_earned date_earned,
3167: ptp.time_period_id time_period_id
3168: FROM pay_action_interlocks pre,
3169: pay_action_interlocks pay,
3170: pay_payroll_actions paa,
3171: pay_payroll_actions ppaa,
3172: pay_assignment_actions assact,
3173: pay_assignment_actions passact,
3662: ,pay_action_information pai_iep45
3663: ,pay_action_information pai_ieed
3664: ,pay_action_information pai_epif
3665: ,pay_assignment_actions paa
3666: ,pay_action_interlocks pai_arc
3667: ,pay_assignment_actions paa_payroll
3668: ,per_time_periods ptp
3669: ,pay_ie_p45_address_details emp_address
3670: ,pay_ie_p45_employee_details emp_details
3725: --
3726: CURSOR cur_p45_employer_no (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
3727: SELECT pai_epif.action_information6 employer_number
3728: FROM pay_assignment_actions paa
3729: ,pay_action_interlocks pai_arc
3730: ,pay_assignment_actions paa_payroll
3731: ,pay_action_information pai_epif
3732: WHERE paa.assignment_action_id = p_assignment_action_id
3733: AND paa.assignment_action_id = pai_arc.locking_action_id
3816: CURSOR cur_p30_start_date(
3817: c_p30_data_lock_process pay_payroll_actions.payroll_action_id%TYPE) IS
3818: SELECT to_char(MIN(ppa_arc.start_date),'DD/MM/RRRR') start_date
3819: FROM pay_assignment_actions paa_p30,
3820: pay_action_interlocks pai_p30,
3821: pay_assignment_actions paa_arc,
3822: pay_payroll_actions ppa_arc
3823: WHERE paa_p30.payroll_Action_id = c_p30_data_lock_process
3824: AND paa_p30.assignment_action_id = pai_p30.locking_action_id