DBA Data[Home] [Help]

APPS.PAY_JP_ZENGIN_TAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 123: pay_assignment_actions paa2, -- Prepay assact

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

Line 125: pay_assignment_actions paa -- Magtape assact

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

Line 159: pay_assignment_actions paa2, -- Prepay assact

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

Line 161: pay_assignment_actions paa -- Magtape assact

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