DBA Data[Home] [Help]

APPS.SSP_SSP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 3855: per_all_assignments_f ASGT /* adding this join speeds up the entry query */

3851: g_SSP_correction.input_currency_code)),null)) QUALIFYING_DAYS
3852: from pay_input_values_f inp,
3853: pay_element_entry_values_f eev,
3854: pay_element_entries_f ENTRY,
3855: per_all_assignments_f ASGT /* adding this join speeds up the entry query */
3856: where creator_type = c_SSP_creator_type
3857: and creator_id = g_PIW_id
3858: and asgt.person_id = absentee.person_id
3859: and asgt.assignment_id = entry.assignment_id