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 5540: from ben_prtt_rt_val prv

5536: ,ecr.acty_base_rt_id
5537: ,abr.element_type_id
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

Line 5577: from ben_prtt_rt_val prv

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

Line 5593: from ben_prtt_rt_val prv,

5589: select prv.prtt_rt_val_id
5590: ,prv.object_version_number
5591: ,ecr.enrt_rt_id
5592: ,ecr.acty_base_rt_id
5593: from ben_prtt_rt_val prv,
5594: ben_enrt_rt ecr
5595: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5596: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id
5597: and prv.rt_end_dt <> hr_api.g_eot

Line 5751: ben_prtt_rt_val_api.delete_prtt_rt_val

5747: update ben_enrt_rt
5748: set prtt_rt_val_id = null
5749: where enrt_rt_id = l_prv.enrt_rt_id;
5750: --
5751: ben_prtt_rt_val_api.delete_prtt_rt_val
5752: (P_VALIDATE => FALSE
5753: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
5754: ,P_OBJECT_VERSION_NUMBER => l_prv.object_version_number
5755: ,P_EFFECTIVE_DATE => l_eff_dt

Line 5775: ben_prtt_rt_val_api.update_prtt_rt_val

5771: For l_prv in c_prv loop
5772: --
5773: hr_utility.set_location(' l_prv PRV'||l_prv.prtt_rt_val_id,10);
5774: --
5775: ben_prtt_rt_val_api.update_prtt_rt_val
5776: (P_VALIDATE => FALSE
5777: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
5778: ,P_RT_END_DT => (l_prv.rt_strt_dt - 1)
5779: ,p_person_id => l_pen.person_id

Line 6167: from ben_prtt_rt_val prv

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

Line 6187: from ben_prtt_rt_val prv

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

Line 6260: from ben_prtt_rt_val prv

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

Line 6284: from ben_prtt_rt_val prv,

6280: select prv.prtt_rt_val_id
6281: ,prv.object_version_number
6282: ,ecr.enrt_rt_id
6283: ,ecr.acty_base_rt_id
6284: from ben_prtt_rt_val prv,
6285: ben_enrt_rt ecr
6286: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6287: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id
6288: and prv.rt_end_dt <> hr_api.g_eot

Line 6301: from ben_prtt_rt_val prv

6297: ,ecr.acty_base_rt_id
6298: ,abr.element_type_id
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

Line 6658: FROM ben_prtt_rt_val oldprv,

6654: oldprv.prtt_rt_val_stat_cd ,
6655: oldprv.object_version_number,
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

Line 6659: ben_prtt_rt_val curprv,

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

Line 6790: from ben_prtt_rt_val prv

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

Line 6807: ben_prtt_rt_val_api.update_prtt_rt_val

6803:
6804: begin
6805: --
6806: For l_prv in c_prv loop
6807: ben_prtt_rt_val_api.update_prtt_rt_val
6808: (P_VALIDATE => FALSE
6809: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
6810: ,P_RT_END_DT => (l_prv.rt_strt_dt - 1)
6811: ,p_person_id => p_person_id

Line 7672: ben_prtt_rt_val_api.update_prtt_rt_val

7668: hr_utility.set_location('l_get_old_prv.prtt_rt_val_id :'||l_get_old_prv.prtt_rt_val_id,3455);
7669: hr_utility.set_location('p_prtt_enrt_rslt_id :'||p_prtt_enrt_rslt_id,3455);
7670: hr_utility.set_location('l_rt_end_dt :'||l_rt_end_dt,3455);
7671:
7672: ben_prtt_rt_val_api.update_prtt_rt_val
7673: (P_VALIDATE => FALSE
7674: ,P_PRTT_RT_VAL_ID => l_get_old_prv.prtt_rt_val_id
7675: ,P_RT_END_DT => l_rt_end_dt
7676: ,p_person_id => l_pen.person_id

Line 7726: ben_prtt_rt_val_api.delete_prtt_rt_val

7722: update ben_enrt_rt
7723: set prtt_rt_val_id = null
7724: where enrt_rt_id = l_prv.enrt_rt_id;
7725: --
7726: ben_prtt_rt_val_api.delete_prtt_rt_val
7727: (P_VALIDATE => FALSE
7728: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
7729: ,P_OBJECT_VERSION_NUMBER => l_prv.object_version_number
7730: ,P_EFFECTIVE_DATE => l_eff_dt

Line 7744: ben_prtt_rt_val_api.update_prtt_rt_val

7740: if (nvl(l_prv.per_in_ler_id, -1) <> nvl(p_per_in_ler_id,-1)) and
7741: l_rt_end_dt < l_prv.rt_strt_dt then
7742: l_prtt_rt_val_stat_cd := 'BCKDT';
7743: end if;
7744: ben_prtt_rt_val_api.update_prtt_rt_val
7745: (P_VALIDATE => FALSE
7746: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
7747: ,P_RT_END_DT => l_rt_end_dt
7748: ,p_person_id => l_pen.person_id

Line 7787: ben_prtt_rt_val_api.update_prtt_rt_val

7783: --
7784: if g_debug then
7785: hr_utility.set_location('Adjusting rate '||l_rt_end_dt,111);
7786: end if;
7787: ben_prtt_rt_val_api.update_prtt_rt_val
7788: (P_VALIDATE => FALSE
7789: ,P_PRTT_RT_VAL_ID => l_prv5.prtt_rt_val_id
7790: ,P_RT_END_DT => l_rt_end_dt
7791: ,p_person_id => l_pen.person_id

Line 7871: ben_prtt_rt_val_api.update_prtt_rt_val

7867: p_parmb => l_pen.pl_name || ' '||l_pen.opt_name,
7868: p_person_id => l_pen.person_id);
7869: end if;
7870: --
7871: ben_prtt_rt_val_api.update_prtt_rt_val
7872: (P_VALIDATE => FALSE
7873: ,P_PRTT_RT_VAL_ID => l_prv4.prtt_rt_val_id
7874: ,P_RT_END_DT => l_rt_end_dt
7875: ,p_person_id => l_pen.person_id

Line 8270: ben_prtt_rt_val_api.delete_prtt_rt_val

8266: update ben_enrt_rt
8267: set prtt_rt_val_id = null
8268: where enrt_rt_id = l_prv.enrt_rt_id;
8269: --
8270: ben_prtt_rt_val_api.delete_prtt_rt_val
8271: (P_VALIDATE => FALSE
8272: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
8273: ,P_OBJECT_VERSION_NUMBER => l_prv.object_version_number
8274: ,P_EFFECTIVE_DATE => l_eff_dt

Line 8284: ben_prtt_rt_val_api.update_prtt_rt_val

8280: if g_debug then
8281: hr_utility.set_location(l_proc,3457);
8282: end if;
8283: l_prv_count := l_prv_count + 1;
8284: ben_prtt_rt_val_api.update_prtt_rt_val
8285: (P_VALIDATE => FALSE
8286: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
8287: ,P_RT_END_DT => l_rt_end_dt
8288: ,p_person_id => l_pen.person_id

Line 8326: ben_prtt_rt_val_api.update_prtt_rt_val

8322: --
8323: if g_debug then
8324: hr_utility.set_location('Adjusting rate '||l_rt_end_dt,111);
8325: end if;
8326: ben_prtt_rt_val_api.update_prtt_rt_val
8327: (P_VALIDATE => FALSE
8328: ,P_PRTT_RT_VAL_ID => l_prv5.prtt_rt_val_id
8329: ,P_RT_END_DT => l_rt_end_dt
8330: ,p_person_id => l_pen.person_id

Line 8404: ben_prtt_rt_val_api.update_prtt_rt_val

8400: p_parmb => l_pen.pl_name || ' '||l_pen.opt_name,
8401: p_person_id => l_pen.person_id);
8402: end if;
8403: --
8404: ben_prtt_rt_val_api.update_prtt_rt_val
8405: (P_VALIDATE => FALSE
8406: ,P_PRTT_RT_VAL_ID => l_prv4.prtt_rt_val_id
8407: ,P_RT_END_DT => l_rt_end_dt
8408: ,p_person_id => l_pen.person_id

Line 8704: ben_prtt_rt_val_api.update_prtt_rt_val

8700: else
8701: l_temp_date:=l_prv.rt_strt_dt - 1;
8702: l_temp_stat_cd:='VOIDD';
8703: end if;
8704: ben_prtt_rt_val_api.update_prtt_rt_val
8705: (P_VALIDATE => FALSE
8706: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
8707: ,P_RT_END_DT => l_temp_date
8708: ,p_person_id => l_pen.person_id

Line 8725: ben_prtt_rt_val_api.update_prtt_rt_val

8721: --
8722: if l_datetrack_mode='CORRECTION' then
8723:
8724:
8725: ben_prtt_rt_val_api.update_prtt_rt_val
8726: (P_VALIDATE => FALSE
8727: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
8728: ,P_RT_END_DT => l_enrt_cvg_end_dt
8729: ,p_person_id => l_pen.person_id

Line 8741: ben_prtt_rt_val_api.delete_prtt_rt_val

8737: );
8738:
8739: ELSE
8740: --Bug#:6641853
8741: ben_prtt_rt_val_api.delete_prtt_rt_val
8742: (P_VALIDATE => FALSE
8743: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
8744: ,P_ENRT_RT_ID => l_prv.enrt_rt_id
8745: ,P_OBJECT_VERSION_NUMBER => l_prv.object_version_number