APPS.PAY_ORG_PAYMENT_METHOD_API dependencies on PER_BUSINESS_GROUPS

Line 288: from per_business_groups pbg

284: where nvl(db.business_group_id,v_business_group_id) = v_business_group_id
285: and ((db.legislation_code is null)
286: or exists
287: (select null
288: from per_business_groups pbg
289: where pbg.business_group_id = v_business_group_id
290: and pbg.legislation_code = db.legislation_code))
291: and db.balance_dimension_id = bd.balance_dimension_id
292: and db.balance_type_id = bt.balance_type_id

Line 300: per_business_groups pbg

296: --
297: cursor csr_territory_code (v_payment_type_id number, v_business_group_id number) is
298: select nvl(ppt.territory_code,pbg.legislation_code)
299: from pay_payment_types ppt,
300: per_business_groups pbg
301: where ppt.payment_type_id = v_payment_type_id
302: and pbg.business_group_id = v_business_group_id;
303: --
304: cursor csr_currency_code (v_payment_type_id number) is

Line 1800: , per_business_groups pbg

1796: cursor csr_territory_code (v_org_payment_method_id number) is
1797: select nvl(pty.territory_code,pbg.legislation_code)
1798: from pay_payment_types pty
1799: , pay_org_payment_methods_f opm
1800: , per_business_groups pbg
1801: where opm.org_payment_method_id = v_org_payment_method_id
1802: and pty.payment_type_id = opm.payment_type_id
1803: and pbg.business_group_id = opm.business_group_id;
1804: --