APPS.PAY_JP_REPORT_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 1093: INDEX(PELF PAY_ELEMENT_LINKS_F_N7)

1089: addr.screen_entry_value PJOB_ADDR,
1090: employer_name.screen_entry_value PJOB_EMPLOYER_NAME
1091: from (select /*+ ORDERED
1092: INDEX(PETF PAY_ELEMENT_TYPES_F_PK)
1093: INDEX(PELF PAY_ELEMENT_LINKS_F_N7)
1094: INDEX(PEEF PAY_ELEMENT_ENTRIES_F_N51) */
1095: peef.element_entry_id
1096: from pay_element_types_f petf,
1097: pay_element_links_f pelf,

Line 1097: pay_element_links_f pelf,

1093: INDEX(PELF PAY_ELEMENT_LINKS_F_N7)
1094: INDEX(PEEF PAY_ELEMENT_ENTRIES_F_N51) */
1095: peef.element_entry_id
1096: from pay_element_types_f petf,
1097: pay_element_links_f pelf,
1098: pay_element_entries_f peef
1099: where petf.element_type_id = p_pjob_ele_type_id
1100: and pelf.element_type_id = petf.element_type_id
1101: and pelf.business_group_id +0 = p_business_group_id