APPS.PAY_JP_ZENGIN_TAPE dependencies on PAY_EXTERNAL_ACCOUNTS

Line 101: pay_external_accounts pea,

97: 'P_SOURCE_ACCOUNT_NUMBER=P', pea.segment8,
98: 'P_SOURCE_ACCOUNT_NAME_KANA=P', pea.segment9
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

Line 120: pay_external_accounts pea,

116: select 'P_DEST_BANK_CODE=P', bnk.bank_code,
117: 'P_DEST_BANK_NAME=P', bnk.bank_name,
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,

Line 156: pay_external_accounts pea,

152: 'P_PAYMENT=P', to_char(sum(ppp.value))
153: from per_all_people_f pp,
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,