[Home] [Help]
11: IS
12: SELECT 'PAYROLL_ACTION_ID=C', ppa.payroll_action_id,
13: 'BG_ID=P', ppa.business_group_id
14: from pay_payroll_actions ppa
15: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
16: ('TRANSFER_PAYROLL_ACTION_ID')
17: or ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
18: ('PAYROLL_ACTION_ID');
19: --
13: 'BG_ID=P', ppa.business_group_id
14: from pay_payroll_actions ppa
15: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
16: ('TRANSFER_PAYROLL_ACTION_ID')
17: or ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
18: ('PAYROLL_ACTION_ID');
19: --
20: CURSOR c_payment_asg_actions
21: IS
21: IS
22: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
23: FROM pay_assignment_actions paa
24: WHERE paa.payroll_action_id =
25: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
26: or paa.payroll_action_id = pay_magtape_generic.get_parameter_value
27: ('PAYROLL_ACTION_ID');
28:
29: CURSOR c_bank_act_grp
22: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
23: FROM pay_assignment_actions paa
24: WHERE paa.payroll_action_id =
25: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
26: or paa.payroll_action_id = pay_magtape_generic.get_parameter_value
27: ('PAYROLL_ACTION_ID');
28:
29: CURSOR c_bank_act_grp
30: IS
33: pay_assignment_actions paa,
34: pay_pre_payments ppp,
35: pay_action_interlocks pai,
36: pay_org_payment_methods_f popm
37: WHERE (ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
38: ('TRANSFER_PAYROLL_ACTION_ID')
39: or ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
40: ('PAYROLL_ACTION_ID'))
41: AND paa.payroll_action_id=ppa.payroll_action_id
35: pay_action_interlocks pai,
36: pay_org_payment_methods_f popm
37: WHERE (ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
38: ('TRANSFER_PAYROLL_ACTION_ID')
39: or ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
40: ('PAYROLL_ACTION_ID'))
41: AND paa.payroll_action_id=ppa.payroll_action_id
42: and paa.assignment_action_id=pai.locking_action_id
43: and pai.locked_action_id=ppp.assignment_action_id
55: ,pay_pre_payments ppp
56: ,pay_org_payment_methods_f popm
57: ,pay_assignment_actions paa2
58: ,pay_payroll_actions ppa
59: WHERE (paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
60: or paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
61: and paa.assignment_action_id=pai.locking_action_id
62: and pai.locked_action_id=ppp.assignment_action_id
63: and ppp.assignment_action_id=paa2.assignment_action_id
56: ,pay_org_payment_methods_f popm
57: ,pay_assignment_actions paa2
58: ,pay_payroll_actions ppa
59: WHERE (paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
60: or paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
61: and paa.assignment_action_id=pai.locking_action_id
62: and pai.locked_action_id=ppp.assignment_action_id
63: and ppp.assignment_action_id=paa2.assignment_action_id
64: and ppp.pre_payment_id=paa.pre_payment_id
63: and ppp.assignment_action_id=paa2.assignment_action_id
64: and ppp.pre_payment_id=paa.pre_payment_id
65: and paa2.payroll_action_id=ppa.payroll_action_id
66: and ppp.org_payment_method_id=popm.org_payment_method_id
67: and popm.external_account_id=pay_magtape_generic.get_parameter_value('EXT_ACT_ID')
68: and ppa.effective_date between popm.effective_start_date and popm.effective_end_date;
69:
70: --
71: CURSOR c_payment_details
86: , pay_assignment_actions paa_chq
87: , pay_payroll_actions ppa
88: , pay_payroll_actions ppa_chq
89: , pay_org_payment_methods_f popm
90: WHERE paa_chq.assignment_action_id = pay_magtape_generic.get_parameter_value
91: ('TRANSFER_ACT_ID')
92: and paa_chq.assignment_action_id = pai.locking_action_id
93: and pai.locked_action_id=paa.assignment_action_id
94: and paa.payroll_action_id=ppa.payroll_action_id
99: and (ppa_chq.org_payment_method_id is NULL
100: or
101: ppa_chq.org_payment_method_id=ppp.org_payment_method_id)
102: and (ppa_chq.payroll_action_id =
103: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
104: or ppa_chq.payroll_action_id = pay_magtape_generic.get_parameter_value
105: ('PAYROLL_ACTION_ID'))
106: and ppa_chq.effective_date between popm.effective_start_date and popm.effective_end_date
107: UNION ALL
100: or
101: ppa_chq.org_payment_method_id=ppp.org_payment_method_id)
102: and (ppa_chq.payroll_action_id =
103: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
104: or ppa_chq.payroll_action_id = pay_magtape_generic.get_parameter_value
105: ('PAYROLL_ACTION_ID'))
106: and ppa_chq.effective_date between popm.effective_start_date and popm.effective_end_date
107: UNION ALL
108: SELECT 'PRE_PAY_ID=P', ppp.pre_payment_id,
117: 'DET_BG_ID=P', ppa.business_group_id
118: FROM pay_pre_payments ppp
119: , pay_assignment_actions paa
120: , pay_payroll_actions ppa
121: WHERE paa.assignment_action_id= pay_magtape_generic.get_parameter_value
122: ('TRANSFER_ACT_ID')
123: and paa.object_type='HOU'
124: and ppp.organization_id=paa.object_id
125: and ppp.payroll_action_id= ppa.payroll_action_id