[Home] [Help]
197: ben_acty_base_rt_f where pl_id = p_pl_id and
198: rt_mlt_cd = 'CVG' and entr_val_at_enrt_flag = 'Y' and
199: p_effective_date between effective_start_date and effective_end_date ;
200:
201: cursor c_plip is select 'x' from ben_acty_base_rt_f a , ben_plip_f b where
202: a.plip_id = b.plip_id and a.rt_mlt_cd = 'CVG' and a.entr_val_at_enrt_flag = 'Y' and
203: p_effective_date between a.effective_start_date and a.effective_end_date and
204: b.pl_id = p_pl_id and p_effective_date between b.effective_start_date and b.effective_end_date;
205:
1838: and p_effective_date between lbr.effective_start_date
1839: and lbr.effective_end_date;
1840:
1841: cursor c4 is select 'x'
1842: from ben_plip_f pip
1843: Where pip.dflt_to_asn_pndg_ctfn_cd like '%NL%'
1844: and pip.pl_id = p_pl_id
1845: and p_effective_date between pip.effective_start_date
1846: and pip.effective_end_date;
2085: Raise l_integrity_error;
2086: End If;
2087: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
2088: NOT (dt_api.check_min_max_dates
2089: (p_base_table_name => 'ben_plip_f',
2090: p_base_key_column => 'plip_id',
2091: p_base_key_value => p_plip_id,
2092: p_from_date => p_validation_start_date,
2093: p_to_date => p_validation_end_date))) Then
2090: p_base_key_column => 'plip_id',
2091: p_base_key_value => p_plip_id,
2092: p_from_date => p_validation_start_date,
2093: p_to_date => p_validation_end_date))) Then
2094: l_table_name := 'ben_plip_f';
2095: Raise l_integrity_error;
2096: End If;
2097: --
2098: End If;