DBA Data[Home] [Help]

APPS.PAY_JP_WIC_PKG dependencies on PAY_LINK_INPUT_VALUES_F

Line 966: INDEX(PLIV_1 PAY_LINK_INPUT_VALUES_F_N2)

962: select /*+ ORDERED
963: USE_NL(PIV_1, PIV_3, PLIV_1, PLIV_2, PLIV_3, PEE, PEEV_1, PEEV_2, PEEV_3)
964: INDEX(PIV_1 PAY_INPUT_VALUES_F_PK)
965: INDEX(PIV_3 PAY_INPUT_VALUES_F_PK)
966: INDEX(PLIV_1 PAY_LINK_INPUT_VALUES_F_N2)
967: INDEX(PLIV_2 PAY_LINK_INPUT_VALUES_F_N2)
968: INDEX(PLIV_3 PAY_LINK_INPUT_VALUES_F_N2)
969: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
970: INDEX(PEEV_1 PAY_ELEMENT_ENTRY_VALUES_F_N50)

Line 967: INDEX(PLIV_2 PAY_LINK_INPUT_VALUES_F_N2)

963: USE_NL(PIV_1, PIV_3, PLIV_1, PLIV_2, PLIV_3, PEE, PEEV_1, PEEV_2, PEEV_3)
964: INDEX(PIV_1 PAY_INPUT_VALUES_F_PK)
965: INDEX(PIV_3 PAY_INPUT_VALUES_F_PK)
966: INDEX(PLIV_1 PAY_LINK_INPUT_VALUES_F_N2)
967: INDEX(PLIV_2 PAY_LINK_INPUT_VALUES_F_N2)
968: INDEX(PLIV_3 PAY_LINK_INPUT_VALUES_F_N2)
969: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
970: INDEX(PEEV_1 PAY_ELEMENT_ENTRY_VALUES_F_N50)
971: INDEX(PEEV_2 PAY_ELEMENT_ENTRY_VALUES_F_N50)

Line 968: INDEX(PLIV_3 PAY_LINK_INPUT_VALUES_F_N2)

964: INDEX(PIV_1 PAY_INPUT_VALUES_F_PK)
965: INDEX(PIV_3 PAY_INPUT_VALUES_F_PK)
966: INDEX(PLIV_1 PAY_LINK_INPUT_VALUES_F_N2)
967: INDEX(PLIV_2 PAY_LINK_INPUT_VALUES_F_N2)
968: INDEX(PLIV_3 PAY_LINK_INPUT_VALUES_F_N2)
969: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
970: INDEX(PEEV_1 PAY_ELEMENT_ENTRY_VALUES_F_N50)
971: INDEX(PEEV_2 PAY_ELEMENT_ENTRY_VALUES_F_N50)
972: INDEX(PEEV_3 PAY_ELEMENT_ENTRY_VALUES_F_N50) */

Line 978: pay_link_input_values_f pliv_1,

974: peev_2.screen_entry_value loan_type,
975: decode(piv_3.uom,'M',fnd_number.canonical_to_number(peev_3.screen_entry_value),null) loan_balance
976: from pay_input_values_f piv_1,
977: pay_input_values_f piv_3,
978: pay_link_input_values_f pliv_1,
979: pay_link_input_values_f pliv_2,
980: pay_link_input_values_f pliv_3,
981: pay_element_entries_f pee,
982: pay_element_entry_values_f peev_1,

Line 979: pay_link_input_values_f pliv_2,

975: decode(piv_3.uom,'M',fnd_number.canonical_to_number(peev_3.screen_entry_value),null) loan_balance
976: from pay_input_values_f piv_1,
977: pay_input_values_f piv_3,
978: pay_link_input_values_f pliv_1,
979: pay_link_input_values_f pliv_2,
980: pay_link_input_values_f pliv_3,
981: pay_element_entries_f pee,
982: pay_element_entry_values_f peev_1,
983: pay_element_entry_values_f peev_2,

Line 980: pay_link_input_values_f pliv_3,

976: from pay_input_values_f piv_1,
977: pay_input_values_f piv_3,
978: pay_link_input_values_f pliv_1,
979: pay_link_input_values_f pliv_2,
980: pay_link_input_values_f pliv_3,
981: pay_element_entries_f pee,
982: pay_element_entry_values_f peev_1,
983: pay_element_entry_values_f peev_2,
984: pay_element_entry_values_f peev_3