DBA Data[Home] [Help]

APPS.PAY_JP_ZENGIN_TAPE dependencies on PAY_PAYROLL_ACTIONS

Line 103: pay_payroll_actions ppa

99: from pay_jp_bank_branches bch,
100: pay_jp_banks bnk,
101: pay_external_accounts pea,
102: pay_org_payment_methods_f opm,
103: pay_payroll_actions ppa
104: where ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
105: and opm.org_payment_method_id = ppa.org_payment_method_id
106: and ppa.effective_date
107: between opm.effective_start_date and opm.effective_end_date

Line 122: pay_payroll_actions ppa2, -- Prepay pact

118: 'P_DEST_BANK_NAME_KANA=P', bnk.bank_name_kana
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'))

Line 158: pay_payroll_actions ppa2, -- Prepay pact

154: per_all_assignments_f pa,
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'))