APPS.BEN_CPP_BUS dependencies on BEN_PL_F

Line 164: from ben_pl_f

160: is
161: l_proc varchar2(72) := g_package||' chk_plan_allowed_in_pgm ';
162: l_pl_cd varchar2(30);
163: cursor c1 is select pl_cd
164: from ben_pl_f
165: where pl_id = p_pl_id
166: and p_effective_date between effective_start_date
167: and effective_end_date
168: and business_group_id = p_business_group_id;

Line 2735: from ben_pl_f

2731: l_count number;
2732: l_imptd_incm_cd varchar2(30);
2733: --
2734: cursor pl_is_imputed is select imptd_incm_calc_cd
2735: from ben_pl_f
2736: where pl_id = p_pl_id
2737: and p_effective_date between effective_start_date
2738: and effective_end_date
2739: and business_group_id +0 = p_business_group_id;

Line 2742: from ben_pl_f pl,

2738: and effective_end_date
2739: and business_group_id +0 = p_business_group_id;
2740: --
2741: cursor count_plans is select count(distinct pl.pl_id)
2742: from ben_pl_f pl,
2743: ben_plip_f plip
2744: where plip.pgm_id = p_pgm_id
2745: and plip.pl_id = pl.pl_id
2746: and pl.imptd_incm_calc_cd = 'PRTT'

Line 2826: from ben_pl_f

2822: l_flag varchar2(30);
2823: l_pgm_typ_cd ben_pgm_f.pgm_typ_cd%type;
2824: --
2825: cursor pl_is_flex is select invk_flx_cr_pl_flag
2826: from ben_pl_f
2827: where pl_id = p_pl_id
2828: and p_effective_date between effective_start_date
2829: and effective_end_date
2830: and business_group_id = p_business_group_id;

Line 2839: from ben_pl_f pl,

2835: and p_effective_date between effective_start_date and effective_end_date
2836: and business_group_id = p_business_group_id;
2837: --
2838: cursor count_plans is select count(distinct pl.pl_id)
2839: from ben_pl_f pl,
2840: ben_plip_f plip
2841: where plip.pgm_id = p_pgm_id
2842: and plip.pl_id = pl.pl_id
2843: and pl.invk_flx_cr_pl_flag = 'Y'

Line 4274: (p_base_table_name => 'ben_pl_f',

4270: Raise l_integrity_error;
4271: End If;
4272: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
4273: NOT (dt_api.check_min_max_dates
4274: (p_base_table_name => 'ben_pl_f',
4275: p_base_key_column => 'pl_id',
4276: p_base_key_value => p_pl_id,
4277: p_from_date => p_validation_start_date,
4278: p_to_date => p_validation_end_date))) Then

Line 4279: l_table_name := 'ben_pl_f';

4275: p_base_key_column => 'pl_id',
4276: p_base_key_value => p_pl_id,
4277: p_from_date => p_validation_start_date,
4278: p_to_date => p_validation_end_date))) Then
4279: l_table_name := 'ben_pl_f';
4280: Raise l_integrity_error;
4281: End If;
4282: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
4283: NOT (dt_api.check_min_max_dates