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_PRTT_RT_VAL

Line 5829: from ben_prtt_rt_val prv

5825: ,ecr.acty_base_rt_id
5826: ,abr.element_type_id
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

Line 5866: from ben_prtt_rt_val prv

5862: ,prv.object_version_number
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

Line 5882: from ben_prtt_rt_val prv,

5878: select prv.prtt_rt_val_id
5879: ,prv.object_version_number
5880: ,ecr.enrt_rt_id
5881: ,ecr.acty_base_rt_id
5882: from ben_prtt_rt_val prv,
5883: ben_enrt_rt ecr
5884: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5885: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id
5886: and prv.rt_end_dt <> hr_api.g_eot

Line 6040: ben_prtt_rt_val_api.delete_prtt_rt_val

6036: update ben_enrt_rt
6037: set prtt_rt_val_id = null
6038: where enrt_rt_id = l_prv.enrt_rt_id;
6039: --
6040: ben_prtt_rt_val_api.delete_prtt_rt_val
6041: (P_VALIDATE => FALSE
6042: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
6043: ,P_OBJECT_VERSION_NUMBER => l_prv.object_version_number
6044: ,P_EFFECTIVE_DATE => l_eff_dt

Line 6064: ben_prtt_rt_val_api.update_prtt_rt_val

6060: For l_prv in c_prv loop
6061: --
6062: hr_utility.set_location(' l_prv PRV'||l_prv.prtt_rt_val_id,10);
6063: --
6064: ben_prtt_rt_val_api.update_prtt_rt_val
6065: (P_VALIDATE => FALSE
6066: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
6067: ,P_RT_END_DT => (l_prv.rt_strt_dt - 1)
6068: ,p_person_id => l_pen.person_id

Line 6456: from ben_prtt_rt_val prv

6452: ,prv.object_version_number
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

Line 6476: from ben_prtt_rt_val prv

6472: ,prv.object_version_number
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

Line 6511: from ben_prtt_rt_val prv

6507: ,abr.element_type_id
6508: ,abr.input_value_id
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 (+)

Line 6535: from ben_prtt_rt_val prv,

6531: select prv.prtt_rt_val_id
6532: ,prv.object_version_number
6533: ,ecr.enrt_rt_id
6534: ,ecr.acty_base_rt_id
6535: from ben_prtt_rt_val prv,
6536: ben_enrt_rt ecr
6537: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6538: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id
6539: and prv.rt_end_dt <> hr_api.g_eot

Line 6552: from ben_prtt_rt_val prv

6548: ,ecr.acty_base_rt_id
6549: ,abr.element_type_id
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

Line 6970: FROM ben_prtt_rt_val oldprv,

6966: oldprv.prtt_rt_val_stat_cd ,
6967: oldprv.object_version_number,
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

Line 6971: ben_prtt_rt_val curprv,

6967: oldprv.object_version_number,
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

Line 7009: FROM ben_prtt_rt_val oldprv,

7005: oldprv.prtt_rt_val_stat_cd ,
7006: oldprv.object_version_number,
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

Line 7010: ben_prtt_rt_val curprv,

7006: oldprv.object_version_number,
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

Line 7351: from ben_prtt_rt_val prv

7347: ,prv.acty_base_rt_id
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

Line 7444: ben_prtt_rt_val_api.update_prtt_rt_val

7440: end if;
7441: --
7442: -- end 12583091
7443: --
7444: ben_prtt_rt_val_api.update_prtt_rt_val
7445: (P_VALIDATE => FALSE
7446: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
7447: ,P_RT_END_DT => (l_prv.rt_strt_dt - 1)
7448: ,p_person_id => p_person_id

Line 8568: ben_prtt_rt_val_api.update_prtt_rt_val

8564: l_old_prv_found := false;
8565: for l_old_prv in c_get_old_prv loop
8566: hr_utility.set_location('l_old_prv.prtt_rt_val_id :'|| l_old_prv.prtt_rt_val_id,3455);
8567: l_old_prv_found := true;
8568: ben_prtt_rt_val_api.update_prtt_rt_val
8569: (P_VALIDATE => FALSE
8570: ,P_PRTT_RT_VAL_ID => l_old_prv.prtt_rt_val_id --l_get_old_prv.prtt_rt_val_id
8571: ,P_RT_END_DT => l_rt_end_dt
8572: ,p_person_id => l_pen.person_id

Line 8625: ben_prtt_rt_val_api.update_prtt_rt_val

8621: hr_utility.set_location('l_get_old_prv1.prtt_rt_val_id :'||l_get_old_prv1.prtt_rt_val_id,3455);
8622: hr_utility.set_location('l_get_old_prv1.ovn :'||l_get_old_prv1.object_version_number,3455.1);
8623: hr_utility.set_location('l_rt_end_dt1 :'||l_rt_end_dt1,3455.1);
8624:
8625: ben_prtt_rt_val_api.update_prtt_rt_val
8626: (P_VALIDATE => FALSE
8627: ,P_PRTT_RT_VAL_ID => l_get_old_prv1.prtt_rt_val_id
8628: ,P_RT_END_DT => l_rt_end_dt1
8629: ,p_person_id => l_pen.person_id

Line 8684: ben_prtt_rt_val_api.delete_prtt_rt_val

8680: update ben_enrt_rt
8681: set prtt_rt_val_id = null
8682: where enrt_rt_id = l_prv.enrt_rt_id;
8683: --
8684: ben_prtt_rt_val_api.delete_prtt_rt_val
8685: (P_VALIDATE => FALSE
8686: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
8687: ,P_OBJECT_VERSION_NUMBER => l_prv.object_version_number
8688: ,P_EFFECTIVE_DATE => l_eff_dt

Line 8702: ben_prtt_rt_val_api.update_prtt_rt_val

8698: if (nvl(l_prv.per_in_ler_id, -1) <> nvl(p_per_in_ler_id,-1)) and
8699: l_rt_end_dt < l_prv.rt_strt_dt then
8700: l_prtt_rt_val_stat_cd := 'BCKDT';
8701: end if;
8702: ben_prtt_rt_val_api.update_prtt_rt_val
8703: (P_VALIDATE => FALSE
8704: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
8705: ,P_RT_END_DT => l_rt_end_dt
8706: ,p_person_id => l_pen.person_id

Line 8736: ben_prtt_rt_val_api.update_prtt_rt_val

8732: --
8733: if g_debug then
8734: hr_utility.set_location('Adjusting rate '||l_rt_end_dt,111);
8735: end if;
8736: ben_prtt_rt_val_api.update_prtt_rt_val
8737: (P_VALIDATE => FALSE
8738: ,P_PRTT_RT_VAL_ID => l_prv5.prtt_rt_val_id
8739: ,P_RT_END_DT => l_rt_end_dt
8740: ,p_person_id => l_pen.person_id

Line 8785: ben_prtt_rt_val_api.update_prtt_rt_val

8781: p_parmb => l_pen.pl_name || ' '||l_pen.opt_name,
8782: p_person_id => l_pen.person_id);
8783: end if;
8784: --
8785: ben_prtt_rt_val_api.update_prtt_rt_val
8786: (P_VALIDATE => FALSE
8787: ,P_PRTT_RT_VAL_ID => l_prv4.prtt_rt_val_id
8788: ,P_RT_END_DT => l_rt_end_dt
8789: ,p_person_id => l_pen.person_id

Line 9501: ben_prtt_rt_val_api.delete_prtt_rt_val

9497: update ben_enrt_rt
9498: set prtt_rt_val_id = null
9499: where enrt_rt_id = l_prv.enrt_rt_id;
9500: --
9501: ben_prtt_rt_val_api.delete_prtt_rt_val
9502: (P_VALIDATE => FALSE
9503: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
9504: ,P_OBJECT_VERSION_NUMBER => l_prv.object_version_number
9505: ,P_EFFECTIVE_DATE => l_eff_dt

Line 9515: ben_prtt_rt_val_api.update_prtt_rt_val

9511: if g_debug then
9512: hr_utility.set_location(l_proc,3457);
9513: end if;
9514: l_prv_count := l_prv_count + 1;
9515: ben_prtt_rt_val_api.update_prtt_rt_val
9516: (P_VALIDATE => FALSE
9517: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
9518: ,P_RT_END_DT => l_rt_end_dt
9519: ,p_person_id => l_pen.person_id

Line 9549: ben_prtt_rt_val_api.update_prtt_rt_val

9545: --
9546: if g_debug then
9547: hr_utility.set_location('Adjusting rate '||l_rt_end_dt,111);
9548: end if;
9549: ben_prtt_rt_val_api.update_prtt_rt_val
9550: (P_VALIDATE => FALSE
9551: ,P_PRTT_RT_VAL_ID => l_prv5.prtt_rt_val_id
9552: ,P_RT_END_DT => l_rt_end_dt
9553: ,p_person_id => l_pen.person_id

Line 9592: ben_prtt_rt_val_api.update_prtt_rt_val

9588: p_parmb => l_pen.pl_name || ' '||l_pen.opt_name,
9589: p_person_id => l_pen.person_id);
9590: end if;
9591: --
9592: ben_prtt_rt_val_api.update_prtt_rt_val
9593: (P_VALIDATE => FALSE
9594: ,P_PRTT_RT_VAL_ID => l_prv4.prtt_rt_val_id
9595: ,P_RT_END_DT => l_rt_end_dt
9596: ,p_person_id => l_pen.person_id

Line 10145: ben_prtt_rt_val_api.update_prtt_rt_val

10141: else
10142: l_temp_date:=l_prv.rt_strt_dt - 1;
10143: l_temp_stat_cd:='VOIDD';
10144: end if;
10145: ben_prtt_rt_val_api.update_prtt_rt_val
10146: (P_VALIDATE => FALSE
10147: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
10148: ,P_RT_END_DT => l_temp_date
10149: ,p_person_id => l_pen.person_id

Line 10166: ben_prtt_rt_val_api.update_prtt_rt_val

10162: --
10163: if l_datetrack_mode='CORRECTION' then
10164:
10165:
10166: ben_prtt_rt_val_api.update_prtt_rt_val
10167: (P_VALIDATE => FALSE
10168: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
10169: ,P_RT_END_DT => l_enrt_cvg_end_dt
10170: ,p_person_id => l_pen.person_id

Line 10233: ben_prtt_rt_val_api.delete_prtt_rt_val

10229: end if;
10230: --
10231: -- end 12583091
10232: --
10233: ben_prtt_rt_val_api.delete_prtt_rt_val
10234: (P_VALIDATE => FALSE
10235: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
10236: ,P_ENRT_RT_ID => l_prv.enrt_rt_id
10237: ,P_OBJECT_VERSION_NUMBER => l_prv.object_version_number