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.

[Home] [Help]

APPS.BEN_ELEMENT_ENTRY dependencies on BEN_PRTT_RT_VAL

Line 136: from ben_prtt_rt_val prv

132: prv.per_in_ler_id,
133: prv.element_entry_value_id,
134: prv.prtt_reimbmt_rqst_id,
135: prv.object_version_number
136: from ben_prtt_rt_val prv
137: where prtt_rt_val_id = c_prtt_rt_val_id;
138: --
139: l_prv_rec c_get_prtt_rt_val%ROWTYPE;
140: --

Line 2530: ben_prtt_rt_val prv,

2526: p_element_entry_id number) is
2527: select abr.name rt_name,
2528: prv.rt_strt_dt
2529: from ben_prtt_enrt_rslt_f pen,
2530: ben_prtt_rt_val prv,
2531: ben_acty_base_rt_f abr
2532: where pen.person_id = p_person_id
2533: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
2534: and prv.prtt_rt_val_stat_cd is null

Line 2774: ben_prtt_rt_val prv

2770: p_rt_strt_dt date) is
2771: select abr.name
2772: from ben_prtt_enrt_rslt_f pen,
2773: ben_acty_base_rt_f abr,
2774: ben_prtt_rt_val prv
2775: where prv.acty_base_rt_id <> p_acty_base_rt_id
2776: and prv.element_entry_value_id = p_element_entry_value_id
2777: and prv.prtt_rt_val_stat_cd is null
2778: and abr.acty_base_rt_id = prv.acty_base_rt_id

Line 2793: ben_prtt_rt_val prv1

2789: select abr1.name
2790: from ben_prtt_enrt_rslt_f pen1,
2791: ben_prtt_enrt_rslt_f pen2,
2792: ben_acty_base_rt_f abr1,
2793: ben_prtt_rt_val prv1
2794: where pen2.prtt_enrt_rslt_id = p_enrt_rslt_id
2795: and pen1.prtt_enrt_rslt_id <> pen2.prtt_enrt_rslt_id
2796: and pen1.person_id = pen2.person_id
2797: and pen1.prtt_enrt_rslt_stat_cd is null

Line 2983: from ben_prtt_rt_val prv,

2979: , p_rt_start_date in date
2980: )
2981: is
2982: select ler.name name, ler.ler_id ler_id
2983: from ben_prtt_rt_val prv,
2984: ben_per_in_ler pil,
2985: ben_ler_f ler
2986: where prv.per_in_ler_id = pil.per_in_ler_id
2987: and pil.ler_id = ler.ler_id

Line 3000: ben_prtt_rt_val prv,

2996: cursor c_enrt_rt
2997: is
2998: SELECT ecr.enrt_rt_id
2999: FROM ben_enrt_rt ecr,
3000: ben_prtt_rt_val prv,
3001: ben_acty_base_rt_f abr
3002: WHERE prv.prtt_rt_val_id = ecr.prtt_rt_val_id
3003: AND prv.prtt_rt_val_stat_cd is NULL
3004: AND abr.acty_base_rt_id = prv.acty_base_rt_id

Line 3172: ben_prtt_rt_val prv

3168: cursor c_max_prv is
3169: select
3170: max(prv.rt_strt_dt) max_strt_dt
3171: from ben_prtt_enrt_rslt_f pen,
3172: ben_prtt_rt_val prv
3173: where pen.person_id = p_person_id
3174: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3175: and pen.prtt_enrt_rslt_stat_cd is null
3176: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id

Line 3194: from ben_prtt_rt_val prv

3190:
3191: cursor c_dup_prv_chk (c_element_entry_id number,
3192: c_effective_date date) is
3193: select count(prv.prtt_enrt_rslt_id)
3194: from ben_prtt_rt_val prv
3195: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3196: and prv.acty_base_rt_id <> p_acty_base_rt_id
3197: and prv.rt_end_dt > c_effective_date
3198: and prv.prtt_rt_val_stat_cd is null

Line 3207: ben_prtt_rt_val prv,

3203:
3204: cursor c_prv is
3205: select pev.element_entry_value_id
3206: from ben_prtt_enrt_rslt_f pen,
3207: ben_prtt_rt_val prv,
3208: pay_element_entry_values_f pev
3209: where pen.person_id = p_person_id
3210: and pen.prtt_enrt_rslt_stat_cd is null
3211: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id

Line 3230: ben_prtt_rt_val prv,

3226: --
3227: cursor c_non_fsa_prv is
3228: select pev.element_entry_value_id
3229: from ben_prtt_enrt_rslt_f pen,
3230: ben_prtt_rt_val prv,
3231: pay_element_entry_values_f pev
3232: where pen.person_id = p_person_id
3233: and pen.prtt_enrt_rslt_stat_cd is null
3234: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 3325: from ben_prtt_rt_val prv

