DBA Data[Home] [Help]

APPS.PAY_AU_TAX_INFO_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 147: from per_all_assignments_f pa,

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
150: where pa.assignment_id = p_assignment_id
151: and l_effective_date