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_ENTRIES_F

Line 267: pay_element_entries_f pee

263: --
264: cursor nonrecurring_entries (adjust_ee_source in varchar2) is
265: select 'Y'
266: from pay_run_results prr,
267: pay_element_entries_f pee
268: where pee.element_entry_id = p_element_entry_id
269: and p_effective_date between pee.effective_start_date
270: and pee.effective_end_date
271: and prr.source_id = decode(pee.entry_type,

Line 956: p_base_table_name => 'PAY_ELEMENT_ENTRIES_F',

952: begin
953:
954: dt_api.find_dt_upd_modes
955: (p_effective_date => p_effective_date,
956: p_base_table_name => 'PAY_ELEMENT_ENTRIES_F',
957: p_base_key_column => 'element_entry_id',
958: p_base_key_value => p_base_key_value,
959: p_correction => l_correction,
960: p_update => l_update,

Line 1002: pay_element_entries_f ee,

998: from pay_assignment_actions aa,
999: pay_payroll_actions pa,
1000: pay_quickpay_inclusions qi,
1001: pay_element_links_f el,
1002: pay_element_entries_f ee,
1003: per_time_periods tp
1004: where aa.assignment_id = p_assignment_id
1005: and pa.payroll_action_id = aa.payroll_action_id
1006: and pa.action_type = 'Q'

Line 2504: from pay_element_entries_f ele,

2500: ele.effective_end_date,
2501: ele.object_version_number,
2502: ele.creator_id,
2503: ele.creator_type
2504: from pay_element_entries_f ele,
2505: pay_element_links_f elk,
2506: pay_element_types_f elt
2507: where ele.effective_start_date = (select min(ele2.effective_start_date)
2508: from pay_element_entries_f ele2

Line 2508: from pay_element_entries_f ele2

2504: from pay_element_entries_f ele,
2505: pay_element_links_f elk,
2506: pay_element_types_f elt
2507: where ele.effective_start_date = (select min(ele2.effective_start_date)
2508: from pay_element_entries_f ele2
2509: where ele2.element_entry_id
2510: = ele.element_entry_id)
2511: and ele.effective_start_date > p_effective_date
2512: and ele.assignment_id = p_assignment_id

Line 2698: from pay_element_entries_f ele,

2694: ele.effective_start_date,
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

Line 2721: from pay_element_entries_f ele,

2717: ele.effective_start_date,
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

Line 2733: from pay_element_entries_f ele

2729: --
2730: -- 5229941: Fetch MAX end_date of the Element Entry.
2731: cursor get_max_ee_end_dt(p_element_entry_id in number) is
2732: select max(ele.effective_end_date) max_ee_end_date
2733: from pay_element_entries_f ele
2734: where ele.element_entry_id = p_element_entry_id;
2735: --
2736: --
2737: cursor get_current_value

Line 2750: pay_element_entries_f ee

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
2754: and eev.effective_end_date

Line 2826: from pay_element_entries_f ele,

2822: ele.effective_start_date,
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'

Line 3258: from pay_element_entries_f pee,

3254: pee.assignment_id,
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

Line 6685: pay_element_entries_f pee,

6681: pev.input_value_id
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

Line 6721: from pay_element_entries_f ele,

6717: ele.effective_start_date,
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'

Line 6748: from pay_element_entries_f ele,

6744: select ele.element_entry_id,
6745: ele.effective_start_date,
6746: ele.effective_end_date,
6747: ele.object_version_number
6748: from pay_element_entries_f ele,
6749: pay_element_links_f elk
6750: where p_effective_date between ele.effective_start_date
6751: and ele.effective_end_date
6752: and ele.assignment_id = p_assignment_id

Line 6766: from pay_element_entries_f

6762: --
6763: cursor c_min_max_dt(p_element_entry_id number) is
6764: select min(effective_start_date),
6765: max(effective_end_date)
6766: from pay_element_entries_f
6767: where element_entry_id = p_element_entry_id;
6768: --
6769: cursor c_chk_abs_ler (c_per_in_ler_id number,
6770: c_effective_date date) is

Line 7616: FROM pay_element_entries_f

7612: -- bug 5768050
7613: CURSOR c_ee_ovn (v_element_entry_id IN NUMBER)
7614: IS
7615: SELECT object_version_number
7616: FROM pay_element_entries_f
7617: WHERE element_entry_id = v_element_entry_id
7618: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
7619:
7620: l_ovn pay_element_entries_f.object_version_number%TYPE;

Line 7620: l_ovn pay_element_entries_f.object_version_number%TYPE;

7616: FROM pay_element_entries_f
7617: WHERE element_entry_id = v_element_entry_id
7618: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
7619:
7620: l_ovn pay_element_entries_f.object_version_number%TYPE;
7621:
7622: -- end bug 5768050
7623:
7624: l_per_month_amt number;

Line 8093: pay_element_entries_f pee,

8089: pet.element_name,
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

Line 8126: pay_element_entries_f pee,

8122: pee.element_link_id,
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

Line 8156: from pay_element_entries_f pee,

8152: select pee.element_entry_id,
8153: pee.effective_start_date,
8154: pee.effective_end_date,
8155: pee.object_version_number
8156: from pay_element_entries_f pee,
8157: pay_element_links_f pel
8158: where pee.assignment_id = p_assignment_id
8159: and pee.creator_id = p_enrt_rslt_id
8160: and pee.creator_type = 'F'

Line 8169: from pay_element_entries_f pee2

8165: and pel.effective_end_date
8166: and pel.element_type_id = p_element_type_id
8167: and pee.effective_start_date
8168: = (select min(pee2.effective_start_date)
8169: from pay_element_entries_f pee2
8170: where pee2.element_entry_id = pee.element_entry_id);
8171: l_future_ee_rec get_future_element_entry%rowtype;
8172: --
8173: --Added prv.rt_strt_dt <=c_effective_date condition

Line 8210: from pay_element_entries_f

8206: --
8207: cursor c_min_max_dt(p_element_entry_id number) is
8208: select min(effective_start_date),
8209: max(effective_end_date)
8210: from pay_element_entries_f
8211: where element_entry_id = p_element_entry_id;
8212: --
8213: cursor c_element_ovn(p_element_entry_id number,
8214: p_effective_date date) is

Line 8216: from pay_element_entries_f pee

8212: --
8213: cursor c_element_ovn(p_element_entry_id number,
8214: p_effective_date date) is
8215: select object_version_number
8216: from pay_element_entries_f pee
8217: where pee.element_entry_id = p_element_entry_id
8218: and p_effective_date between pee.effective_start_date
8219: and pee.effective_end_date;
8220:

Line 9913: pay_element_entries_f ele,

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
9917: and elv.element_entry_id = ele.element_entry_id

Line 9931: from pay_element_entries_f

9927: l_ele_rec c_ele_info%rowtype;
9928: --
9929: cursor c_element_entry (p_element_entry_id number) is
9930: select object_version_number
9931: from pay_element_entries_f
9932: where element_entry_id = p_element_entry_id;
9933: --
9934: l_object_version_number number;
9935: l_element_entry_id number;