DBA Data[Home] [Help]

APPS.BEN_XCV_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 177: from per_business_groups_perf pbg

173: -- Declare cursor
174: --
175: cursor csr_sec_grp is
176: select pbg.security_group_id
177: from per_business_groups_perf pbg
178: , ben_ext_crit_val xcv
179: where xcv.ext_crit_val_id = p_ext_crit_val_id
180: and pbg.business_group_id = xcv.business_group_id;
181: --

Line 380: from per_business_groups_perf a

376: l_dummy varchar2(1);
377: --
378: cursor c1 is
379: select null
380: from per_business_groups_perf a
381: where a.business_group_id = p_ext_crit_bg_id ;
382:
383: cursor c2 is
384: select ecp.ext_global_flag

Line 1230: from per_business_groups_perf a,

1226: -- Declare cursor
1227: --
1228: cursor csr_leg_code is
1229: select a.legislation_code
1230: from per_business_groups_perf a,
1231: ben_ext_crit_val b
1232: where b.ext_crit_val_id = p_ext_crit_val_id
1233: and a.business_group_id(+) = b.business_group_id;
1234: --