DBA Data[Home] [Help]

APPS.PAY_OPT_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: from per_business_groups pbg

25: -- Declare cursor
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: --

Line 91: from per_business_groups pbg

87: -- Declare cursor
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