[Home] [Help]
326: -- start date and end date . thi may lead into a problem of entry is date tracked
327: -- curent entry is not taken for calc tath is added in calling proc this helps while updating
328: /*cursor c1 is select sum(nvl(prc.aprvd_for_pymt_amt,0))
329: from ben_prtt_reimbmt_rqst_f prc,
330: ben_pl_f pl,
331: ben_popl_yr_perd pyr,
332: ben_yr_perd yr
333: where prc.submitter_person_id = p_person_id
334: and prc.prtt_reimbmt_rqst_stat_cd not in ('DND','VOIDED','DPLICT')
1160: , pln.cmpr_clms_to_cvg_or_bal_cd
1161: ,pen.pgm_id
1162: ,per_in_ler_id
1163: from ben_prtt_enrt_rslt_f pen,
1164: ben_pl_f pln,
1165: ben_popl_yr_perd cpy,
1166: ben_yr_perd yrp
1167: where pln.pl_id = p_pl_id
1168: and pln.pl_id = pen.pl_id
1185: and pen_1.enrt_cvg_thru_dt >= yrp.start_date ) ;
1186: --
1187: cursor c_pln (p_pl_id number) is
1188: select pln.cmpr_clms_to_cvg_or_bal_cd
1189: from ben_pl_f pln
1190: where pln.pl_id = p_pl_id
1191: and pln.business_group_id = p_business_group_id
1192: and p_effective_date between pln.effective_start_date
1193: and pln.effective_end_date;
1530:
1531:
1532: cursor c_per is
1533: select 'x'
1534: from ben_prtt_enrt_rslt_f pen, ben_pl_f pln
1535: where pln.pl_id = p_pl_id
1536: and pln.pl_id = pen.pl_id
1537: and pen.person_id = p_submitter_person_id
1538: and pln.business_group_id = p_business_group_id
2095: p_argument_value => p_validation_end_date);
2096: --
2097: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
2098: NOT (dt_api.check_min_max_dates
2099: (p_base_table_name => 'ben_pl_f',
2100: p_base_key_column => 'pl_id',
2101: p_base_key_value => p_pl_id,
2102: p_from_date => p_validation_start_date,
2103: p_to_date => p_validation_end_date))) Then
2100: p_base_key_column => 'pl_id',
2101: p_base_key_value => p_pl_id,
2102: p_from_date => p_validation_start_date,
2103: p_to_date => p_validation_end_date))) Then
2104: l_table_name := 'ben_pl_f';
2105: Raise l_integrity_error;
2106: End If;
2107: --
2108: End If;