[Home] [Help]
30: -- post tax employee contribution 2897063
31:
32: cursor c_post_tax_contrib(p_eot in date) is
33: select prv.rt_val , prv.tx_typ_cd,prv.acty_typ_cd
34: from ben_prtt_enrt_rslt_f pen,
35: ben_prtt_rt_val prv,
36: ben_acty_base_rt_f abr,
37: ben_pl_f pln,
38: ben_per_in_ler pil
64: l_post_tax_amount number := 0 ;
65: --
66: cursor c_ben_amt(p_highly_comp in varchar2,p_eot in date) is
67: select sum(pen.bnft_amt)
68: from ben_prtt_enrt_rslt_f pen,
69: ben_pl_f pln,
70: ben_per_in_ler pil
71: where pen.person_id = p_person_id
72: and pen.prtt_enrt_rslt_stat_cd is null
140: pen.pl_id,
141: pen.oipl_id,
142: pen.pgm_id,
143: pen.pl_typ_id
144: from ben_prtt_enrt_rslt_f pen
145: where pen.business_group_id = p_business_group_id and
146: pen.prtt_enrt_rslt_stat_cd is null and
147: pen.pl_id = p_pl_id and
148: pen.oipl_id is null and
158: pen.oipl_id,
159: pen.pgm_id,
160: pen.pl_typ_id
161: from ben_pl_f pln,
162: ben_prtt_enrt_rslt_f pen
163: where pln.imptd_incm_calc_cd = p_imptd_incm_calc_cd
164: and pln.pl_stat_cd = 'A'
165: and p_effective_date
166: between pln.effective_start_date
210: and prv.rt_end_dt = hr_api.g_eot;
211: --
212: cursor c_pgm_enrt_rslt_exists(p_pgm_id in number) is
213: select null
214: from ben_prtt_enrt_rslt_f pen,
215: ben_pl_f pln
216: where pen.business_group_id = p_business_group_id
217: and pen.prtt_enrt_rslt_stat_cd is null
218: and pen.pgm_id = p_pgm_id
296: l_asgn_on_enrt_flag varchar2(100);
297: l_use_to_calc_net_flx_cr_flag varchar2(100);
298: l_uom varchar2(100);
299: --
300: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;
301: l_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%TYPE;
302: l_prtt_rt_val_id1 ben_prtt_rt_val.prtt_rt_val_id%TYPE;
303: l_prtt_rt_val_id2 ben_prtt_rt_val.prtt_rt_val_id%TYPE;
304: l_prtt_rt_val_id3 ben_prtt_rt_val.prtt_rt_val_id%TYPE;
308: l_prtt_rt_val_id7 ben_prtt_rt_val.prtt_rt_val_id%TYPE;
309: l_prtt_rt_val_id8 ben_prtt_rt_val.prtt_rt_val_id%TYPE;
310: l_prtt_rt_val_id9 ben_prtt_rt_val.prtt_rt_val_id%TYPE;
311: l_prtt_rt_val_id10 ben_prtt_rt_val.prtt_rt_val_id%TYPE;
312: l_effective_start_date ben_prtt_enrt_rslt_f.effective_start_date%TYPE;
313: l_effective_end_date ben_prtt_enrt_rslt_f.effective_end_date%TYPE;
314: l_object_version_number ben_prtt_enrt_rslt_f.object_version_number%TYPE;
315: l_nnmntry_uom varchar2(100);
316: l_entr_val_at_enrt_flag varchar2(30);
309: l_prtt_rt_val_id8 ben_prtt_rt_val.prtt_rt_val_id%TYPE;
310: l_prtt_rt_val_id9 ben_prtt_rt_val.prtt_rt_val_id%TYPE;
311: l_prtt_rt_val_id10 ben_prtt_rt_val.prtt_rt_val_id%TYPE;
312: l_effective_start_date ben_prtt_enrt_rslt_f.effective_start_date%TYPE;
313: l_effective_end_date ben_prtt_enrt_rslt_f.effective_end_date%TYPE;
314: l_object_version_number ben_prtt_enrt_rslt_f.object_version_number%TYPE;
315: l_nnmntry_uom varchar2(100);
316: l_entr_val_at_enrt_flag varchar2(30);
317: l_dsply_on_enrt_flag varchar2(30);
310: l_prtt_rt_val_id9 ben_prtt_rt_val.prtt_rt_val_id%TYPE;
311: l_prtt_rt_val_id10 ben_prtt_rt_val.prtt_rt_val_id%TYPE;
312: l_effective_start_date ben_prtt_enrt_rslt_f.effective_start_date%TYPE;
313: l_effective_end_date ben_prtt_enrt_rslt_f.effective_end_date%TYPE;
314: l_object_version_number ben_prtt_enrt_rslt_f.object_version_number%TYPE;
315: l_nnmntry_uom varchar2(100);
316: l_entr_val_at_enrt_flag varchar2(30);
317: l_dsply_on_enrt_flag varchar2(30);
318: l_dpnt_actn_warning boolean;
1017: and pln.effective_end_date;
1018: --
1019: cursor c_imp_shell is
1020: select 'Y'
1021: from ben_prtt_enrt_rslt_f pen
1022: where pen.person_id = p_person_id
1023: and pen.comp_lvl_cd = 'PLANIMP'
1024: and pen.effective_end_date = to_date('31-12-4712','dd-mm-yyyy')
1025: and pen.prtt_enrt_rslt_stat_cd is null