DBA Data[Home] [Help]

APPS.BEN_XCR_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_prfl xcr
25: where xcr.ext_crit_prfl_id = p_ext_crit_prfl_id
26: and pbg.business_group_id = xcr.business_group_id;
27: --

Line 473: from per_business_groups a,

469: -- Declare cursor
470: --
471: cursor csr_leg_code is
472: select a.legislation_code
473: from per_business_groups a,
474: ben_ext_crit_prfl b
475: where b.ext_crit_prfl_id = p_ext_crit_prfl_id
476: and a.business_group_id(+) = b.business_group_id;
477: --