APPS.HR_JP_DATA_MIGRATION_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 235: select /*+ INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) */

231: CURSOR csr_element_entry_id(
232: p_element_link_id IN NUMBER,
233: p_input_value_id IN NUMBER)
234: IS
235: select /*+ INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) */
236: pee.rowid row_id,
237: pee.element_entry_id element_entry_id
238: from pay_element_entries_f pee
239: where pee.element_link_id = p_element_link_id

Line 238: from pay_element_entries_f pee

234: IS
235: select /*+ INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) */
236: pee.rowid row_id,
237: pee.element_entry_id element_entry_id
238: from pay_element_entries_f pee
239: where pee.element_link_id = p_element_link_id
240: and not exists(select /*+ INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */
241: NULL
242: from pay_element_entry_values_f peev

Line 318: from pay_element_entries_f pee

314: pee.effective_end_date,
315: l_input_value_id_to,
316: pee.element_entry_id,
317: NULL
318: from pay_element_entries_f pee
319: where pee.rowid=rec_element_entry.row_id;
320:
321: l_total_upd_actions := l_total_upd_actions + 1;
322: if l_total_upd_actions > 1000 then

Line 388: from pay_element_entries_f pee

384: p_session_date IN DATE)
385: IS
386: select pee.element_entry_id,
387: pee.effective_start_date
388: from pay_element_entries_f pee
389: where pee.element_link_id=p_element_link_id
390: and p_session_date 391:
392: CURSOR csr_chk_entry(

Line 397: from pay_element_entries_f pee

393: p_element_entry_id IN NUMBER,
394: p_session_date IN DATE)
395: IS
396: select pee.element_entry_id
397: from pay_element_entries_f pee
398: where pee.element_entry_id=p_element_entry_id
399: and p_session_date
400: between pee.effective_start_date and pee.effective_end_date;
401:

Line 810: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */

806: is
807: select /*+ ORDERED
808: USE_NL(PLIV, PEE)
809: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)
810: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
811: pee.effective_start_date,
812: pee.updating_action_id
813: from pay_link_input_values_f pliv,
814: pay_element_entries_f pee

Line 814: pay_element_entries_f pee

810: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
811: pee.effective_start_date,
812: pee.updating_action_id
813: from pay_link_input_values_f pliv,
814: pay_element_entries_f pee
815: where pliv.input_value_id = c_smr_iv_id
816: and p_session_date
817: between pliv.effective_start_date and pliv.effective_end_date
818: and pee.element_link_id = pliv.element_link_id

Line 828: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */

824: is
825: select /*+ ORDERED
826: USE_NL(PLIV, PEE)
827: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)
828: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
829: pee.effective_start_date
830: from pay_link_input_values_f pliv,
831: pay_element_entries_f pee
832: where pliv.input_value_id = c_smr_iv_id

Line 831: pay_element_entries_f pee

827: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)
828: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
829: pee.effective_start_date
830: from pay_link_input_values_f pliv,
831: pay_element_entries_f pee
832: where pliv.input_value_id = c_smr_iv_id
833: and p_session_date
834: between pliv.effective_start_date and pliv.effective_end_date
835: and pee.element_link_id = pliv.element_link_id

Line 1094: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)

1090: is
1091: select /*+ ORDERED
1092: USE_NL(PEL, PEE, PEEV)
1093: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)
1094: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
1095: INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */
1096: pee.element_entry_id,
1097: pee.effective_start_date,
1098: pee.effective_end_date,

Line 1103: pay_element_entries_f pee,

1099: pee.object_version_number,
1100: peev.input_value_id,
1101: peev.screen_entry_value
1102: from pay_element_links_f pel,
1103: pay_element_entries_f pee,
1104: pay_element_entry_values_f peev
1105: where pel.element_type_id = c_com_hi_smr_elm_id
1106: and pel.business_group_id + 0 = p_business_group_id
1107: and p_session_date