DBA Data[Home] [Help]

APPS.BEN_XCT_BUS dependencies on PER_BUSINESS_GROUPS

Line 23: from per_business_groups pbg

19: -- Declare cursor
20: --
21: cursor csr_sec_grp is
22: select pbg.security_group_id
23: from per_business_groups pbg
24: , ben_ext_crit_typ xct
25: where xct.ext_crit_typ_id = p_ext_crit_typ_id
26: and pbg.business_group_id = xct.business_group_id;
27: --

Line 731: from per_business_groups a,

727: -- Declare cursor
728: --
729: cursor csr_leg_code is
730: select a.legislation_code
731: from per_business_groups a,
732: ben_ext_crit_typ b
733: where b.ext_crit_typ_id = p_ext_crit_typ_id
734: and a.business_group_id(+) = b.business_group_id;
735: --