3321: l_element_entry_values c_element_entry_values%ROWTYPE;
3322:
3323: cursor c_get_input_value(p_prtt_rt_val_id number, p_rt_start_date date) is
3324: select rt_val
3325: from ben_prtt_rt_val prv
3326: where prv.prtt_rt_val_id = p_prtt_rt_val_id
3327: and p_rt_start_date between prv.rt_strt_dt
3328: and prv.rt_end_dt;
3329:

Line 3504: ben_prtt_rt_val_api.update_prtt_rt_val

3500: --
3501: p_prv_object_version_number := nvl(p_prv_object_version_number,
3502: l_prv_rec.object_version_number);
3503:
3504: ben_prtt_rt_val_api.update_prtt_rt_val
3505: (p_validate => p_validate
3506: ,p_person_id => p_person_id
3507: ,p_prtt_rt_val_id => p_prtt_rt_val_id
3508: ,p_business_group_id => p_business_group_id

Line 3704: ben_prtt_rt_val_api.update_prtt_rt_val

3700: --
3701: p_prv_object_version_number := nvl(p_prv_object_version_number,
3702: l_prv_rec.object_version_number);
3703:
3704: ben_prtt_rt_val_api.update_prtt_rt_val
3705: (p_validate => p_validate
3706: ,p_person_id => p_person_id
3707: ,p_prtt_rt_val_id => p_prtt_rt_val_id
3708: ,p_business_group_id => p_business_group_id

Line 6580: ben_prtt_rt_val_api.update_prtt_rt_val

6576: --
6577: if p_prtt_rt_val_id is not null then
6578: p_prv_object_version_number := nvl(p_prv_object_version_number,
6579: l_prv_rec.object_version_number);
6580: ben_prtt_rt_val_api.update_prtt_rt_val
6581: (p_validate => p_validate
6582: ,p_business_group_id => l_prv_rec.business_group_id
6583: ,p_prtt_rt_val_id => l_prv_rec.prtt_rt_val_id
6584: ,p_element_entry_value_id => l_entry_value_id

Line 6787: ,ben_prtt_rt_val prv

6783: --
6784: Cursor c_adjust_exists is
6785: select leclr.*
6786: from ben_le_clsn_n_rstr leclr
6787: ,ben_prtt_rt_val prv
6788: ,ben_acty_base_rt_f abr
6789: where bkup_tbl_typ_cd = 'BEN_PRTT_RT_VAL_ADJ'
6790: and bkup_tbl_id = prv.prtt_rt_val_id
6791: and prv.acty_base_rt_id = abr.acty_base_rt_id

Line 6789: where bkup_tbl_typ_cd = 'BEN_PRTT_RT_VAL_ADJ'

6785: select leclr.*
6786: from ben_le_clsn_n_rstr leclr
6787: ,ben_prtt_rt_val prv
6788: ,ben_acty_base_rt_f abr
6789: where bkup_tbl_typ_cd = 'BEN_PRTT_RT_VAL_ADJ'
6790: and bkup_tbl_id = prv.prtt_rt_val_id
6791: and prv.acty_base_rt_id = abr.acty_base_rt_id
6792: and abr.element_type_id = p_element_type_id;
6793: --

Line 7935: ben_prtt_rt_val_api.update_prtt_rt_val

7931: l_prv_object_version_number := l_prv_rec.object_version_number;
7932:
7933: -- update the prv with the new element_entry_id
7934: --
7935: ben_prtt_rt_val_api.update_prtt_rt_val
7936: (p_validate => p_validate
7937: ,p_person_id => p_person_id
7938: ,p_prtt_rt_val_id => l_prv_rec.prtt_rt_val_id
7939: ,p_business_group_id => l_prv_rec.business_group_id

Line 8179: from ben_prtt_rt_val prv

8175: --already processed.
8176: cursor c_dup_prv(c_element_entry_id number,
8177: c_effective_date date) is
8178: select 'x'
8179: from ben_prtt_rt_val prv
8180: where prv.prtt_enrt_rslt_id = p_enrt_rslt_id
8181: and prv.acty_base_rt_id <> p_acty_base_rt_id
8182: and prv.rt_end_dt > c_effective_date
8183: -- and prv.rt_strt_dt <=c_effective_date

Line 8196: from ben_prtt_rt_val prt,

8192: select pil.lf_evt_ocrd_dt,
8193: pil.trgr_table_pk_id,
8194: pil.per_in_ler_id,
8195: ler.ler_id
8196: from ben_prtt_rt_val prt,
8197: ben_per_in_ler pil,
8198: ben_ler_f ler
8199: where prt.prtt_rt_val_id = c_prtt_rt_val_id
8200: -- ended_per_in_ler_id may be null in case of back out

Line 8233: from ben_prtt_rt_val prv,

8229: , p_rt_end_date in date
8230: )
8231: is
8232: select ler.name name, ler.ler_id ler_id
8233: from ben_prtt_rt_val prv,
8234: ben_per_in_ler pil,
8235: ben_ler_f ler
8236: where prv.per_in_ler_id = pil.per_in_ler_id
8237: and pil.ler_id = ler.ler_id