29: hr_general.decode_lookup('JP_ZENGIN_CHARACTER_SET_CODE',P_CHARACTER_SET_CODE) CHARACTER_SET_NAME
30: from pay_jp_bank_branches bch,
31: pay_jp_banks bnk,
32: pay_external_accounts pea,
33: pay_org_payment_methods_f_tl opmtl,
34: pay_org_payment_methods_f opm,
35: pay_payroll_actions ppa
36: where ppa.payroll_action_id = P_PAYROLL_ACTION_ID
37: and opm.org_payment_method_id = ppa.org_payment_method_id
30: from pay_jp_bank_branches bch,
31: pay_jp_banks bnk,
32: pay_external_accounts pea,
33: pay_org_payment_methods_f_tl opmtl,
34: pay_org_payment_methods_f opm,
35: pay_payroll_actions ppa
36: where ppa.payroll_action_id = P_PAYROLL_ACTION_ID
37: and opm.org_payment_method_id = ppa.org_payment_method_id
38: and ppa.effective_date