APPS.PAY_OPT_BUS dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 30: , pay_org_payment_methods_f opm

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pay_org_payment_methods_f opm
31: where opm.org_payment_method_id = p_org_payment_method_id
32: and pbg.business_group_id = opm.business_group_id;
33: --
34: -- Declare local variables

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 93: , pay_org_payment_methods_f opm

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
97: and pbg.business_group_id = opm.business_group_id;

Line 245: (p_org_payment_method_name in pay_org_payment_methods_f.org_payment_method_name%TYPE

241: -- Access Status:
242: -- Internal Row Handler Use Only.
243: --
244: Procedure chk_org_payment_method_name
245: (p_org_payment_method_name in pay_org_payment_methods_f.org_payment_method_name%TYPE
246: ,p_language in varchar2
247: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
248: ) is
249: --

Line 247: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE

243: --
244: Procedure chk_org_payment_method_name
245: (p_org_payment_method_name in pay_org_payment_methods_f.org_payment_method_name%TYPE
246: ,p_language in varchar2
247: ,p_org_payment_method_id in pay_org_payment_methods_f.org_payment_method_id%TYPE
248: ) is
249: --
250: l_proc varchar2(72) := g_package||'chk_org_payment_method_name';
251: l_api_updating boolean;

Line 256: from pay_org_payment_methods_f opm,

252: l_dummy number;
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

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

Line 264: from pay_org_payment_methods_f opm1

260: and opm.org_payment_method_id = opt.org_payment_method_id
261: and opm.org_payment_method_id <> p_org_payment_method_id
262: and exists
263: (select null
264: from pay_org_payment_methods_f opm1
265: where opm1.org_payment_method_id = p_org_payment_method_id
266: and opm1.business_group_id = opm.business_group_id);
267: --
268: --