DBA Data[Home] [Help]

APPS.PAY_JP_REPORT_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 1102: INDEX(PELF PAY_ELEMENT_LINKS_F_N7)

1098: addr.screen_entry_value PJOB_ADDR,
1099: employer_name.screen_entry_value PJOB_EMPLOYER_NAME
1100: from (select /*+ ORDERED
1101: INDEX(PETF PAY_ELEMENT_TYPES_F_PK)
1102: INDEX(PELF PAY_ELEMENT_LINKS_F_N7)
1103: INDEX(PEEF PAY_ELEMENT_ENTRIES_F_N51) */
1104: peef.element_entry_id
1105: from pay_element_types_f petf,
1106: pay_element_links_f pelf,

Line 1106: pay_element_links_f pelf,

1102: INDEX(PELF PAY_ELEMENT_LINKS_F_N7)
1103: INDEX(PEEF PAY_ELEMENT_ENTRIES_F_N51) */
1104: peef.element_entry_id
1105: from pay_element_types_f petf,
1106: pay_element_links_f pelf,
1107: pay_element_entries_f peef
1108: where petf.element_type_id = p_pjob_ele_type_id
1109: and pelf.element_type_id = petf.element_type_id
1110: and pelf.business_group_id +0 = p_business_group_id