[Home] [Help]
656: and paf.effective_end_date
657: and not exists
658: (select /*+ ORDERED */
659: 1
660: from pay_action_interlocks pai,
661: pay_assignment_actions paa1,
662: pay_payroll_actions ppa1
663: where pai.locked_action_id = paa.assignment_action_id
664: and paa1.assignment_action_id = pai.locking_action_id
729: 'N') = 'N'
730: and paa.source_action_id is null
731: and not exists
732: (select 'x'
733: from pay_action_interlocks pai1,
734: pay_assignment_actions paa1,
735: pay_payroll_actions ppa1
736: where pai1.locked_action_id = paa.assignment_action_id
737: and paa1.assignment_action_id = pai1.locking_action_id
783: 'N') = 'N'
784: and paa.source_action_id is null
785: and not exists
786: (select 'x'
787: from pay_action_interlocks pai1,
788: pay_assignment_actions paa1,
789: pay_payroll_actions ppa1
790: where pai1.locked_action_id = paa.assignment_action_id
791: and paa1.assignment_action_id = pai1.locking_action_id
797: cursor c_master_action(cp_prepayment_action_id number) is
798: select max(paa.assignment_action_id)
799: from pay_payroll_actions ppa,
800: pay_assignment_actions paa,
801: pay_action_interlocks pai
802: where pai.locking_action_Id = cp_prepayment_action_id
803: and paa.assignment_action_id = pai.locked_action_id
804: and paa.source_action_id is null
805: and ppa.payroll_action_id = paa.payroll_action_id
5612: IS
5613:
5614: cursor c_get_emp_adjbal(cp_xfr_action_id number) IS
5615: select locked_action_id
5616: from pay_action_interlocks
5617: where locking_action_id = cp_xfr_action_id;
5618:
5619: cursor c_get_baladj_jd(cp_baladj_action_id number
5620: ,cp_run_effective_date in date) is
6255: pay_run_results prr_att,
6256: pay_run_results prr_pay,
6257: pay_payroll_actions ppa,
6258: pay_assignment_actions paa,
6259: pay_action_interlocks pai,
6260: pay_pre_payments ppp,
6261: pay_input_values_f piv_pay,
6262: pay_run_result_values prrv_att,
6263: pay_run_result_values prrv_pay,
6339: pay_run_results prr_att,
6340: pay_run_results prr_pay,
6341: pay_payroll_actions ppa,
6342: pay_assignment_actions paa,
6343: pay_action_interlocks pai,
6344: pay_pre_payments ppp,
6345: pay_input_values_f piv_pay,
6346: pay_run_result_values prrv_att,
6347: pay_run_result_values prrv_pay
6446: pay_element_entries_f peef,
6447: pay_run_results prr_att,
6448: pay_payroll_actions ppa,
6449: pay_assignment_actions paa,
6450: pay_action_interlocks pai,
6451: pay_pre_payments ppp,
6452: pay_run_result_values prrv_att,
6453: pay_element_types_f pet,
6454: pay_element_classifications pec
7187: ,cp_assignment_id in number
7188: ,cp_sepchk_run_type in number) is
7189: select paa.assignment_action_id
7190: from pay_assignment_actions paa,
7191: pay_action_interlocks pai,
7192: pay_payroll_actions ppa
7193: where pai.locking_action_id = cp_prepayment_action_id
7194: and paa.assignment_action_id = pai.locked_action_id
7195: and paa.assignment_id = cp_assignment_id
7659: and prt.legislation_code = 'US';
7660:
7661: cursor c_assignment_run (cp_prepayment_action_id in number) is
7662: select distinct paa.assignment_id
7663: from pay_action_interlocks pai,
7664: pay_assignment_actions paa,
7665: pay_payroll_actions ppa
7666: where pai.locking_action_id = cp_prepayment_action_id
7667: and paa.assignment_action_id = pai.locked_action_id
7677: select paa.assignment_action_id, paa.payroll_action_id,
7678: ppa.action_type
7679: from pay_payroll_actions ppa,
7680: pay_assignment_actions paa,
7681: pay_action_interlocks pai
7682: where pai.locking_action_id = cp_prepayment_action_id
7683: and pai.locked_action_id = paa.assignment_action_id
7684: and paa.assignment_id = cp_assignment_id
7685: and paa.source_action_id is null
7714: ,cp_tax_unit_id number) is
7715: select paa.assignment_action_id
7716: ,paa.source_action_id
7717: from pay_assignment_actions paa
7718: ,pay_action_interlocks pai
7719: where pai.locking_action_id = cp_pp_asg_act_id
7720: and paa.assignment_action_id = pai.locked_action_id
7721: and paa.assignment_id = cp_assignment_id
7722: and paa.tax_unit_id = cp_tax_unit_id
7793: ,cp_tax_unit_id number) is
7794: select paa.assignment_action_id
7795: ,paa.source_action_id
7796: from pay_assignment_actions paa
7797: ,pay_action_interlocks pai
7798: where pai.locking_action_id = cp_pp_asg_act_id
7799: and paa.assignment_action_id = pai.locked_action_id
7800: and paa.assignment_id = cp_assignment_id
7801: and paa.tax_unit_id = cp_tax_unit_id
7806: ,cp_tax_unit_id in number
7807: ,cp_sepchk_run_type in number) is
7808: select paa.assignment_action_id
7809: from pay_assignment_actions paa,
7810: pay_action_interlocks pai
7811: where pai.locking_action_id = cp_pp_asg_act_id
7812: and paa.assignment_action_id = pai.locked_action_id
7813: and paa.assignment_id = cp_assignment_id
7814: and paa.tax_unit_id = cp_tax_unit_id