APPS.HR_JP_DATA_MIGRATION_PKG dependencies on PAY_LINK_INPUT_VALUES_F

Line 264: insert into pay_link_input_values_f

260: l_costed_flag := 'Y';
261: else
262: l_costed_flag := 'N';
263: end if;
264: insert into pay_link_input_values_f
265: (LINK_INPUT_VALUE_ID,
266: EFFECTIVE_START_DATE,
267: EFFECTIVE_END_DATE,
268: ELEMENT_LINK_ID,

Line 299: from pay_link_input_values_f

295: from pay_element_links_f pel
296: where pel.rowid=rec_element_link.row_id
297: and not exists(
298: select null
299: from pay_link_input_values_f
300: where element_link_id = rec_element_link.element_link_id
301: and input_value_id = l_input_value_id_to);
302: hr_utility.trace('Successefully created link_input_value '|| to_char(rec_element_link.element_link_id));
303:

Line 809: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)

805: cursor csr_ee_esd
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,

Line 813: from pay_link_input_values_f pliv,

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
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

Line 827: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)

823: cursor csr_ft_ee
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

Line 830: from pay_link_input_values_f pliv,

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
833: and p_session_date
834: between pliv.effective_start_date and pliv.effective_end_date