[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ppa.effective_date,
ppa.org_payment_method_id,
ppa.overriding_dd_date DIRECT_DEPOSIT_DATE,
opm.currency_code,
fnd_currency.get_format_mask(opm.currency_code,18) CURRENCY_FORMAT_MASK,
opm.pmeth_information1 CLIENT_NUMBER,
opm.pmeth_information2 CLIENT_NAME,
opm.pmeth_information3 PACKAGE_NAME,
opmtl.org_payment_method_name,
opm.external_account_id,
bnk.bank_code,
bnk.bank_name,
bnk.bank_name_kana,
bch.branch_code,
bch.branch_name,
bch.branch_name_kana,
pea.segment7 ACCOUNT_TYPE,
pea.segment8 ACCOUNT_NUMBER,
pea.segment9 ACCOUNT_NAME,
pea.segment10 DESCRIPTION1,
pea.segment11 DESCRIPTION2,
hr_general.decode_lookup('JP_ZENGIN_TRANSACTION_TYPE',P_TRANSACTION_TYPE) D_TRANSACTION_TYPE,
hr_general.decode_lookup('JP_ZENGIN_CHARACTER_SET_CODE',P_CHARACTER_SET_CODE) CHARACTER_SET_NAME
from pay_jp_bank_branches bch,
pay_jp_banks bnk,
pay_external_accounts pea,
pay_org_payment_methods_f_tl opmtl,
pay_org_payment_methods_f opm,
pay_payroll_actions ppa
where ppa.payroll_action_id = P_PAYROLL_ACTION_ID
and opm.org_payment_method_id = ppa.org_payment_method_id
and ppa.effective_date
between opm.effective_start_date and opm.effective_end_date
and opmtl.org_payment_method_id = opm.org_payment_method_id
and opmtl.language = userenv('LANG')
and pea.external_account_id = opm.external_account_id
and bnk.bank_code = pea.segment1
and bch.bank_code = bnk.bank_code
and bch.branch_code = pea.segment4;