APPS.BEN_EFC_ADJUSTMENTS1 dependencies on BEN_PRTT_ENRT_RSLT_F

Line 61: ,enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type

57: ,creation_date ben_per_in_ler.creation_date%type
58: ,last_update_date ben_per_in_ler.last_update_date%type
59: ,object_version_number ben_per_in_ler.object_version_number%type
60: /*
61: ,enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type
62: */
63: );
64: --
65: c_efc_rows cur_type;

Line 147: ben_prtt_enrt_rslt_f pen,

143: prv.MLT_CD,
144: pil.person_id,
145: pil.per_in_ler_id
146: from ben_prtt_rt_val prv,
147: ben_prtt_enrt_rslt_f pen,
148: ben_per_in_ler pil
149: where prv.prtt_rt_val_id = c_prv_id
150: and pil.lf_evt_ocrd_dt
151: between pen.effective_start_date and pen.effective_end_date

Line 251: from ben_prtt_enrt_rslt_f pen

247: pen.prtt_enrt_rslt_stat_cd,
248: pen.enrt_ovridn_flag,
249: pen.sspndd_flag,
250: pen.enrt_mthd_cd
251: from ben_prtt_enrt_rslt_f pen
252: where pen.prtt_enrt_rslt_id = c_pen_id
253: and c_eff_date
254: between pen.effective_start_date and pen.effective_end_date;
255: --

Line 264: from ben_prtt_enrt_rslt_f pen

260: )
261: is
262: select pen.effective_end_date,
263: pen.prtt_enrt_rslt_stat_cd
264: from ben_prtt_enrt_rslt_f pen
265: where pen.prtt_enrt_rslt_id = c_pen_id;
266: --
267: l_dtpendets c_dtpendets%rowtype;
268: --

Line 338: ben_prtt_enrt_rslt_f pen

334: pel.acty_ref_perd_cd
335: from ben_elig_per_elctbl_chc epe,
336: ben_per_in_ler pil,
337: ben_pil_elctbl_chc_popl pel,
338: ben_prtt_enrt_rslt_f pen
339: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
340: and pil.per_in_ler_id = epe.per_in_ler_id
341: and pil.per_in_ler_id = c_pil_id
342: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 1890: ,enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type

1886: ,prv_last_update_date ben_prtt_rt_val.last_update_date%type
1887: ,prv_last_update_login ben_prtt_rt_val.last_update_login%type
1888: ,prv_created_by ben_prtt_rt_val.created_by%type
1889: ,screen_entry_value pay_element_entry_values_f.screen_entry_value%type
1890: ,enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type
1891: ,business_group_id ben_prtt_rt_val.business_group_id%type
1892: ,prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type
1893: ,acty_ref_perd_cd ben_prtt_rt_val.acty_ref_perd_cd%type
1894: ,acty_base_rt_id ben_prtt_rt_val.acty_base_rt_id%type

Line 2087: ||' ben_prtt_enrt_rslt_f pen, '

2083: end if;
2084: --
2085: l_from_str := ' FROM pay_element_entry_values_f eev, '
2086: ||' ben_prtt_rt_val prv, '
2087: ||' ben_prtt_enrt_rslt_f pen, '
2088: ||' ben_acty_base_rt_f abr, '
2089: ||' ben_per_in_ler pil, '
2090: ||' per_all_people_f per ';
2091: --

Line 2102: ||' from ben_prtt_enrt_rslt_f pen1 '

2098: ||' and prv.rt_strt_dt '
2099: ||' between pen.effective_start_date and pen.effective_end_date '
2100: ||' and pen.effective_start_date = '
2101: ||' (select min(pen1.effective_start_date) '
2102: ||' from ben_prtt_enrt_rslt_f pen1 '
2103: ||' where pen.prtt_enrt_rslt_id = pen1.prtt_enrt_rslt_id '
2104: ||' ) '
2105: ||' and prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id '
2106: ||' and prv.acty_base_rt_id = abr.acty_base_rt_id '