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_ELEMENT_ENTRY dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 769: from pay_element_entry_values_f

765: -- commented for bug 5721053
766: cursor c_inpval is
767: select input_value_id,
768: screen_entry_value
769: from pay_element_entry_values_f
770: where element_entry_id = p_element_entry_id
771: and p_effective_date between effective_start_date
772: and effective_end_date;
773: */

Line 779: from pay_element_entry_values_f peev, pay_input_values_f piv

775: cursor c_inpval is
776: select peev.input_value_id,
777: peev.screen_entry_value,
778: piv.UOM
779: from pay_element_entry_values_f peev, pay_input_values_f piv
780: where peev.element_entry_id = p_element_entry_id
781: and p_effective_date between peev.effective_start_date and peev.effective_end_date
782: and piv.input_value_id = peev.input_value_id
783: and p_effective_date between piv.effective_start_date and piv.effective_end_date;

Line 2541: from pay_element_entry_values_f elv

2537: and prv.rt_strt_dt between abr.effective_start_date
2538: and abr.effective_end_date
2539: and prv.element_entry_value_id in
2540: (select elv.element_entry_value_id
2541: from pay_element_entry_values_f elv
2542: where elv.element_entry_id = p_element_entry_id);
2543: l_rt_rec c_chk_rt%rowtype;
2544:
2545: l_effective_start_date date;

Line 2699: pay_element_entry_values_f elv

2695: ele.effective_end_date,
2696: ele.object_version_number,
2697: elv.element_entry_value_id
2698: from pay_element_entries_f ele,
2699: pay_element_entry_values_f elv
2700: where ele.element_link_id = p_element_link_id
2701: and ele.assignment_id = p_assignment_id
2702: and (p_enrt_rslt_id is null or
2703: p_enrt_rslt_id = ele.creator_id)

Line 2722: pay_element_entry_values_f elv

2718: ele.effective_end_date,
2719: ele.object_version_number,
2720: elv.element_entry_value_id
2721: from pay_element_entries_f ele,
2722: pay_element_entry_values_f elv
2723: where p_effective_date between ele.effective_start_date
2724: and ele.effective_end_date
2725: and elv.element_entry_id = ele.element_entry_id
2726: and elv.element_entry_value_id = p_element_entry_value_id

Line 2749: from pay_element_entry_values_f eev,

2745: ee.creator_id,
2746: ee.creator_type,
2747: ee.effective_start_date,
2748: ee.effective_end_date
2749: from pay_element_entry_values_f eev,
2750: pay_element_entries_f ee
2751: where eev.element_entry_id = p_element_entry_id
2752: and eev.input_value_id = p_input_value_id
2753: and p_effective_date between eev.effective_start_date

Line 2810: from pay_element_entry_values_f pev

