APPS.PAY_JP_WIC_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 404: pay_element_entries_f pee,

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
407: and pel.business_group_id + 0 = p_business_group_id
408: and p_date_earned

Line 969: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)

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

Line 981: pay_element_entries_f pee,

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
985: where piv_1.input_value_id = g_housing_loan_info_elm.res_date_iv

Line 1083: pay_element_entries_f pee,

1079: min(decode(piv.display_sequence, 10, peev.screen_entry_value)) wtm_description3,
1080: min(decode(piv.display_sequence, 11, peev.screen_entry_value)) wtm_description4,
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