[Home] [Help]
557: and paf.effective_end_date
558: and not exists
559: (select /*+ ORDERED */
560: 1
561: from pay_action_interlocks pai,
562: pay_assignment_actions paa1,
563: pay_payroll_actions ppa1
564: where pai.locked_action_id = paa.assignment_action_id
565: and paa1.assignment_action_id = pai.locking_action_id
630: 'N') = 'N'
631: and paa.source_action_id is null
632: and not exists
633: (select 'x'
634: from pay_action_interlocks pai1,
635: pay_assignment_actions paa1,
636: pay_payroll_actions ppa1
637: where pai1.locked_action_id = paa.assignment_action_id
638: and paa1.assignment_action_id = pai1.locking_action_id
684: 'N') = 'N'
685: and paa.source_action_id is null
686: and not exists
687: (select 'x'
688: from pay_action_interlocks pai1,
689: pay_assignment_actions paa1,
690: pay_payroll_actions ppa1
691: where pai1.locked_action_id = paa.assignment_action_id
692: and paa1.assignment_action_id = pai1.locking_action_id
698: cursor c_master_action(cp_prepayment_action_id number) is
699: select max(paa.assignment_action_id)
700: from pay_payroll_actions ppa,
701: pay_assignment_actions paa,
702: pay_action_interlocks pai
703: where pai.locking_action_Id = cp_prepayment_action_id
704: and paa.assignment_action_id = pai.locked_action_id
705: and paa.source_action_id is null
706: and ppa.payroll_action_id = paa.payroll_action_id
4640: IS
4641:
4642: cursor c_get_emp_adjbal(cp_xfr_action_id number) IS
4643: select locked_action_id
4644: from pay_action_interlocks
4645: where locking_action_id = cp_xfr_action_id;
4646:
4647: cursor c_get_baladj_jd(cp_baladj_action_id number
4648: ,cp_run_effective_date in date) is
5187: ,cp_assignment_id in number
5188: ,cp_sepchk_run_type in number) is
5189: select paa.assignment_action_id
5190: from pay_assignment_actions paa,
5191: pay_action_interlocks pai,
5192: pay_payroll_actions ppa
5193: where pai.locking_action_id = cp_prepayment_action_id
5194: and paa.assignment_action_id = pai.locked_action_id
5195: and paa.assignment_id = cp_assignment_id
5599: and prt.legislation_code = 'US';
5600:
5601: cursor c_assignment_run (cp_prepayment_action_id in number) is
5602: select distinct paa.assignment_id
5603: from pay_action_interlocks pai,
5604: pay_assignment_actions paa,
5605: pay_payroll_actions ppa
5606: where pai.locking_action_id = cp_prepayment_action_id
5607: and paa.assignment_action_id = pai.locked_action_id
5617: select paa.assignment_action_id, paa.payroll_action_id,
5618: ppa.action_type
5619: from pay_payroll_actions ppa,
5620: pay_assignment_actions paa,
5621: pay_action_interlocks pai
5622: where pai.locking_action_id = cp_prepayment_action_id
5623: and pai.locked_action_id = paa.assignment_action_id
5624: and paa.assignment_id = cp_assignment_id
5625: and paa.source_action_id is null
5654: ,cp_tax_unit_id number) is
5655: select paa.assignment_action_id
5656: ,paa.source_action_id
5657: from pay_assignment_actions paa
5658: ,pay_action_interlocks pai
5659: where pai.locking_action_id = cp_pp_asg_act_id
5660: and paa.assignment_action_id = pai.locked_action_id
5661: and paa.assignment_id = cp_assignment_id
5662: and paa.tax_unit_id = cp_tax_unit_id
5732: ,cp_tax_unit_id number) is
5733: select paa.assignment_action_id
5734: ,paa.source_action_id
5735: from pay_assignment_actions paa
5736: ,pay_action_interlocks pai
5737: where pai.locking_action_id = cp_pp_asg_act_id
5738: and paa.assignment_action_id = pai.locked_action_id
5739: and paa.assignment_id = cp_assignment_id
5740: and paa.tax_unit_id = cp_tax_unit_id
5745: ,cp_tax_unit_id in number
5746: ,cp_sepchk_run_type in number) is
5747: select paa.assignment_action_id
5748: from pay_assignment_actions paa,
5749: pay_action_interlocks pai
5750: where pai.locking_action_id = cp_pp_asg_act_id
5751: and paa.assignment_action_id = pai.locked_action_id
5752: and paa.assignment_id = cp_assignment_id
5753: and paa.tax_unit_id = cp_tax_unit_id