APPS.BEN_CTP_BUS dependencies on FF_FORMULAS_F

Line 2189: from ff_formulas_f ff ,

2185: l_dummy varchar2(1);
2186: --
2187: cursor c1 is
2188: select null
2189: from ff_formulas_f ff ,
2190: per_business_groups pbg
2191: where ff.formula_id = p_postelcn_edit_rl
2192: and ff.formula_type_id = -215 /*default enrollment det */
2193: and pbg.business_group_id = p_business_group_id

Line 2285: from ff_formulas_f ff ,

2281: l_dummy varchar2(1);
2282: --
2283: cursor c1 is
2284: select null
2285: from ff_formulas_f ff ,
2286: per_business_groups pbg
2287: where ff.formula_id = p_rt_end_dt_rl
2288: and ff.formula_type_id = -67 /*rt_end */
2289: and pbg.business_group_id = p_business_group_id

Line 2382: from ff_formulas_f ff ,

2378: l_dummy varchar2(1);
2379: --
2380: cursor c1 is
2381: select null
2382: from ff_formulas_f ff ,
2383: per_business_groups pbg
2384: where ff.formula_id = p_rt_strt_dt_rl
2385: and ff.formula_type_id = -66 /*rt_strt */
2386: and pbg.business_group_id = p_business_group_id

Line 2478: from ff_formulas_f ff ,

2474: l_dummy varchar2(1);
2475: --
2476: cursor c1 is
2477: select null
2478: from ff_formulas_f ff ,
2479: per_business_groups pbg
2480: where ff.formula_id = p_enrt_cvg_end_dt_rl
2481: and ff.formula_type_id = -30 /*enrt_cvg_end */
2482: and pbg.business_group_id = p_business_group_id

Line 2574: from ff_formulas_f ff ,

2570: l_dummy varchar2(1);
2571: --
2572: cursor c1 is
2573: select null
2574: from ff_formulas_f ff ,
2575: per_business_groups pbg
2576: where ff.formula_id = p_enrt_cvg_strt_dt_rl
2577: and ff.formula_type_id = -29 /*enrt_cvg_strt */
2578: and pbg.business_group_id = p_business_group_id

Line 2671: from ff_formulas_f ff ,

2667: l_dummy varchar2(1);
2668: --
2669: cursor c1 is
2670: select null
2671: from ff_formulas_f ff ,
2672: per_business_groups pbg
2673: where ff.formula_id = p_rqd_perd_enrt_nenrt_rl
2674: and ff.formula_type_id = -513
2675: and pbg.business_group_id = p_business_group_id

Line 2767: from ff_formulas_f ff ,

2763: l_dummy varchar2(1);
2764: --
2765: cursor c1 is
2766: select null
2767: from ff_formulas_f ff ,
2768: per_business_groups pbg
2769: where ff.formula_id = p_auto_enrt_mthd_rl
2770: and ff.formula_type_id = -146
2771: and pbg.business_group_id = p_business_group_id

Line 2863: from ff_formulas_f ff ,

2859: l_dummy varchar2(1);
2860: --
2861: cursor c1 is
2862: select null
2863: from ff_formulas_f ff ,
2864: per_business_groups pbg
2865: where ff.formula_id = p_enrt_rl
2866: and ff.formula_type_id = -393
2867: and pbg.business_group_id = p_business_group_id

Line 2959: from ff_formulas_f ff ,

2955: l_dummy varchar2(1);
2956: --
2957: cursor c1 is
2958: select null
2959: from ff_formulas_f ff ,
2960: per_business_groups pbg
2961: where ff.formula_id = p_dflt_enrt_det_rl
2962: and ff.formula_type_id = -32
2963: and pbg.business_group_id = p_business_group_id

Line 3277: from ff_formulas_f ff ,

3273: l_dummy varchar2(1);
3274: --
3275: cursor c1 is
3276: select null
3277: from ff_formulas_f ff ,
3278: per_business_groups pbg
3279: where ff.formula_id = p_dpnt_cvg_end_dt_rl
3280: and ff.formula_type_id = -28 /*default enrollment det */
3281: and pbg.business_group_id = p_business_group_id

Line 3374: from ff_formulas_f ff ,

3370: l_dummy varchar2(1);
3371: --
3372: cursor c1 is
3373: select null
3374: from ff_formulas_f ff ,
3375: per_business_groups pbg
3376: where ff.formula_id = p_dpnt_cvg_strt_dt_rl
3377: and ff.formula_type_id = -27 /*default enrollment det */
3378: and pbg.business_group_id = p_business_group_id