APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_ACTY_BASE_RT_F

Line 5542: ,ben_acty_base_rt_f abr

5538: ,abr.input_value_id
5539: ,prv.rt_strt_dt
5540: from ben_prtt_rt_val prv
5541: ,ben_enrt_rt ecr
5542: ,ben_acty_base_rt_f abr
5543: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5544: and prv.prtt_rt_val_stat_cd is null
5545: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id (+) */
5546: /* joining ecr with choice id or benefit id is removed as ecr will be

Line 5578: ,ben_acty_base_rt_f abr

5574: ,abr.element_type_id
5575: ,abr.input_value_id
5576: ,prv.rt_strt_dt
5577: from ben_prtt_rt_val prv
5578: ,ben_acty_base_rt_f abr
5579: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5580: and prv.prtt_rt_val_stat_cd is null
5581: and prv.business_group_id = p_business_group_id
5582: and prv.acty_base_rt_id = abr.acty_base_rt_id

Line 5605: from ben_acty_base_rt_f abr,

5601: --
5602: cursor c_abr (p_acty_base_rt_id number) is
5603: select py.processing_type,
5604: abr.rcrrg_cd
5605: from ben_acty_base_rt_f abr,
5606: pay_element_types_f py
5607: where abr.element_type_id = py.element_type_id(+)
5608: and abr.acty_base_rt_id = p_acty_base_rt_id
5609: and p_effective_date between abr.effective_start_date

Line 6168: ,ben_acty_base_rt_f abr

6164: ,prv.acty_base_rt_id
6165: ,abr.element_type_id
6166: ,abr.input_value_id
6167: from ben_prtt_rt_val prv
6168: ,ben_acty_base_rt_f abr
6169: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6170: and prv.rt_end_dt = hr_api.g_eot
6171: and prv.business_group_id = p_business_group_id
6172: and prv.acty_base_rt_id = abr.acty_base_rt_id

Line 6188: ,ben_acty_base_rt_f abr

6184: ,prv.acty_base_rt_id
6185: ,abr.element_type_id
6186: ,abr.input_value_id
6187: from ben_prtt_rt_val prv
6188: ,ben_acty_base_rt_f abr
6189: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6190: and prv.per_in_ler_id <> p_per_in_ler_id -- basu
6191: and prv.rt_end_dt > p_rt_end_dt
6192: and prv.rt_end_dt <> hr_api.g_eot

Line 6262: ,ben_acty_base_rt_f abr

6258: ,abr.entr_val_at_enrt_flag
6259: ,prv.rt_strt_dt
6260: from ben_prtt_rt_val prv
6261: ,ben_enrt_rt ecr
6262: ,ben_acty_base_rt_f abr
6263: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6264: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id (+)
6265: and prv.business_group_id = p_business_group_id
6266: and nvl(prv.acty_base_rt_id,-1) = abr.acty_base_rt_id (+)

Line 6303: ,ben_acty_base_rt_f abr

6299: ,abr.input_value_id
6300: ,prv.rt_end_dt --This is needed to determine the future started rate
6301: from ben_prtt_rt_val prv
6302: ,ben_enrt_rt ecr
6303: ,ben_acty_base_rt_f abr
6304: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6305: and prv.rt_end_dt > p_rt_end_dt
6306: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id (+)
6307: and prv.business_group_id = p_business_group_id

Line 6316: from ben_acty_base_rt_f abr,

6312: --
6313: cursor c_abr (p_acty_base_rt_id number) is
6314: select py.processing_type,
6315: abr.rcrrg_cd
6316: from ben_acty_base_rt_f abr,
6317: pay_element_types_f py
6318: where abr.element_type_id = py.element_type_id(+)
6319: and abr.acty_base_rt_id = p_acty_base_rt_id
6320: and p_effective_date between abr.effective_start_date

Line 6660: ben_acty_base_rt_f abr

6656: abr.input_value_id,
6657: abr.element_type_id
6658: FROM ben_prtt_rt_val oldprv,
6659: ben_prtt_rt_val curprv,
6660: ben_acty_base_rt_f abr
6661: WHERE curprv.business_group_id=oldprv.business_group_id
6662: AND curprv.per_in_ler_id = oldprv.ended_per_in_ler_id
6663: AND oldprv.rt_end_dt <> hr_api.g_eot
6664: AND oldprv.acty_base_rt_id = curprv.acty_base_rt_id

Line 6791: ,ben_acty_base_rt_f abr

6787: ,abr.element_type_id
6788: ,abr.input_value_id
6789: ,prv.rt_strt_dt
6790: from ben_prtt_rt_val prv
6791: ,ben_acty_base_rt_f abr
6792: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6793: -- bug: 5550679
6794: and prv.per_in_ler_id = p_per_in_ler_id
6795: --