2806: and prv1.rt_end_dt
2807: and prv1.prtt_rt_val_stat_cd is null
2808: and prv1.element_entry_value_id in
2809: (select pev.element_entry_value_id
2810: from pay_element_entry_values_f pev
2811: where pev.element_entry_id = p_element_entry_id);
2812:
2813: cursor c_future_ee
2814: (p_element_entry_id in number

Line 2827: pay_element_entry_values_f elv,

2823: ele.effective_end_date,
2824: ele.object_version_number,
2825: elv.screen_entry_value
2826: from pay_element_entries_f ele,
2827: pay_element_entry_values_f elv,
2828: pay_element_links_f elk
2829: where ele.creator_id = p_enrt_rslt_id
2830: and ele.creator_type = 'F'
2831: and ele.entry_type = 'E'

Line 3201: from pay_element_entry_values_f pev

3197: and prv.rt_end_dt > c_effective_date
3198: and prv.prtt_rt_val_stat_cd is null
3199: and prv.element_entry_value_id in
3200: (select pev.element_entry_value_id
3201: from pay_element_entry_values_f pev
3202: where pev.element_entry_id = c_element_entry_id);
3203:
3204: cursor c_prv is
3205: select pev.element_entry_value_id

Line 3208: pay_element_entry_values_f pev

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
3212: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 3231: pay_element_entry_values_f pev

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
3235: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id

Line 3259: pay_element_entry_values_f pev,

3255: pee.element_type_id,
3256: pev.input_value_id,
3257: abr.ele_entry_val_cd -- Bug 5575402
3258: from pay_element_entries_f pee,
3259: pay_element_entry_values_f pev,
3260: ben_acty_base_rt_f abr
3261: where pev.element_entry_value_id = l_ee_id
3262: and pee.element_entry_id = pev.element_entry_id
3263: and pev.effective_start_date between pee.effective_start_date

Line 3316: from pay_element_entry_values_f pev

3312:
3313: -- Bug 6716202
3314: /*cursor c_element_entry_values(p_input_value_id number, p_element_entry_value_id number) is
3315: select screen_entry_value,element_entry_value_id
3316: from pay_element_entry_values_f pev
3317: where pev.input_value_id = p_input_value_id
3318: and pev.element_entry_value_id = p_element_entry_value_id
3319: and p_rt_start_date between pev.effective_start_date
3320: and pev.effective_end_date ;

Line 3337: from pay_element_entry_values_f pev

3333:
3334: cursor c_element_entry_v(p_input_value_id number) is
3335: --
3336: select element_entry_id
3337: from pay_element_entry_values_f pev
3338: where pev.input_value_id = p_input_value_id
3339: and l_max_strt_dt between pev.effective_start_date
3340: and pev.effective_end_date ;
3341: --

Line 3343: l_element_entry_id pay_element_entry_values_f.element_entry_id%TYPE;

3339: and l_max_strt_dt between pev.effective_start_date
3340: and pev.effective_end_date ;
3341: --
3342: l_ext_inp_changed boolean;
3343: l_element_entry_id pay_element_entry_values_f.element_entry_id%TYPE;
3344: begin
3345: --
3346: if g_debug then
3347: hr_utility.set_location('IN SAREC p_rt_start_date'||p_rt_start_date,122);

Line 6686: pay_element_entry_values_f pev

6682: from per_all_assignments_f asg,
6683: pay_element_links_f pel,
6684: pay_element_types_f pet,
6685: pay_element_entries_f pee,
6686: pay_element_entry_values_f pev
6687: where asg.person_id = p_person_id
6688: and asg.assignment_id = pee.assignment_id
6689: and pee.effective_start_date between asg.effective_start_date
6690: and asg.effective_end_date

Line 6722: pay_element_entry_values_f pev,

6718: ele.effective_end_date,
6719: pev.screen_entry_value,
6720: ele.object_version_number
6721: from pay_element_entries_f ele,
6722: pay_element_entry_values_f pev,
6723: pay_element_links_f elk
6724: where ele.creator_id = p_prtt_enrt_rslt_id
6725: and ele.creator_type = 'F'
6726: and ele.entry_type = 'E'

Line 7606: from pay_element_entry_values_f

7602: ,p_effective_date IN DATE
7603: )
7604: is
7605: select element_entry_value_id
7606: from pay_element_entry_values_f
7607: where element_entry_id = p_element_entry_id
7608: and input_value_id = p_input_value_id
7609: and p_effective_date between effective_start_date
7610: and effective_end_date;

Line 8094: pay_element_entry_values_f pev

8090: pet.processing_type
8091: from pay_element_types_f pet,
8092: pay_element_links_f pel,
8093: pay_element_entries_f pee,
8094: pay_element_entry_values_f pev
8095: where pev.element_entry_value_id = p_element_entry_value_id
8096: and pee.element_entry_id = pev.element_entry_id
8097: and pev.effective_start_date between pee.effective_start_date
8098: and pee.effective_end_date

Line 8127: pay_element_entry_values_f pev

8123: pev.screen_entry_value
8124: from per_all_assignments_f asg,
8125: pay_element_links_f pel,
8126: pay_element_entries_f pee,
8127: pay_element_entry_values_f pev
8128: where asg.person_id = p_person_id
8129: and pee.assignment_id = asg.assignment_id
8130: and p_effective_date between asg.effective_start_date
8131: and asg.effective_end_date

Line 8187: from pay_element_entry_values_f pev

8183: -- and prv.rt_strt_dt <=c_effective_date
8184: and prv.prtt_rt_val_stat_cd is null
8185: and prv.element_entry_value_id in
8186: (select pev.element_entry_value_id
8187: from pay_element_entry_values_f pev
8188: where pev.element_entry_id = c_element_entry_id);
8189: --
8190: cursor c_chk_abs_ler (c_prtt_rt_val_id number,
8191: c_effective_date date) is

Line 9743: from pay_element_entry_values_f

9739: --
9740: cursor c_element_entry (p_element_entry_id number,
9741: p_input_value_id number) is
9742: select element_entry_value_id
9743: from pay_element_entry_values_f
9744: where ELEMENT_ENTRY_ID = p_element_entry_id
9745: and input_value_id = p_input_value_id;
9746: --
9747: cursor c_ety is

Line 9912: from pay_element_entry_values_f elv,

9908: ele.original_entry_id,
9909: elt.processing_type,
9910: elk.element_type_id,
9911: elk.effective_end_date
9912: from pay_element_entry_values_f elv,
9913: pay_element_entries_f ele,
9914: pay_element_links_f elk,
9915: pay_element_types_f elt
9916: where elv.element_entry_value_id = p_element_entry_value_id