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_LINK_INPUT_VALUES_F

Line 279: insert into pay_link_input_values_f

275: l_costed_flag := 'Y';
276: else
277: l_costed_flag := 'N';
278: end if;
279: insert into pay_link_input_values_f
280: (LINK_INPUT_VALUE_ID,
281: EFFECTIVE_START_DATE,
282: EFFECTIVE_END_DATE,
283: ELEMENT_LINK_ID,

Line 314: from pay_link_input_values_f

310: from pay_element_links_f pel
311: where pel.rowid=rec_element_link.row_id
312: and not exists(
313: select null
314: from pay_link_input_values_f
315: where element_link_id = rec_element_link.element_link_id
316: and input_value_id = l_input_value_id_to);
317: hr_utility.trace('Successefully created link_input_value '|| to_char(rec_element_link.element_link_id));
318:

Line 884: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)

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

Line 888: from pay_link_input_values_f pliv,

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

Line 902: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)

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

Line 905: from pay_link_input_values_f pliv,

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

Line 1979: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)

1975: cursor csr_ee
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,

Line 1983: from pay_link_input_values_f pliv,

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

Line 1997: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)

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

Line 2000: from pay_link_input_values_f pliv,

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

Line 2394: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)

2390: cursor csr_entry
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,

Line 2400: from pay_link_input_values_f pliv,

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