APPS.BEN_CTP_BUS dependencies on PER_BUSINESS_GROUPS

Line 2190: per_business_groups pbg

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
2194: and nvl(ff.business_group_id, p_business_group_id) =

Line 2286: per_business_groups pbg

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
2290: and nvl(ff.business_group_id, p_business_group_id) =

Line 2383: per_business_groups pbg

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
2387: and nvl(ff.business_group_id, p_business_group_id) =

Line 2479: per_business_groups pbg

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
2483: and nvl(ff.business_group_id, p_business_group_id) =

Line 2575: per_business_groups pbg

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
2579: and nvl(ff.business_group_id, p_business_group_id) =

Line 2672: per_business_groups pbg

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
2676: and nvl(ff.business_group_id, p_business_group_id) =

Line 2768: per_business_groups pbg

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
2772: and nvl(ff.business_group_id, p_business_group_id) =

Line 2864: per_business_groups pbg

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
2868: and nvl(ff.business_group_id, p_business_group_id) =

Line 2960: per_business_groups pbg

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
2964: and nvl(ff.business_group_id, p_business_group_id) =

Line 3278: per_business_groups pbg

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
3282: and nvl(ff.business_group_id, p_business_group_id) =

Line 3375: per_business_groups pbg

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
3379: and nvl(ff.business_group_id, p_business_group_id) =

Line 5998: from per_business_groups a,

5994: -- Declare cursor
5995: --
5996: cursor csr_leg_code is
5997: select a.legislation_code
5998: from per_business_groups a,
5999: ben_ptip_f b
6000: where b.ptip_id = p_ptip_id
6001: and a.business_group_id = b.business_group_id;
6002: --