APPS.PAY_OPM_BUS dependencies on PER_BUSINESS_GROUPS

Line 28: from per_business_groups pbg

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

Line 88: from per_business_groups pbg

84: -- Declare cursor
85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , pay_org_payment_methods_f opm
90: where opm.org_payment_method_id = p_org_payment_method_id
91: and pbg.business_group_id = opm.business_group_id;
92: --

Line 812: from per_business_groups pbg

808: and pty.territory_code = exa.territory_code)
809: or (pty.territory_code is null
810: and exists
811: (select null
812: from per_business_groups pbg
813: where pbg.business_group_id = p_business_group_id
814: and pbg.legislation_code = exa.territory_code))));
815: --
816: cursor csr_ext_chk is

Line 1074: per_business_groups pbg

1070: and lgr.rule_type = 'E'))
1071: and not exists
1072: (select 'x'
1073: from pay_payment_types pyt2,
1074: per_business_groups pbg
1075: where pyt2.category = pyt.category
1076: and pbg.business_group_id = p_business_group_id
1077: and pyt2.territory_code = pbg.legislation_code
1078: and pyt.territory_code is null

Line 1173: from per_business_groups pbg

1169: where nvl(db.business_group_id,p_business_group_id) = p_business_group_id
1170: and ((db.legislation_code is null)
1171: or exists
1172: (select null
1173: from per_business_groups pbg
1174: where pbg.business_group_id = p_business_group_id
1175: and pbg.legislation_code = db.legislation_code))
1176: and db.balance_dimension_id = bd.balance_dimension_id
1177: and db.balance_type_id = bt.balance_type_id