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_ELECTION_INFORMATION dependencies on BEN_PRTT_RT_VAL

Line 57: 29 Oct 98 jcarpent 115.16 Fixed calls to ben_prtt_rt_val_api.

53: Keep old orgnl_enrt_dt if plan stays
54: same
55: 26 Oct 98 jcarpent 115.14 Updated prv to non-datetracked
56: 27 Oct 98 jcarpent 115.15 Changed election_rate_information
57: 29 Oct 98 jcarpent 115.16 Fixed calls to ben_prtt_rt_val_api.
58: Don't compare old elctns made date
59: 29 Oct 98 stee 115.17 Get rt_typ_cd and rt_mlt_cd from
60: enrt_rt.
61: 31 Oct 98 bbulusu 115.18 Added per_in_ler_d to delet_enrolment

Line 71: ben_prtt_rt_val_api. (Column

67: 10 Dec 98 stee 115.22 Fixed bnf warning.
68: 15 Dec 98 jcarpent 115.23 Added call to Create_debit_ledger..
69: 31 Dec 98 lmcdonal 115.24 Better debug messages.
70: 12 Jan 98 maagrawa 115.25 Modified calls to
71: ben_prtt_rt_val_api. (Column
72: acty_base_rt_id added to
73: table ben_prtt_rt_val).
74: 01 Feb 99 jcarpent 115.26 Changed calls to update prv to use
75: ended_per_in_ler_id.

Line 73: table ben_prtt_rt_val).

69: 31 Dec 98 lmcdonal 115.24 Better debug messages.
70: 12 Jan 98 maagrawa 115.25 Modified calls to
71: ben_prtt_rt_val_api. (Column
72: acty_base_rt_id added to
73: table ben_prtt_rt_val).
74: 01 Feb 99 jcarpent 115.26 Changed calls to update prv to use
75: ended_per_in_ler_id.
76: 24 Feb 99 jcarpent 115.27 Changed rate cursor in ele_rt_info
77: to include union to join to choice

Line 711: from ben_prtt_rt_val prv

