DBA Data[Home] [Help]

APPS.BEN_CLF_BUS dependencies on PER_BUSINESS_GROUPS

Line 191: ,per_business_groups pbg

187: --
188: cursor c1 is
189: select null
190: from ff_formulas_f ff
191: ,per_business_groups pbg
192: where ff.formula_id = p_rndg_rl
193: and ff.formula_type_id = -169
194: and pbg.business_group_id = p_business_group_id
195: and nvl(ff.business_group_id, p_business_group_id) =

Line 366: ,per_business_groups pbg

362: --
363: cursor c1 is
364: select null
365: from ff_formulas_f ff
366: ,per_business_groups pbg
367: where ff.formula_id = p_comp_lvl_det_rl
368: and ff.formula_type_id = -174
369: and pbg.business_group_id = p_business_group_id
370: and nvl(ff.business_group_id, p_business_group_id) =

Line 975: ,per_business_groups pbg

971: --
972: cursor c1 is
973: select null
974: from ff_formulas_f ff
975: ,per_business_groups pbg
976: where ff.formula_id = p_comp_calc_rl
977: and ff.formula_type_id = -517
978: and pbg.business_group_id = p_business_group_id
979: and nvl(ff.business_group_id, p_business_group_id) =

Line 1787: from per_business_groups a,

1783: -- Declare cursor
1784: --
1785: cursor csr_leg_code is
1786: select a.legislation_code
1787: from per_business_groups a,
1788: ben_comp_lvl_fctr b
1789: where b.comp_lvl_fctr_id = p_comp_lvl_fctr_id
1790: and a.business_group_id = b.business_group_id;
1791: --