APPS.PAY_JP_REPORT_PKG dependencies on PAY_LINK_INPUT_VALUES_F

Line 2086: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV1)

2082: /* Include updating entry and new entry as qualification. */
2083: cursor csr_past_std_mth_comp is
2084: select /*+ ORDERED
2085: USE_NL(PLIV1, PLIV2, PEE, PEEV1, PEEV2)
2086: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV1)
2087: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV2)
2088: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
2089: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV1)
2090: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV2) */

Line 2087: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV2)

2083: cursor csr_past_std_mth_comp is
2084: select /*+ ORDERED
2085: USE_NL(PLIV1, PLIV2, PEE, PEEV1, PEEV2)
2086: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV1)
2087: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV2)
2088: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
2089: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV1)
2090: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV2) */
2091: pee.element_entry_id ee_id,

Line 2096: from pay_link_input_values_f pliv1,

2092: pee.effective_start_date ee_esd,
2093: pee.effective_end_date ee_eed,
2094: peev1.screen_entry_value applied_mth,
2095: peev2.screen_entry_value new_std_mth_comp
2096: from pay_link_input_values_f pliv1,
2097: pay_link_input_values_f pliv2,
2098: pay_element_entries_f pee,
2099: pay_element_entry_values_f peev1,
2100: pay_element_entry_values_f peev2

Line 2097: pay_link_input_values_f pliv2,

2093: pee.effective_end_date ee_eed,
2094: peev1.screen_entry_value applied_mth,
2095: peev2.screen_entry_value new_std_mth_comp
2096: from pay_link_input_values_f pliv1,
2097: pay_link_input_values_f pliv2,
2098: pay_element_entries_f pee,
2099: pay_element_entry_values_f peev1,
2100: pay_element_entry_values_f peev2
2101: where pliv1.input_value_id = p_applied_mth_iv_id