APPS.PAY_JP_WIC_PKG dependencies on PAY_INPUT_VALUES_F

Line 402: from pay_input_values_f piv,

398: min(decode(piv.display_sequence, 7, peev.screen_entry_value)) salary_payer_address_kana,
399: min(decode(piv.display_sequence, 8, peev.screen_entry_value)) salary_payer_address_kanji,
400: min(decode(piv.display_sequence, 9, peev.screen_entry_value)) salary_payer_name_kana,
401: min(decode(piv.display_sequence, 10, peev.screen_entry_value)) salary_payer_name_kanji
402: from pay_input_values_f piv,
403: pay_element_entry_values_f peev,
404: pay_element_entries_f pee,
405: pay_element_links_f pel
406: where pel.element_type_id = g_prev_job_elm

Line 964: INDEX(PIV_1 PAY_INPUT_VALUES_F_PK)

960: cursor csr_housing
961: is
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)

Line 965: INDEX(PIV_3 PAY_INPUT_VALUES_F_PK)

961: is
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)

Line 976: from pay_input_values_f piv_1,

972: INDEX(PEEV_3 PAY_ELEMENT_ENTRY_VALUES_F_N50) */
973: decode(piv_1.uom,'D',fnd_date.canonical_to_date(peev_1.screen_entry_value),null) residence_date,
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,

Line 977: pay_input_values_f piv_3,

973: decode(piv_1.uom,'D',fnd_date.canonical_to_date(peev_1.screen_entry_value),null) residence_date,
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,

Line 1085: pay_input_values_f piv

1081: min(decode(piv.display_sequence, 12, peev.screen_entry_value)) wtm_description5
1082: from pay_element_links_f pel,
1083: pay_element_entries_f pee,
1084: pay_element_entry_values_f peev,
1085: pay_input_values_f piv
1086: where pel.element_type_id = g_desc_element_type_id
1087: and pel.business_group_id = p_business_group_id
1088: and p_effective_date
1089: between pel.effective_start_date and pel.effective_end_date