DBA Data[Home] [Help]

APPS.BEN_CCM_BUS dependencies on PER_BUSINESS_GROUPS

Line 930: ,per_business_groups pbg

926: --
927: cursor c1 is
928: select null
929: from ff_formulas_f ff
930: ,per_business_groups pbg
931: where ff.formula_id = p_val_calc_rl
932: and ff.formula_type_id = -49
933: and pbg.business_group_id = p_business_group_id
934: and nvl(ff.business_group_id, p_business_group_id) =

Line 1094: ,per_business_groups pbg

1090: --
1091: cursor c1 is
1092: select null
1093: from ff_formulas_f ff
1094: ,per_business_groups pbg
1095: where ff.formula_id = p_rndg_rl
1096: and ff.formula_type_id = -169
1097: and pbg.business_group_id = p_business_group_id
1098: and nvl(ff.business_group_id, p_business_group_id) =

Line 1187: ,per_business_groups pbg

1183: --
1184: cursor c1 is
1185: select null
1186: from ff_formulas_f ff
1187: ,per_business_groups pbg
1188: where ff.formula_id = p_lwr_lmt_calc_rl
1189: and ff.formula_type_id = -511
1190: and pbg.business_group_id = p_business_group_id
1191: and nvl(ff.business_group_id, p_business_group_id) =

Line 1280: ,per_business_groups pbg

1276: --
1277: cursor c1 is
1278: select null
1279: from ff_formulas_f ff
1280: ,per_business_groups pbg
1281: where ff.formula_id = p_upr_lmt_calc_rl
1282: and ff.formula_type_id = -514
1283: and pbg.business_group_id = p_business_group_id
1284: and nvl(ff.business_group_id, p_business_group_id) =

Line 3033: from per_business_groups a,

3029: -- Declare cursor
3030: --
3031: cursor csr_leg_code is
3032: select a.legislation_code
3033: from per_business_groups a,
3034: ben_cvg_amt_calc_mthd_f b
3035: where b.cvg_amt_calc_mthd_id = p_cvg_amt_calc_mthd_id
3036: and a.business_group_id = b.business_group_id;
3037: --