eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_ACTY_BASE_RT_F

Line 5831: ,ben_acty_base_rt_f abr

5827: ,abr.input_value_id
5828: ,prv.rt_strt_dt
5829: from ben_prtt_rt_val prv
5830: ,ben_enrt_rt ecr
5831: ,ben_acty_base_rt_f abr
5832: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5833: and prv.prtt_rt_val_stat_cd is null
5834: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id (+) */
5835: /* joining ecr with choice id or benefit id is removed as ecr will be

Line 5867: ,ben_acty_base_rt_f abr

5863: ,abr.element_type_id
5864: ,abr.input_value_id
5865: ,prv.rt_strt_dt
5866: from ben_prtt_rt_val prv
5867: ,ben_acty_base_rt_f abr
5868: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5869: and prv.prtt_rt_val_stat_cd is null
5870: and prv.business_group_id = p_business_group_id
5871: and prv.acty_base_rt_id = abr.acty_base_rt_id

Line 5894: from ben_acty_base_rt_f abr,

5890: --
5891: cursor c_abr (p_acty_base_rt_id number) is
5892: select py.processing_type,
5893: abr.rcrrg_cd
5894: from ben_acty_base_rt_f abr,
5895: pay_element_types_f py
5896: where abr.element_type_id = py.element_type_id(+)
5897: and abr.acty_base_rt_id = p_acty_base_rt_id
5898: and p_effective_date between abr.effective_start_date

Line 6457: ,ben_acty_base_rt_f abr

6453: ,prv.acty_base_rt_id
6454: ,abr.element_type_id
6455: ,abr.input_value_id
6456: from ben_prtt_rt_val prv
6457: ,ben_acty_base_rt_f abr
6458: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6459: and prv.rt_end_dt = hr_api.g_eot
6460: and prv.business_group_id = p_business_group_id
6461: and prv.acty_base_rt_id = abr.acty_base_rt_id

Line 6477: ,ben_acty_base_rt_f abr

6473: ,prv.acty_base_rt_id
6474: ,abr.element_type_id
6475: ,abr.input_value_id
6476: from ben_prtt_rt_val prv
6477: ,ben_acty_base_rt_f abr
6478: ,ben_per_in_ler pil -- Bug 8573195,not to pick the rows of backed out lifevent for rate adjustment
6479: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6480: and prv.rt_end_dt > p_rt_end_dt
6481: and prv.per_in_ler_id <> p_per_in_ler_id

Line 6513: ,ben_acty_base_rt_f abr

6509: ,abr.entr_val_at_enrt_flag
6510: ,prv.rt_strt_dt
6511: from ben_prtt_rt_val prv
6512: ,ben_enrt_rt ecr
6513: ,ben_acty_base_rt_f abr
6514: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6515: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id (+)
6516: and prv.business_group_id = p_business_group_id
6517: and nvl(prv.acty_base_rt_id,-1) = abr.acty_base_rt_id (+)

Line 6554: ,ben_acty_base_rt_f abr

6550: ,abr.input_value_id
6551: ,prv.rt_end_dt --This is needed to determine the future started rate
6552: from ben_prtt_rt_val prv
6553: ,ben_enrt_rt ecr
6554: ,ben_acty_base_rt_f abr
6555: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6556: and prv.rt_end_dt > p_rt_end_dt
6557: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id (+)
6558: and prv.business_group_id = p_business_group_id

Line 6567: from ben_acty_base_rt_f abr,

6563: --
6564: cursor c_abr (p_acty_base_rt_id number) is
6565: select py.processing_type,
6566: abr.rcrrg_cd
6567: from ben_acty_base_rt_f abr,
6568: pay_element_types_f py
6569: where abr.element_type_id = py.element_type_id(+)
6570: and abr.acty_base_rt_id = p_acty_base_rt_id
6571: and p_effective_date between abr.effective_start_date

Line 6972: ben_acty_base_rt_f abr

6968: abr.input_value_id,
6969: abr.element_type_id
6970: FROM ben_prtt_rt_val oldprv,
6971: ben_prtt_rt_val curprv,
6972: ben_acty_base_rt_f abr
6973: WHERE curprv.business_group_id=oldprv.business_group_id
6974: AND curprv.per_in_ler_id = oldprv.ended_per_in_ler_id
6975: AND oldprv.rt_end_dt <> hr_api.g_eot
6976: AND oldprv.acty_base_rt_id = curprv.acty_base_rt_id

Line 7011: ben_acty_base_rt_f abr,

7007: abr.input_value_id,
7008: abr.element_type_id
7009: FROM ben_prtt_rt_val oldprv,
7010: ben_prtt_rt_val curprv,
7011: ben_acty_base_rt_f abr,
7012: ben_acty_base_rt_f abr2 ,
7013: ben_prtt_enrt_rslt_f pen
7014: WHERE curprv.business_group_id=oldprv.business_group_id
7015: AND curprv.per_in_ler_id = oldprv.ended_per_in_ler_id

Line 7012: ben_acty_base_rt_f abr2 ,

7008: abr.element_type_id
7009: FROM ben_prtt_rt_val oldprv,
7010: ben_prtt_rt_val curprv,
7011: ben_acty_base_rt_f abr,
7012: ben_acty_base_rt_f abr2 ,
7013: ben_prtt_enrt_rslt_f pen
7014: WHERE curprv.business_group_id=oldprv.business_group_id
7015: AND curprv.per_in_ler_id = oldprv.ended_per_in_ler_id
7016: AND oldprv.rt_end_dt <> hr_api.g_eot

Line 7352: ,ben_acty_base_rt_f abr

7348: ,abr.element_type_id
7349: ,abr.input_value_id
7350: ,prv.rt_strt_dt
7351: from ben_prtt_rt_val prv
7352: ,ben_acty_base_rt_f abr
7353: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7354: -- bug: 5550679
7355: and prv.per_in_ler_id = p_per_in_ler_id
7356: --