DBA Data[Home] [Help]

APPS.BEN_XCC_BUS dependencies on PER_BUSINESS_GROUPS

Line 71: from per_business_groups pbg

67: -- Declare cursor
68: --
69: cursor csr_sec_grp is
70: select pbg.security_group_id
71: from per_business_groups pbg
72: , ben_ext_crit_cmbn xcc
73: where xcc.ext_crit_cmbn_id = p_ext_crit_cmbn_id
74: and pbg.business_group_id = xcc.business_group_id;
75: --

Line 966: from per_business_groups a,

962: -- Declare cursor
963: --
964: cursor csr_leg_code is
965: select a.legislation_code
966: from per_business_groups a,
967: ben_ext_crit_cmbn b
968: where b.ext_crit_cmbn_id = p_ext_crit_cmbn_id
969: and a.business_group_id(+) = b.business_group_id;
970: --