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.HR_JP_DATA_MIGRATION_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 250: select /+ INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) /

246: CURSOR csr_element_entry_id(
247: p_element_link_id IN NUMBER,
248: p_input_value_id IN NUMBER)
249: IS
250: select /*+ INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) */
251: pee.rowid row_id,
252: pee.element_entry_id element_entry_id
253: from pay_element_entries_f pee
254: where pee.element_link_id = p_element_link_id

Line 253: from pay_element_entries_f pee

249: IS
250: select /*+ INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) */
251: pee.rowid row_id,
252: pee.element_entry_id element_entry_id
253: from pay_element_entries_f pee
254: where pee.element_link_id = p_element_link_id
255: and not exists(select /*+ INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */
256: NULL
257: from pay_element_entry_values_f peev

Line 333: from pay_element_entries_f pee

329: pee.effective_end_date,
330: l_input_value_id_to,
331: pee.element_entry_id,
332: NULL
333: from pay_element_entries_f pee
334: where pee.rowid=rec_element_entry.row_id;
335:
336: l_total_upd_actions := l_total_upd_actions + 1;
337: if l_total_upd_actions > 1000 then

Line 403: from pay_element_entries_f pee

399: p_session_date IN DATE)
400: IS
401: select pee.element_entry_id,
402: pee.effective_start_date
403: from pay_element_entries_f pee
404: where pee.element_link_id=p_element_link_id
405: and p_session_date 406:
407: CURSOR csr_chk_entry(

Line 412: from pay_element_entries_f pee

408: p_element_entry_id IN NUMBER,
409: p_session_date IN DATE)
410: IS
411: select pee.element_entry_id
412: from pay_element_entries_f pee
413: where pee.element_entry_id=p_element_entry_id
414: and p_session_date
415: between pee.effective_start_date and pee.effective_end_date;
416:

Line 885: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */

881: is
882: select /*+ ORDERED
883: USE_NL(PLIV, PEE)
884: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)
885: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
886: pee.effective_start_date,
887: pee.updating_action_id
888: from pay_link_input_values_f pliv,
889: pay_element_entries_f pee

Line 889: pay_element_entries_f pee

885: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
886: pee.effective_start_date,
887: pee.updating_action_id
888: from pay_link_input_values_f pliv,
889: pay_element_entries_f pee
890: where pliv.input_value_id = c_smr_iv_id
891: and p_session_date
892: between pliv.effective_start_date and pliv.effective_end_date
893: and pee.element_link_id = pliv.element_link_id

Line 903: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */

899: is
900: select /*+ ORDERED
901: USE_NL(PLIV, PEE)
902: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)
903: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
904: pee.effective_start_date
905: from pay_link_input_values_f pliv,
906: pay_element_entries_f pee
907: where pliv.input_value_id = c_smr_iv_id

Line 906: pay_element_entries_f pee

902: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)
903: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
904: pee.effective_start_date
905: from pay_link_input_values_f pliv,
906: pay_element_entries_f pee
907: where pliv.input_value_id = c_smr_iv_id
908: and p_session_date
909: between pliv.effective_start_date and pliv.effective_end_date
910: and pee.element_link_id = pliv.element_link_id

Line 1169: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)

1165: is
1166: select /*+ ORDERED
1167: USE_NL(PEL, PEE, PEEV)
1168: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)
1169: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
1170: INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */
1171: pee.element_entry_id,
1172: pee.effective_start_date,
1173: pee.effective_end_date,

Line 1178: pay_element_entries_f pee,

1174: pee.object_version_number,
1175: peev.input_value_id,
1176: peev.screen_entry_value
1177: from pay_element_links_f pel,
1178: pay_element_entries_f pee,
1179: pay_element_entry_values_f peev
1180: where pel.element_type_id = c_com_hi_smr_elm_id
1181: and pel.business_group_id + 0 = p_business_group_id
1182: and p_session_date

Line 1980: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */

1976: is
1977: select /*+ ORDERED
1978: USE_NL(PLIV, PEE)
1979: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)
1980: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
1981: pee.effective_start_date
1982: -- pee.updating_action_id
1983: from pay_link_input_values_f pliv,
1984: pay_element_entries_f pee

Line 1984: pay_element_entries_f pee

1980: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
1981: pee.effective_start_date
1982: -- pee.updating_action_id
1983: from pay_link_input_values_f pliv,
1984: pay_element_entries_f pee
1985: where pliv.input_value_id = c_sec_sal_iv_id
1986: and p_session_date
1987: between pliv.effective_start_date and pliv.effective_end_date
1988: and pee.element_link_id = pliv.element_link_id

Line 1998: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */

1994: is
1995: select /*+ ORDERED
1996: USE_NL(PLIV, PEE)
1997: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)
1998: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
1999: pee.effective_start_date
2000: from pay_link_input_values_f pliv,
2001: pay_element_entries_f pee
2002: where pliv.input_value_id = c_sec_sal_iv_id

Line 2001: pay_element_entries_f pee

1997: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)
1998: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
1999: pee.effective_start_date
2000: from pay_link_input_values_f pliv,
2001: pay_element_entries_f pee
2002: where pliv.input_value_id = c_sec_sal_iv_id
2003: and p_session_date
2004: between pliv.effective_start_date and pliv.effective_end_date
2005: and pee.element_link_id = pliv.element_link_id

Line 2395: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)

2391: is
2392: select /*+ ORDERED
2393: USE_NL(PLIV, PEE, PEEV)
2394: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)
2395: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
2396: INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */
2397: pee.element_entry_id,
2398: pee.object_version_number,
2399: peev.screen_entry_value sec_sal

Line 2401: pay_element_entries_f pee,

2397: pee.element_entry_id,
2398: pee.object_version_number,
2399: peev.screen_entry_value sec_sal
2400: from pay_link_input_values_f pliv,
2401: pay_element_entries_f pee,
2402: pay_element_entry_values_f peev
2403: where pliv.input_value_id = c_sec_sal_iv_id
2404: and p_session_date
2405: between pliv.effective_start_date and pliv.effective_end_date