APPS.PAY_JP_REPORT_PKG dependencies on PAY_LINK_INPUT_VALUES_F

Line 2077: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV1)

2073: /* Include updating entry and new entry as qualification. */
2074: cursor csr_past_std_mth_comp is
2075: select /*+ ORDERED
2076: USE_NL(PLIV1, PLIV2, PEE, PEEV1, PEEV2)
2077: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV1)
2078: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV2)
2079: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
2080: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV1)
2081: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV2) */

Line 2078: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV2)

2074: cursor csr_past_std_mth_comp is
2075: select /*+ ORDERED
2076: USE_NL(PLIV1, PLIV2, PEE, PEEV1, PEEV2)
2077: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV1)
2078: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV2)
2079: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
2080: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV1)
2081: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV2) */
2082: pee.element_entry_id ee_id,

Line 2087: from pay_link_input_values_f pliv1,

2083: pee.effective_start_date ee_esd,
2084: pee.effective_end_date ee_eed,
2085: peev1.screen_entry_value applied_mth,
2086: peev2.screen_entry_value new_std_mth_comp
2087: from pay_link_input_values_f pliv1,
2088: pay_link_input_values_f pliv2,
2089: pay_element_entries_f pee,
2090: pay_element_entry_values_f peev1,
2091: pay_element_entry_values_f peev2

Line 2088: pay_link_input_values_f pliv2,

2084: pee.effective_end_date ee_eed,
2085: peev1.screen_entry_value applied_mth,
2086: peev2.screen_entry_value new_std_mth_comp
2087: from pay_link_input_values_f pliv1,
2088: pay_link_input_values_f pliv2,
2089: pay_element_entries_f pee,
2090: pay_element_entry_values_f peev1,
2091: pay_element_entry_values_f peev2
2092: where pliv1.input_value_id = p_applied_mth_iv_id