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 2575: from pay_element_entry_values_f elv

2571: and prv.rt_strt_dt between abr.effective_start_date
2572: and abr.effective_end_date
2573: and prv.element_entry_value_id in
2574: (select elv.element_entry_value_id
2575: from pay_element_entry_values_f elv
2576: where elv.element_entry_id = p_element_entry_id);
2577: l_rt_rec c_chk_rt%rowtype;
2578:
2579: l_effective_start_date date;

Line 2701: FROM pay_element_entry_values_f

2697: ORDER BY ptp.start_date DESC;
2698:
2699: cursor c_per_par_amt_change is
2700: SELECT 'X'
2701: FROM pay_element_entry_values_f
2702: WHERE element_entry_value_id IN
2703: (
2704: SELECT element_entry_value_id
2705: FROM ben_prtt_rt_val

Line 2830: pay_element_entry_values_f elv

2826: ele.effective_end_date,
2827: ele.object_version_number,
2828: elv.element_entry_value_id
2829: from pay_element_entries_f ele,
2830: pay_element_entry_values_f elv
2831: where ele.element_link_id = p_element_link_id
2832: and ele.assignment_id = p_assignment_id
2833: and (p_enrt_rslt_id is null or
2834: p_enrt_rslt_id = ele.creator_id)

Line 2853: pay_element_entry_values_f elv

2849: ele.effective_end_date,
2850: ele.object_version_number,
2851: elv.element_entry_value_id
2852: from pay_element_entries_f ele,
2853: pay_element_entry_values_f elv
2854: where p_effective_date between ele.effective_start_date
2855: and ele.effective_end_date
2856: and elv.element_entry_id = ele.element_entry_id
2857: and elv.element_entry_value_id = p_element_entry_value_id

Line 2880: from pay_element_entry_values_f eev,

2876: ee.creator_id,
2877: ee.creator_type,
2878: ee.effective_start_date,
2879: ee.effective_end_date
2880: from pay_element_entry_values_f eev,
2881: pay_element_entries_f ee
2882: where eev.element_entry_id = p_element_entry_id
2883: and eev.input_value_id = p_input_value_id
2884: and p_effective_date between eev.effective_start_date

Line 2941: from pay_element_entry_values_f pev

2937: and prv1.rt_end_dt
2938: and prv1.prtt_rt_val_stat_cd is null
2939: and prv1.element_entry_value_id in
2940: (select pev.element_entry_value_id
2941: from pay_element_entry_values_f pev
2942: where pev.element_entry_id = p_element_entry_id);
2943:
2944: cursor c_future_ee
2945: (p_element_entry_id in number

Line 2958: pay_element_entry_values_f elv,

2954: ele.effective_end_date,
2955: ele.object_version_number,
2956: elv.screen_entry_value
2957: from pay_element_entries_f ele,
2958: pay_element_entry_values_f elv,
2959: pay_element_links_f elk
2960: where ele.creator_id = p_enrt_rslt_id
2961: and ele.creator_type = 'F'
2962: and ele.entry_type = 'E'

Line 3170: pay_element_entry_values_f ev

3166: ee.*
3167: FROM pay_element_entries_f ee,
3168: pay_element_types_f et,
3169: pay_element_links_f el,
3170: pay_element_entry_values_f ev
3171: WHERE el.element_link_id = ee.element_link_id
3172: AND el.element_link_id = l_elem_link_id
3173: AND el.element_type_id = et.element_type_id
3174: AND ee.assignment_id = l_ass_id

Line 3199: pay_element_entry_values_f ev

3195: l_normal_pp_dt date,
3196: l_ELEMENT_ENTRY_ID number) is
3197: select prv.* from ben_prtt_rt_val prv,
3198: pay_element_entries_f et,
3199: pay_element_entry_values_f ev
3200: where et.element_type_id = l_element_type_id
3201: and ev.input_value_id = l_input_value_id
3202: and et.ELEMENT_ENTRY_ID = l_ELEMENT_ENTRY_ID
3203: and et.ELEMENT_ENTRY_ID = ev.ELEMENT_ENTRY_ID

Line 3407: from pay_element_entry_values_f pev

3403: and prv.rt_end_dt > c_effective_date
3404: and prv.prtt_rt_val_stat_cd is null
3405: and prv.element_entry_value_id in
3406: (select pev.element_entry_value_id
3407: from pay_element_entry_values_f pev
3408: where pev.element_entry_id = c_element_entry_id);
3409: --
3410: -- bug 13709907
3411: --

Line 3434: pay_element_entry_values_f pev

3430: cursor c_prv is
3431: select pev.element_entry_value_id
3432: from ben_prtt_enrt_rslt_f pen,
3433: ben_prtt_rt_val prv,
3434: pay_element_entry_values_f pev
3435: where pen.person_id = p_person_id
3436: and pen.prtt_enrt_rslt_stat_cd is null
3437: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
3438: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 3457: pay_element_entry_values_f pev

3453: cursor c_non_fsa_prv is
3454: select pev.element_entry_value_id
3455: from ben_prtt_enrt_rslt_f pen,
3456: ben_prtt_rt_val prv,
3457: pay_element_entry_values_f pev
3458: where pen.person_id = p_person_id
3459: and pen.prtt_enrt_rslt_stat_cd is null
3460: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3461: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id

Line 3485: pay_element_entry_values_f pev,

3481: pee.element_type_id,
3482: pev.input_value_id,
3483: abr.ele_entry_val_cd -- Bug 5575402
3484: from pay_element_entries_f pee,
3485: pay_element_entry_values_f pev,
3486: ben_acty_base_rt_f abr
3487: where pev.element_entry_value_id = l_ee_id
3488: and pee.element_entry_id = pev.element_entry_id
3489: and pev.effective_start_date between pee.effective_start_date

Line 3542: from pay_element_entry_values_f pev

3538:
3539: -- Bug 6716202
3540: /*cursor c_element_entry_values(p_input_value_id number, p_element_entry_value_id number) is
3541: select screen_entry_value,element_entry_value_id
3542: from pay_element_entry_values_f pev
3543: where pev.input_value_id = p_input_value_id
3544: and pev.element_entry_value_id = p_element_entry_value_id
3545: and p_rt_start_date between pev.effective_start_date
3546: and pev.effective_end_date ;

Line 3563: from pay_element_entry_values_f pev

3559:
3560: cursor c_element_entry_v(p_input_value_id number) is
3561: --
3562: select element_entry_id
3563: from pay_element_entry_values_f pev
3564: where pev.input_value_id = p_input_value_id
3565: and l_max_strt_dt between pev.effective_start_date
3566: and pev.effective_end_date ;
3567: --

Line 3569: l_element_entry_id pay_element_entry_values_f.element_entry_id%TYPE;

3565: and l_max_strt_dt between pev.effective_start_date
3566: and pev.effective_end_date ;
3567: --
3568: l_ext_inp_changed boolean;
3569: l_element_entry_id pay_element_entry_values_f.element_entry_id%TYPE;
3570:
3571: --Start Bug 12417510: Added below variables
3572: l_prev_yp_start_date date;
3573: l_no_of_prev_py_periods number;

Line 7247: pay_element_entry_values_f pev

7243: from per_all_assignments_f asg,
7244: pay_element_links_f pel,
7245: pay_element_types_f pet,
7246: pay_element_entries_f pee,
7247: pay_element_entry_values_f pev
7248: where asg.person_id = p_person_id
7249: and asg.assignment_id = pee.assignment_id
7250: and pee.effective_start_date between asg.effective_start_date
7251: and asg.effective_end_date

Line 7283: pay_element_entry_values_f pev,

7279: ele.effective_end_date,
7280: pev.screen_entry_value,
7281: ele.object_version_number
7282: from pay_element_entries_f ele,
7283: pay_element_entry_values_f pev,
7284: pay_element_links_f elk
7285: where ele.creator_id = p_prtt_enrt_rslt_id
7286: and ele.creator_type = 'F'
7287: and ele.entry_type = 'E'

Line 8167: from pay_element_entry_values_f

8163: ,p_effective_date IN DATE
8164: )
8165: is
8166: select element_entry_value_id
8167: from pay_element_entry_values_f
8168: where element_entry_id = p_element_entry_id
8169: and input_value_id = p_input_value_id
8170: and p_effective_date between effective_start_date
8171: and effective_end_date;

Line 8655: pay_element_entry_values_f pev

8651: pet.processing_type
8652: from pay_element_types_f pet,
8653: pay_element_links_f pel,
8654: pay_element_entries_f pee,
8655: pay_element_entry_values_f pev
8656: where pev.element_entry_value_id = p_element_entry_value_id
8657: and pee.element_entry_id = pev.element_entry_id
8658: and pev.effective_start_date between pee.effective_start_date
8659: and pee.effective_end_date

Line 8688: pay_element_entry_values_f pev

8684: pev.screen_entry_value
8685: from per_all_assignments_f asg,
8686: pay_element_links_f pel,
8687: pay_element_entries_f pee,
8688: pay_element_entry_values_f pev
8689: where asg.person_id = p_person_id
8690: and pee.assignment_id = asg.assignment_id
8691: and p_effective_date between asg.effective_start_date
8692: and asg.effective_end_date

Line 8750: from pay_element_entry_values_f pev

8746: -- and prv.rt_strt_dt <=c_effective_date
8747: and prv.prtt_rt_val_stat_cd is null
8748: and prv.element_entry_value_id in
8749: (select pev.element_entry_value_id
8750: from pay_element_entry_values_f pev
8751: where pev.element_entry_id = c_element_entry_id);
8752: --
8753:
8754: */

Line 8885: FROM pay_element_entry_values_f pev,

8881: l_new_pp_days number;
8882:
8883: cursor c_get_prev_ele(p_rt_end_date date) is
8884: SELECT pev.*
8885: FROM pay_element_entry_values_f pev,
8886: ben_prtt_rt_val prv
8887: WHERE prv.prtt_rt_val_id = p_prtt_rt_val_id
8888: AND prv.rt_end_dt = p_rt_end_date
8889: AND prv.element_entry_value_id = pev.element_entry_value_id

Line 10482: from pay_element_entry_values_f

10478: --
10479: cursor c_element_entry (p_element_entry_id number,
10480: p_input_value_id number) is
10481: select element_entry_value_id
10482: from pay_element_entry_values_f
10483: where ELEMENT_ENTRY_ID = p_element_entry_id
10484: and input_value_id = p_input_value_id;
10485: --
10486: cursor c_ety is

Line 10651: from pay_element_entry_values_f elv,

10647: ele.original_entry_id,
10648: elt.processing_type,
10649: elk.element_type_id,
10650: elk.effective_end_date
10651: from pay_element_entry_values_f elv,
10652: pay_element_entries_f ele,
10653: pay_element_links_f elk,
10654: pay_element_types_f elt
10655: where elv.element_entry_value_id = p_element_entry_value_id