DBA Data[Home] [Help]

APPS.BEN_LSF_BUS dependencies on PER_BUSINESS_GROUPS

Line 265: ,per_business_groups pbg

261: --
262: cursor c1 is
263: select null
264: from ff_formulas_f ff
265: ,per_business_groups pbg
266: where ff.formula_id = p_los_calc_rl
267: and ff.formula_type_id = -510
268: and pbg.business_group_id = p_business_group_id
269: and nvl(ff.business_group_id, p_business_group_id) =

Line 730: ,per_business_groups pbg

726: --
727: cursor c1 is
728: select null
729: from ff_formulas_f ff
730: ,per_business_groups pbg
731: where ff.formula_id = p_los_det_rl
732: and ff.formula_type_id = -170
733: and pbg.business_group_id = p_business_group_id
734: and nvl(ff.business_group_id, p_business_group_id) =

Line 846: ,per_business_groups pbg

842: --
843: cursor c1 is
844: select null
845: from ff_formulas_f ff
846: ,per_business_groups pbg
847: where ff.formula_id = p_rndg_rl
848: and ff.formula_type_id = -169
849: and pbg.business_group_id = p_business_group_id
850: and nvl(ff.business_group_id, p_business_group_id) =

Line 960: ,per_business_groups pbg

956: --
957: cursor c1 is
958: select null
959: from ff_formulas_f ff
960: ,per_business_groups pbg
961: where ff.formula_id = p_los_dt_to_use_rl
962: and ff.formula_type_id = -156
963: and pbg.business_group_id = p_business_group_id
964: and nvl(ff.business_group_id, p_business_group_id) =

Line 1606: from per_business_groups a,

1602: -- Declare cursor
1603: --
1604: cursor csr_leg_code is
1605: select a.legislation_code
1606: from per_business_groups a,
1607: ben_los_fctr b
1608: where b.los_fctr_id = p_los_fctr_id
1609: and a.business_group_id = b.business_group_id;
1610: --