119: from pay_jp_banks bnk,
120: pay_external_accounts pea,
121: pay_personal_payment_methods_f ppm,
122: pay_payroll_actions ppa2, -- Prepay pact
123: pay_assignment_actions paa2, -- Prepay assact
124: pay_pre_payments ppp,
125: pay_assignment_actions paa -- Magtape assact
126: where paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
127: and ppp.pre_payment_id = paa.pre_payment_id
121: pay_personal_payment_methods_f ppm,
122: pay_payroll_actions ppa2, -- Prepay pact
123: pay_assignment_actions paa2, -- Prepay assact
124: pay_pre_payments ppp,
125: pay_assignment_actions paa -- Magtape assact
126: where paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
127: and ppp.pre_payment_id = paa.pre_payment_id
128: and paa2.assignment_action_id = ppp.assignment_action_id
129: and ppa2.payroll_action_id = paa2.payroll_action_id
155: pay_jp_bank_branches bch,
156: pay_external_accounts pea,
157: pay_personal_payment_methods_f ppm,
158: pay_payroll_actions ppa2, -- Prepay pact
159: pay_assignment_actions paa2, -- Prepay assact
160: pay_pre_payments ppp,
161: pay_assignment_actions paa -- Magtape assact
162: where paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
163: and ppp.pre_payment_id = paa.pre_payment_id
157: pay_personal_payment_methods_f ppm,
158: pay_payroll_actions ppa2, -- Prepay pact
159: pay_assignment_actions paa2, -- Prepay assact
160: pay_pre_payments ppp,
161: pay_assignment_actions paa -- Magtape assact
162: where paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
163: and ppp.pre_payment_id = paa.pre_payment_id
164: and paa2.assignment_action_id = ppp.assignment_action_id
165: and ppa2.payroll_action_id = paa2.payroll_action_id