DBA Data[Home] [Help]

APPS.PAY_PPM_BUS dependencies on PER_BUSINESS_GROUPS

Line 543: -- Bug 4644507. Removed the usage of per_business_groups from the cursor.

539: --
540: l_exists varchar2(1);
541: l_proc varchar2(72) := g_package||'chk_org_payment_method_id';
542: --
543: -- Bug 4644507. Removed the usage of per_business_groups from the cursor.
544: cursor csr_is_valid is
545: select null
546: from pay_org_payment_methods_f opm,
547: pay_payment_types ppt

Line 2022: from per_business_groups pbg

2018: -- Declare cursor
2019: --
2020: cursor csr_leg_code is
2021: select pbg.legislation_code
2022: from per_business_groups pbg
2023: , pay_personal_payment_methods_f ppm
2024: where ppm.personal_payment_method_id = p_personal_payment_method_id
2025: and pbg.business_group_id = ppm.business_group_id;
2026: --