[Home] [Help]
380: and plt.pl_typ_id = pln.pl_typ_id;
381: --
382: cursor c_plip is
383: select pl_id
384: from ben_plip_f
385: where plip_id = p_plip_id;
386: --
387: cursor c_oipl is
388: select pl_id
678: l_dummy varchar2(1) ;
679: l_proc varchar2(72) := g_package||'chk_entr_at_enrt_with_cvg';
680:
681: cursor c_oipl is select pl_id from
682: ben_plip_f where plip_id = p_plip_id and
683: p_effective_date between effective_start_date and effective_end_date ;
684:
685: cursor c_oiplip is select oipl_id from
686: ben_oiplip_f where oiplip_id = p_oiplip_id and
952:
953: cursor c_plip is
954: select 'x'
955: from ben_pl_f pln,
956: ben_plip_f plip
957: where plip.plip_id = p_plip_id
958: and pln.pl_id = plip.pl_id
959: and pln.subj_to_imptd_incm_typ_cd is not null
960: and p_effective_date between pln.effective_start_date
2204:
2205:
2206: cursor c_plip is select pl.alws_reimbmts_flag
2207: from ben_pl_f pl ,
2208: ben_plip_f plip
2209: where plip.plip_id = p_plip_id
2210: and p_effective_start_date between plip.effective_start_date and plip.effective_end_date
2211: and plip.business_group_id = p_business_group_id
2212: and pl.pl_id = plip.pl_id
4572: Raise l_integrity_error;
4573: End If;
4574: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
4575: NOT (dt_api.check_min_max_dates
4576: (p_base_table_name => 'ben_plip_f',
4577: p_base_key_column => 'plip_id',
4578: p_base_key_value => p_plip_id,
4579: p_from_date => p_validation_start_date,
4580: p_to_date => p_validation_end_date))) Then
4577: p_base_key_column => 'plip_id',
4578: p_base_key_value => p_plip_id,
4579: p_from_date => p_validation_start_date,
4580: p_to_date => p_validation_end_date))) Then
4581: l_table_name := 'ben_plip_f';
4582: Raise l_integrity_error;
4583: End If;
4584: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
4585: NOT (dt_api.check_min_max_dates