[Home] [Help]
822: pay_element_types_f pet,
823: pay_run_results prr,
824: pay_payroll_actions run_ppa,
825: pay_assignment_actions run_paa,
826: pay_action_interlocks pai,
827: pay_pre_payments ppp
828: WHERE prrv.result_value = to_char(cp_amount)
829: AND ppp.pre_payment_id = cp_pre_payment_id
830: AND ppp.assignment_action_id = pai.locking_action_id
1157: ,cp_assignment_id in number
1158: ,cp_sepchk_run_type in number) is
1159: select paa.assignment_action_id
1160: from pay_assignment_actions paa,
1161: pay_action_interlocks pai,
1162: pay_payroll_actions ppa
1163: where pai.locking_action_id = cp_prepayment_action_id
1164: and paa.assignment_action_id = pai.locked_action_id
1165: and paa.assignment_id = cp_assignment_id
1180: ,cp_tax_unit_id in number
1181: ,cp_sepchk_run_type in number) is
1182: select paa.assignment_action_id
1183: from pay_assignment_actions paa,
1184: pay_action_interlocks pai,
1185: pay_payroll_actions ppa
1186: where pai.locking_action_id = cp_prepayment_action_id
1187: and paa.assignment_action_id = pai.locked_action_id
1188: and paa.assignment_id = cp_assignment_id
1631: and tax_unit_id = cp_tax_unit_id;
1632:
1633: cursor c_get_pp_actid_of_sepchk(cp_source_action_id number) is
1634: select paa.assignment_action_id
1635: from pay_action_interlocks pai
1636: ,pay_assignment_actions paa
1637: ,pay_payroll_actions ppa
1638: where pai.locked_action_id = cp_source_action_id
1639: and paa.assignment_action_id = pai.locking_action_id
1646: cursor c_run_master_aa_id(cp_pp_asg_act_id number
1647: ,cp_assignment_id number) is
1648: select paa.assignment_action_id,ppa_run.action_type
1649: from pay_assignment_actions paa
1650: ,pay_action_interlocks pai
1651: ,pay_payroll_actions ppa_run
1652: where pai.locking_action_id = cp_pp_asg_act_id
1653: and paa.assignment_action_id = pai.locked_action_id
1654: and paa.assignment_id = cp_assignment_id
1662: ,cp_tax_unit_id in number
1663: ,cp_sepchk_run_type in number) is
1664: select paa.assignment_action_id
1665: from pay_assignment_actions paa,
1666: pay_action_interlocks pai
1667: where pai.locking_action_id = cp_pp_asg_act_id
1668: and paa.assignment_action_id = pai.locked_action_id
1669: and paa.assignment_id = cp_assignment_id
1670: and paa.tax_unit_id = cp_tax_unit_id
1971: and tax_unit_id = cp_tax_unit_id;
1972:
1973: cursor c_get_pp_actid_of_sepchk(cp_source_action_id number) is
1974: select paa.assignment_action_id
1975: from pay_action_interlocks pai
1976: ,pay_assignment_actions paa
1977: ,pay_payroll_actions ppa
1978: where pai.locked_action_id = cp_source_action_id
1979: and paa.assignment_action_id = pai.locking_action_id
1985: ,cp_assignment_id number
1986: ,cp_tax_unit_id number) is
1987: select paa.assignment_action_id, paa.source_action_id
1988: from pay_assignment_actions paa
1989: ,pay_action_interlocks pai
1990: where pai.locking_action_id = cp_pp_asg_act_id
1991: and paa.assignment_action_id = pai.locked_action_id
1992: and paa.assignment_id = cp_assignment_id
1993: and paa.tax_unit_id = cp_tax_unit_id
1999: ,cp_tax_unit_id in number
2000: ,cp_sepchk_run_type in number) is
2001: select paa.assignment_action_id
2002: from pay_assignment_actions paa,
2003: pay_action_interlocks pai
2004: where pai.locking_action_id = cp_pp_asg_act_id
2005: and paa.assignment_action_id = pai.locked_action_id
2006: and paa.assignment_id = cp_assignment_id
2007: and paa.tax_unit_id = cp_tax_unit_id
2470:
2471: cursor c_tax_unit(cp_pp_asg_act_id number) is
2472: select distinct paa.tax_unit_id
2473: from pay_assignment_actions paa
2474: ,pay_action_interlocks pai
2475: where pai.locking_action_id = cp_pp_asg_act_id
2476: and paa.assignment_action_id = pai.locked_action_id
2477: and paa.tax_unit_id is not null;
2478:
2478:
2479: cursor c_run_aa_id(cp_pp_asg_act_id number) is
2480: select paa.assignment_action_id, paa.source_action_id
2481: from pay_assignment_actions paa
2482: ,pay_action_interlocks pai
2483: where pai.locking_action_id = cp_pp_asg_act_id
2484: and paa.assignment_action_id = pai.locked_action_id
2485: and paa.source_action_id is not null
2486: order by paa.action_sequence desc;
2740: cursor c_pre_pay_run_action
2741: (cp_master_prepay_action_id in number
2742: ,cp_sepchk_run_type_id in number) is
2743: select pai.locked_action_id
2744: from pay_action_interlocks pai,
2745: pay_assignment_actions paa
2746: where pai.locking_action_id = cp_master_prepay_action_id
2747: and paa.assignment_action_id = pai.locked_action_id
2748: and paa.source_action_id is not null
2982: and prt.legislation_code = 'CA';
2983:
2984: cursor c_assignment_run (cp_prepayment_action_id in number) is
2985: select distinct paa.assignment_id
2986: from pay_action_interlocks pai,
2987: pay_assignment_actions paa,
2988: pay_payroll_actions ppa
2989: where pai.locking_action_id = cp_prepayment_action_id
2990: and paa.assignment_action_id = pai.locked_action_id
3002: select paa.assignment_action_id, paa.payroll_action_id,
3003: ppa.action_type
3004: from pay_payroll_actions ppa,
3005: pay_assignment_actions paa,
3006: pay_action_interlocks pai
3007: where pai.locking_action_Id = cp_prepayment_action_id
3008: and pai.locked_action_id = paa.assignment_action_id
3009: and paa.assignment_id = cp_assignment_id
3010: and paa.source_action_id is null
3028: with same effective date, 'B'. Bug#3498653 */
3029:
3030: cursor c_get_emp_adjbal(cp_xfr_action_id number) IS
3031: select locked_action_id
3032: from pay_action_interlocks
3033: where locking_action_id = cp_xfr_action_id;
3034:
3035: /* Added this cursor to get the run action type, so that
3036: if it is reversals 'V' then we will not call the
3042: cp_assignment_id in number) is
3043: select distinct ppa.action_type
3044: from pay_payroll_actions ppa,
3045: pay_assignment_actions paa,
3046: pay_action_interlocks pai
3047: where pai.locking_action_Id = cp_prepayment_action_id
3048: and pai.locked_action_id = paa.assignment_action_id
3049: and paa.assignment_id = cp_assignment_id
3050: and paa.source_action_id is null
3622: and paa.action_status = ''C''
3623: and paa.source_action_id is null
3624: and not exists
3625: (select ''x''
3626: from pay_action_interlocks pai,
3627: pay_assignment_actions paa1,
3628: pay_payroll_actions ppa1
3629: where pai.locked_action_id = paa.assignment_action_id
3630: and paa1.assignment_action_id = pai.locking_action_id
3707: 'N') = 'N'
3708: and paa.source_action_id is null
3709: and not exists
3710: (select 'x'
3711: from pay_action_interlocks pai1,
3712: pay_assignment_actions paa1,
3713: pay_payroll_actions ppa1
3714: where pai1.locked_action_id = paa.assignment_action_id
3715: and paa1.assignment_action_id = pai1.locking_action_id
3721: cursor c_master_action(cp_prepayment_action_id number) is
3722: select max(paa.assignment_action_id)
3723: from pay_payroll_actions ppa,
3724: pay_assignment_actions paa,
3725: pay_action_interlocks pai
3726: where pai.locking_action_Id = cp_prepayment_action_id
3727: and pai.locked_action_id = paa.assignment_action_id
3728: and paa.source_action_id is null
3729: and ppa.payroll_action_id = paa.payroll_action_id