APPS.BEN_EFC_ADJUSTMENTS1 dependencies on BEN_ACTY_BASE_RT_F

Line 229: from ben_acty_base_rt_f abr

225: abr.plip_id,
226: abr.oipl_id,
227: abr.oiplip_id,
228: abr.actl_prem_id
229: from ben_acty_base_rt_f abr
230: where abr.acty_base_rt_id = c_abr_id
231: and c_eff_date
232: between abr.effective_start_date and abr.effective_end_date;
233: --

Line 465: , ben_acty_base_rt_f abr

461: abr.oiplip_id,
462: abr.nnmntry_uom
463: FROM ben_vrbl_rt_prfl_f vpf
464: , ben_acty_vrbl_rt_f avr
465: , ben_acty_base_rt_f abr
466: WHERE avr.vrbl_rt_prfl_id = c_vpf_id
467: AND vpf.VRBL_USG_CD = 'RT'
468: AND vpf.vrbl_rt_prfl_id = avr.vrbl_rt_prfl_id
469: AND avr.acty_base_rt_id = abr.acty_base_rt_id

Line 477: ben_acty_base_rt_f abr1

473: BETWEEN abr.effective_start_date AND abr.effective_end_date
474: AND avr.acty_base_rt_id =
475: (select min(avr1.acty_base_rt_id)
476: from ben_acty_vrbl_rt_f avr1,
477: ben_acty_base_rt_f abr1
478: where avr1.vrbl_rt_prfl_id = avr.vrbl_rt_prfl_id
479: AND vpf.effective_start_date
480: BETWEEN avr1.effective_start_date AND avr1.effective_end_date
481: AND avr1.acty_base_rt_id = abr1.acty_base_rt_id

Line 488: ben_acty_base_rt_f abr2

484: and abr1.NNMNTRY_UOM is null
485: and avr1.ordr_num =
486: (select min(avr2.ordr_num)
487: from ben_acty_vrbl_rt_f avr2,
488: ben_acty_base_rt_f abr2
489: where avr2.vrbl_rt_prfl_id = avr.vrbl_rt_prfl_id
490: AND vpf.effective_start_date
491: BETWEEN avr2.effective_start_date AND avr2.effective_end_date
492: AND avr2.acty_base_rt_id = abr1.acty_base_rt_id

Line 1899: ,input_value_id ben_acty_base_rt_f.input_value_id%type

1895: ,prtt_enrt_rslt_id ben_prtt_rt_val.prtt_enrt_rslt_id%type
1896: ,rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type
1897: ,rt_val ben_prtt_rt_val.rt_val%type
1898: ,prv_ovn ben_prtt_rt_val.object_version_number%type
1899: ,input_value_id ben_acty_base_rt_f.input_value_id%type
1900: ,element_type_id ben_acty_base_rt_f.element_type_id%type
1901: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1902: ,person_id ben_per_in_ler.person_id%type
1903: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type

Line 1900: ,element_type_id ben_acty_base_rt_f.element_type_id%type

1896: ,rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type
1897: ,rt_val ben_prtt_rt_val.rt_val%type
1898: ,prv_ovn ben_prtt_rt_val.object_version_number%type
1899: ,input_value_id ben_acty_base_rt_f.input_value_id%type
1900: ,element_type_id ben_acty_base_rt_f.element_type_id%type
1901: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1902: ,person_id ben_per_in_ler.person_id%type
1903: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
1904: ,ELEMENT_ENTRY_ID pay_element_entry_values_f.ELEMENT_ENTRY_ID%type

Line 1973: from ben_acty_base_rt_f abr

1969: )
1970: is
1971: select abr.last_update_date,
1972: abr.ele_rqd_flag
1973: from ben_acty_base_rt_f abr
1974: where abr.acty_base_rt_id = c_abr_id
1975: and c_eff_date
1976: between abr.effective_start_date and abr.effective_end_date;
1977: --

Line 2088: ||' ben_acty_base_rt_f abr, '

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: --
2092: l_where_str := ' where prv.element_entry_value_id = eev.element_entry_value_id '

Line 2111: ||' from ben_acty_base_rt_f abr1 '

2107: ||' and prv.rt_strt_dt '
2108: ||' between abr.effective_start_date and abr.effective_end_date '
2109: ||' and abr.effective_start_date = '
2110: ||' (select min(abr1.effective_start_date) '
2111: ||' from ben_acty_base_rt_f abr1 '
2112: ||' where abr.acty_base_rt_id = abr1.acty_base_rt_id '
2113: ||' ) '
2114: ||' and prv.per_in_ler_id = pil.per_in_ler_id '
2115: ||' and per.person_id = pil.person_id '