141: select /*+ ORDERED
142: USE_NL(PA,PEL,PEE)
143: INDEX(PA PER_ASSIGNMENTS_F_PK)
144: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)
145: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
146: pee.element_entry_id
147: from per_all_assignments_f pa,
148: pay_element_links_f pel,
149: pay_element_entries_f pee
145: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
146: pee.element_entry_id
147: from per_all_assignments_f pa,
148: pay_element_links_f pel,
149: pay_element_entries_f pee
150: where pa.assignment_id = p_assignment_id
151: and l_effective_date
152: between pa.effective_start_date and pa.effective_end_date
153: and pel.element_type_id = g_tax_info_elm_id