707: prv.acty_base_rt_id,
708: prv.acty_ref_perd_cd,
709: prv.rt_strt_dt,
710: prv.object_version_number
711: from ben_prtt_rt_val prv
712: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
713: and ((prv.rt_strt_dt > p_rt_strt_dt) or -- old prv in future
714: (p_unrestricted = 'N' and -- old prv on same date
715: prv.per_in_ler_id <> p_per_in_ler_id and

Line 744: from ben_prtt_rt_val prv

740: acty_base_rt_id,
741: rt_strt_dt,
742: rt_end_dt,
743: object_version_number
744: from ben_prtt_rt_val prv
745: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
746: and p_rt_strt_dt between prv.rt_strt_dt
747: and prv.rt_end_dt
748: and prv.acty_base_rt_id = l_future_prv.acty_base_rt_id

Line 849: ben_prtt_rt_val_api.delete_prtt_rt_val

845: --
846: -- Call delete prv if Unrestricted, else update prv
847: --
848: if p_unrestricted = 'Y' then
849: ben_prtt_rt_val_api.delete_prtt_rt_val
850: (p_prtt_rt_val_id => l_future_prv.prtt_rt_val_id
851: ,p_person_id => p_person_id
852: ,p_business_group_id => p_business_group_id
853: ,p_object_version_number => l_future_prv.object_version_number

Line 856: ben_prtt_rt_val_api.update_prtt_rt_val

852: ,p_business_group_id => p_business_group_id
853: ,p_object_version_number => l_future_prv.object_version_number
854: ,p_effective_date => l_future_prv.rt_strt_dt);
855: else
856: ben_prtt_rt_val_api.update_prtt_rt_val
857: (p_validate => false,
858: p_person_id => p_person_id,
859: p_business_group_id => p_business_group_id,
860: p_prtt_rt_val_id => l_future_prv.prtt_rt_val_id,

Line 884: ben_prtt_rt_val_api.update_prtt_rt_val

880: end if;
881:
882: if l_current_prv.rt_end_dt <> hr_api.g_eot then
883: --
884: ben_prtt_rt_val_api.update_prtt_rt_val
885: (p_prtt_rt_val_id => l_current_prv.prtt_rt_val_id
886: ,p_person_id => p_person_id
887: ,p_rt_end_dt => hr_api.g_eot
888: ,p_business_group_id => p_business_group_id

Line 1119: from ben_prtt_rt_val prv

1115: prv.element_entry_value_id,
1116: prv.elctns_made_dt,
1117: prv.rt_ovridn_flag,
1118: prv.rt_ovridn_thru_dt
1119: from ben_prtt_rt_val prv
1120: where prtt_rt_val_id=l_enrt_rt.prtt_rt_val_id and
1121: p_business_group_id=business_group_id;
1122:
1123: cursor c_prtt_rt_val_2 is

Line 1149: from ben_prtt_rt_val prv

1145: prv.element_entry_value_id,
1146: prv.elctns_made_dt,
1147: prv.rt_ovridn_flag,
1148: prv.rt_ovridn_thru_dt
1149: from ben_prtt_rt_val prv
1150: where prv.acty_base_rt_id = l_enrt_rt.acty_base_rt_id
1151: and prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1152: and prv.prtt_rt_val_stat_cd is null
1153: and l_enrt_rt.rt_strt_dt between prv.rt_strt_dt

Line 1190: from ben_prtt_rt_val

1186: )
1187: is
1188: select rt_val,
1189: ann_rt_val
1190: from ben_prtt_rt_val
1191: where acty_base_rt_id = c_acty_base_rt_id
1192: and prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1193: and per_in_ler_id = p_per_in_ler_id
1194: -- bug 6022111

Line 1204: FROM ben_prtt_rt_val

1200: rt_strt_dt = rt_end_dt
1201: AND rt_strt_dt <= p_effective_date
1202: AND rt_strt_dt =
1203: (SELECT MAX (rt_strt_dt)
1204: FROM ben_prtt_rt_val
1205: WHERE acty_base_rt_id = c_acty_base_rt_id
1206: AND prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1207: AND per_in_ler_id = p_per_in_ler_id
1208: AND rt_strt_dt = rt_end_dt

Line 1314: from ben_prtt_rt_val prv

1310: select prv.prtt_rt_val_id,
1311: prv.rt_strt_dt,
1312: prv.acty_ref_perd_cd,
1313: prv.object_version_number
1314: from ben_prtt_rt_val prv
1315: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1316: and prv.acty_base_rt_id = p_acty_base_rt_id
1317: and prv.rt_strt_dt >= p_rt_strt_dt
1318: and prv.per_in_ler_id <> p_per_in_ler_id

Line 1422: ,ben_prtt_rt_val prv

1418: ,abr.element_type_id
1419: ,abr.input_value_id
1420: ,pen.person_id
1421: from ben_prtt_enrt_rslt_f pen
1422: ,ben_prtt_rt_val prv
1423: ,ben_acty_base_rt_f abr
1424: where pen.effective_end_date = hr_api.g_eot
1425: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
1426: and pen.prtt_enrt_rslt_stat_cd is null

Line 1441: where BKUP_TBL_TYP_CD = 'BEN_PRTT_RT_VAL_ADJ'

1437: cursor c_prtt_rt_val_adj (p_per_in_ler_id number,
1438: p_prtt_rt_val_id number) is
1439: select null
1440: from ben_le_clsn_n_rstr
1441: where BKUP_TBL_TYP_CD = 'BEN_PRTT_RT_VAL_ADJ'
1442: AND BKUP_TBL_ID = p_prtt_rt_val_id
1443: AND PER_IN_LER_ID = p_per_in_ler_id;
1444: --
1445: -- end 7206471

Line 3111: ben_prtt_rt_val_api.delete_prtt_rt_val

3107: -- delete future dated rate
3108: --
3109: if not p_calculate_only_mode then
3110: --
3111: ben_prtt_rt_val_api.delete_prtt_rt_val
3112: (p_prtt_rt_val_id => p_prtt_rt_val_id
3113: ,p_enrt_rt_id => p_enrt_rt_id
3114: ,p_person_id => p_person_id
3115: ,p_business_group_id => l_enrt_rt.business_group_id

Line 3218: ben_prtt_rt_val_api.update_prtt_rt_val

3214: --from benraten. This needs to happed only for recurring rates.
3215: --
3216: if not l_non_recurring_rt then
3217: --
3218: ben_prtt_rt_val_api.update_prtt_rt_val
3219: (p_prtt_rt_val_id => p_prtt_rt_val_id
3220: ,p_rt_end_dt => hr_api.g_eot
3221: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id
3222: ,p_input_value_id => l_enrt_rt.input_value_id

Line 3248: ben_prtt_rt_val_api.update_prtt_rt_val

3244: end if;
3245: if not p_calculate_only_mode then
3246: --
3247: --
3248: ben_prtt_rt_val_api.update_prtt_rt_val
3249: (p_prtt_rt_val_id => p_prtt_rt_val_id
3250: ,p_rt_end_dt => l_xrt_end_dt
3251: ,p_ended_per_in_ler_id => p_per_in_ler_id
3252: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id

Line 3280: ben_prtt_rt_val_api.update_prtt_rt_val

3276: hr_utility.set_location('processing type recurring ',1999);
3277: end if;
3278: --
3279:
3280: ben_prtt_rt_val_api.update_prtt_rt_val
3281: (p_prtt_rt_val_id => p_prtt_rt_val_id
3282: ,p_rt_end_dt => l_xrt_end_dt
3283: ,p_ended_per_in_ler_id => p_per_in_ler_id
3284: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id

Line 3361: 'BEN_PRTT_RT_VAL_ADJ',

3357: RT_END_DT,
3358: business_group_id,
3359: object_version_number)
3360: values (
3361: 'BEN_PRTT_RT_VAL_ADJ',
3362: l_pen.prtt_rt_val_id,
3363: p_per_in_ler_id,
3364: l_pen.person_id,
3365: l_pen.rt_end_dt,

Line 3372: ben_prtt_rt_val_api.update_prtt_rt_val

3368: );
3369: end if;
3370: close c_prtt_rt_val_adj;
3371: --
3372: ben_prtt_rt_val_api.update_prtt_rt_val
3373: (P_VALIDATE => FALSE
3374: ,P_PRTT_RT_VAL_ID => l_pen.prtt_rt_val_id
3375: ,P_RT_END_DT => l_epe.rt_strt_dt - 1
3376: ,p_person_id => l_pen.person_id

Line 3392: ben_prtt_rt_val_api.create_prtt_rt_val

3388: end if;
3389: close c_get_prior_per_in_ler;
3390: -- end 7206471
3391:
3392: ben_prtt_rt_val_api.create_prtt_rt_val
3393: (p_prtt_rt_val_id => p_prtt_rt_val_id
3394: ,p_enrt_rt_id => p_enrt_rt_id
3395: ,p_per_in_ler_id => p_per_in_ler_id
3396: ,p_rt_typ_cd => l_enrt_rt.rt_typ_cd

Line 3449: ben_prtt_rt_val_api.update_prtt_rt_val

3445: --from benraten. This needs to happed only for recurring rates.
3446: --
3447: if not l_non_recurring_rt then
3448: --
3449: ben_prtt_rt_val_api.update_prtt_rt_val
3450: (p_prtt_rt_val_id => p_prtt_rt_val_id
3451: ,p_rt_end_dt => hr_api.g_eot
3452: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id
3453: ,p_input_value_id => l_enrt_rt.input_value_id

Line 3531: 'BEN_PRTT_RT_VAL_ADJ',

3527: RT_END_DT,
3528: business_group_id,
3529: object_version_number)
3530: values (
3531: 'BEN_PRTT_RT_VAL_ADJ',
3532: l_pen.prtt_rt_val_id,
3533: p_per_in_ler_id,
3534: l_pen.person_id,
3535: l_pen.rt_end_dt,

Line 3542: ben_prtt_rt_val_api.update_prtt_rt_val

3538: );
3539: end if;
3540: close c_prtt_rt_val_adj;
3541: --
3542: ben_prtt_rt_val_api.update_prtt_rt_val
3543: (P_VALIDATE => FALSE
3544: ,P_PRTT_RT_VAL_ID => l_pen.prtt_rt_val_id
3545: ,P_RT_END_DT => l_epe.rt_strt_dt - 1
3546: ,p_person_id => l_pen.person_id

Line 3562: ben_prtt_rt_val_api.create_prtt_rt_val

3558: end if;
3559: close c_get_prior_per_in_ler;
3560: -- end 7206471
3561: -- if no prtt_rt_val_id passed do insert
3562: ben_prtt_rt_val_api.create_prtt_rt_val
3563: (p_prtt_rt_val_id => p_prtt_rt_val_id
3564: ,p_enrt_rt_id => p_enrt_rt_id
3565: ,p_per_in_ler_id => p_per_in_ler_id
3566: ,p_rt_typ_cd => l_enrt_rt.rt_typ_cd

Line 3636: ben_prtt_rt_val_api.update_prtt_rt_val

3632: ,p_effective_date => p_effective_date);
3633: end if;
3634: --
3635: if l_xrt_end_dt_cd = 'WAENT' then
3636: ben_prtt_rt_val_api.update_prtt_rt_val
3637: (p_prtt_rt_val_id => p_prtt_rt_val_id
3638: ,p_rt_end_dt => l_rt_end_dt
3639: ,p_ended_per_in_ler_id => p_per_in_ler_id
3640: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id

Line 4461: from ben_prtt_rt_val prv

4457: --
4458: cursor c_prtt_rt_val_id is
4459: select prv.prtt_rt_val_id,
4460: prv.acty_base_rt_id
4461: from ben_prtt_rt_val prv
4462: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4463: and prv.prtt_rt_val_stat_cd is null
4464: order by prv.rt_strt_dt asc;
4465: --

Line 4548: from ben_prtt_rt_val prv

4544: l_pen_curr_interim c_pen_curr%rowtype;
4545: --
4546: cursor c_prv(p_prtt_enrt_rslt_id number, p_per_in_ler_id number) is
4547: select prv.*
4548: from ben_prtt_rt_val prv
4549: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4550: and prv.per_in_ler_id = p_per_in_ler_id
4551: and prv.prtt_rt_val_stat_cd is NULL ;
4552: --

Line 5019: ben_prtt_rt_val_api.update_prtt_rt_val

5015: );
5016: --
5017: END IF;
5018: --
5019: ben_prtt_rt_val_api.update_prtt_rt_val
5020: (p_validate => false,
5021: p_person_id => l_global_pil_rec.person_id,
5022: p_business_group_id => p_business_group_id,
5023: p_prtt_rt_val_id => l_rec.prtt_rt_val_id,

Line 5065: ben_prtt_rt_val_api.update_prtt_rt_val

5061: --
5062: hr_utility.set_location('Interim l_rec.prtt_rt_val_id ' || l_rec.prtt_rt_val_id,99);
5063: hr_utility.set_location('l_rec.rt_end_dt ' || l_rec.rt_end_dt,99);
5064: --
5065: ben_prtt_rt_val_api.update_prtt_rt_val
5066: (p_validate => false,
5067: p_person_id => l_global_pil_rec.person_id,
5068: p_business_group_id => p_business_group_id,
5069: p_prtt_rt_val_id => l_rec.prtt_rt_val_id,