[Home] [Help]
1073: CURSOR cur_get_prev_run_seq is
1074: select paa.action_sequence
1075: from pay_assignment_actions paa,
1076: pay_payroll_actions ppa,
1077: pay_action_interlocks pai,
1078: pay_assignment_actions paa1
1079: where paa1.source_action_id = p_last_p45_act
1080: and pai.locking_action_id = paa1.assignment_action_id
1081: and pai.locked_action_id = paa.assignment_action_id
1630: CURSOR cur_get_prev_run_seq is
1631: select paa.action_sequence
1632: from pay_assignment_actions paa,
1633: pay_payroll_actions ppa,
1634: pay_action_interlocks pai,
1635: pay_assignment_actions paa1
1636: where paa1.source_action_id = p_last_p45_action
1637: and pai.locking_action_id = paa1.assignment_action_id
1638: and pai.locked_action_id = paa.assignment_action_id
2635: where ppos.person_id = p_person_id
2636: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
2637: from per_all_assignments_f paf,
2638: pay_assignment_actions paa,
2639: pay_action_interlocks pai
2640: where pai.locking_action_id = p_action_context_id
2641: and pai.locked_action_id = paa.assignment_action_id
2642: and paa.action_status IN ('C','S') --10225372
2643: and paa.assignment_id = paf.assignment_id
2675:
2676: cursor cur_supp_run is
2677: select act_inf.action_information3
2678: from pay_assignment_actions paa_run,
2679: pay_action_interlocks pai,
2680: pay_assignment_actions paa,
2681: pay_payroll_actions ppa,
2682: pay_action_information act_inf
2683: where ppa.payroll_action_id = paa.payroll_action_id
2809: where ppos.person_id = p_person_id
2810: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
2811: from per_all_assignments_f paf,
2812: pay_assignment_actions paa,
2813: pay_action_interlocks pai
2814: where pai.locking_action_id = p_action_context_id
2815: and pai.locked_action_id = paa.assignment_action_id
2816: and paa.action_status IN ('C','S') --10225372
2817: and paa.assignment_id = paf.assignment_id
2930:
2931: /* cursor cur_supp_run is
2932: select act_inf.action_information3
2933: from pay_assignment_actions paa_run,
2934: pay_action_interlocks pai,
2935: pay_assignment_actions paa,
2936: pay_payroll_actions ppa,
2937: pay_action_information act_inf
2938: where ppa.payroll_action_id = paa.payroll_action_id
3283: -- AND org.org_information2 = g_paye_ref
3284: AND org.organization_id = g_paye_ref
3285: AND exists (SELECT NULL
3286: FROM pay_assignment_actions paa,
3287: pay_action_interlocks pai,
3288: pay_assignment_actions paa_arc
3289: WHERE pai.locked_action_id = paa.assignment_action_id
3290: AND pai.locking_action_id = paa_arc.assignment_action_id
3291: AND paa_arc.payroll_action_id = p_pact_id
3345: CURSOR csr_all_payroll_info(p_pact_id NUMBER) IS
3346: SELECT pact.payroll_action_id payroll_action_id,
3347: pact.effective_date effective_date
3348: FROM pay_assignment_actions paa,
3349: pay_action_interlocks pai,
3350: pay_assignment_actions paa_arc,
3351: pay_payroll_actions pact
3352: WHERE pai.locked_action_id = paa.assignment_action_id
3353: AND pai.locking_action_id = paa_arc.assignment_action_id
3639: FROM --per_periods_of_service ppos,
3640: per_all_assignments_f as1,
3641: pay_assignment_actions act,
3642: pay_payroll_actions appa,
3643: pay_action_interlocks pai,
3644: pay_assignment_actions act1,
3645: pay_payroll_actions appa2
3646: WHERE /*appa.consolidation_set_id = p_consolidation_id*/
3647: act.tax_unit_id = p_paye_ref
3710: -- refer bug 5233518 for more details.
3711: AND NOT EXISTS (SELECT /*+ ORDERED use_nl(appa3)*/ null
3712: from pay_assignment_actions act3,
3713: pay_payroll_actions appa3,
3714: pay_action_interlocks pai, --bug 4208273
3715: pay_assignment_actions act2, --bug 4208273
3716: pay_payroll_actions appa4 --bug 4208273
3717: where pai.locked_action_id= act3.assignment_action_id
3718: and pai.locking_action_id=act2.assignment_action_id
3933: paa.effective_date effective_date,
3934: ppaa.effective_date pre_effective_date,
3935: paa.date_earned date_earned,
3936: ptp.time_period_id time_period_id
3937: FROM pay_action_interlocks pre,
3938: pay_action_interlocks pay,
3939: pay_payroll_actions paa,
3940: pay_payroll_actions ppaa,
3941: pay_assignment_actions assact,
3934: ppaa.effective_date pre_effective_date,
3935: paa.date_earned date_earned,
3936: ptp.time_period_id time_period_id
3937: FROM pay_action_interlocks pre,
3938: pay_action_interlocks pay,
3939: pay_payroll_actions paa,
3940: pay_payroll_actions ppaa,
3941: pay_assignment_actions assact,
3942: pay_assignment_actions passact,
4585: ,pay_action_information pai_iep45
4586: ,pay_action_information pai_ieed
4587: ,pay_action_information pai_epif
4588: ,pay_assignment_actions paa
4589: ,pay_action_interlocks pai_arc
4590: ,pay_assignment_actions paa_payroll
4591: ,per_time_periods ptp
4592: ,pay_ie_p45_address_details emp_address
4593: ,pay_ie_p45_employee_details emp_details
4650: --
4651: CURSOR cur_p45_employer_no (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
4652: SELECT pai_epif.action_information6 employer_number
4653: FROM pay_assignment_actions paa
4654: ,pay_action_interlocks pai_arc
4655: ,pay_assignment_actions paa_payroll
4656: ,pay_action_information pai_epif
4657: WHERE paa.assignment_action_id = p_assignment_action_id
4658: AND paa.assignment_action_id = pai_arc.locking_action_id
4754: CURSOR cur_p30_start_date(
4755: c_p30_data_lock_process pay_payroll_actions.payroll_action_id%TYPE) IS
4756: SELECT to_char(MIN(ppa_arc.start_date),'DD/MM/RRRR') start_date
4757: FROM pay_assignment_actions paa_p30,
4758: pay_action_interlocks pai_p30,
4759: pay_assignment_actions paa_arc,
4760: pay_payroll_actions ppa_arc
4761: WHERE paa_p30.payroll_Action_id = c_p30_data_lock_process
4762: AND paa_p30.assignment_action_id = pai_p30.locking_action_id
4786: where ppos.person_id = c_person_id
4787: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
4788: from per_all_assignments_f paf,
4789: pay_assignment_actions paa,
4790: pay_action_interlocks pai
4791: where pai.locking_action_id = c_action_context_id
4792: and pai.locked_action_id = paa.assignment_action_id
4793: and paa.action_status IN ('C','S') --10225372
4794: and paa.assignment_id = paf.assignment_id