APPS.BEN_VPF_BUS dependencies on PER_BUSINESS_GROUPS

Line 636: ,per_business_groups pbg

632: --
633: cursor c1 is
634: select null
635: from ff_formulas_f ff
636: ,per_business_groups pbg
637: where ff.formula_id = p_val_calc_rl
638: and ff.formula_type_id in (-171, -49, -507)
639: and pbg.business_group_id = p_business_group_id
640: and nvl(ff.business_group_id, p_business_group_id) =

Line 729: ,per_business_groups pbg

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

Line 822: ,per_business_groups pbg

818: --
819: cursor c1 is
820: select null
821: from ff_formulas_f ff
822: ,per_business_groups pbg
823: where ff.formula_id = p_lwr_lmt_calc_rl
824: and ff.formula_type_id in (-392, -511, -512)
825: and pbg.business_group_id = p_business_group_id
826: and nvl(ff.business_group_id, p_business_group_id) =

Line 916: ,per_business_groups pbg

912: --
913: cursor c1 is
914: select null
915: from ff_formulas_f ff
916: ,per_business_groups pbg
917: where ff.formula_id = p_ultmt_lwr_lmt_calc_rl
918: and ff.formula_type_id in (-392, -511, -512)
919: and pbg.business_group_id = p_business_group_id
920: and nvl(ff.business_group_id, p_business_group_id) =

Line 1013: ,per_business_groups pbg

1009: --
1010: cursor c1 is
1011: select null
1012: from ff_formulas_f ff
1013: ,per_business_groups pbg
1014: where ff.formula_id = p_upr_lmt_calc_rl
1015: and ff.formula_type_id in (-293, -514, -515)
1016: and pbg.business_group_id = p_business_group_id
1017: and nvl(ff.business_group_id, p_business_group_id) =

Line 1107: ,per_business_groups pbg

1103: --
1104: cursor c1 is
1105: select null
1106: from ff_formulas_f ff
1107: ,per_business_groups pbg
1108: where ff.formula_id = p_ultmt_upr_lmt_calc_rl
1109: and ff.formula_type_id in (-293, -514, -515)
1110: and pbg.business_group_id = p_business_group_id
1111: and nvl(ff.business_group_id, p_business_group_id) =

Line 5588: from per_business_groups a,

5584: -- Declare cursor
5585: --
5586: cursor csr_leg_code is
5587: select a.legislation_code
5588: from per_business_groups a,
5589: ben_vrbl_rt_prfl_f b
5590: where b.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
5591: and a.business_group_id = b.business_group_id;
5592: --