DBA Data[Home] [Help]

APPS.PAY_OPT_BUS dependencies on PAY_ORG_PAYMENT_METHODS_F_TL

Line 92: , pay_org_payment_methods_f_tl opt

88: --
89: cursor csr_leg_code is
90: select pbg.legislation_code
91: from per_business_groups pbg
92: , pay_org_payment_methods_f_tl opt
93: , pay_org_payment_methods_f opm
94: where opt.org_payment_method_id = p_org_payment_method_id
95: and opt.language = p_language
96: and opm.org_payment_method_id = opt.org_payment_method_id

Line 257: pay_org_payment_methods_f_tl opt

253: --
254: cursor csr_org_pay_meth_name_exists is
255: select null
256: from pay_org_payment_methods_f opm,
257: pay_org_payment_methods_f_tl opt
258: where upper(opt.org_payment_method_name) = upper(p_org_payment_method_name)
259: and opt.language = p_language
260: and opm.org_payment_method_id = opt.org_payment_method_id
261: and opm.org_payment_method_id <> p_org_payment_method_id