APPS.PAY_JP_ZENGIN_TAPE dependencies on PAY_JP_BANKS

Line 100: pay_jp_banks bnk,

96: 'P_SOURCE_ACCOUNT_TYPE=P', pea.segment7,
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'))

Line 119: from pay_jp_banks bnk,

115: CURSOR csr_dest_bank IS
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