DBA Data[Home] [Help]

APPS.SSP_SSP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

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

3737: g_SSP_correction.input_currency_code)),null)) QUALIFYING_DAYS
3738: from pay_input_values_f inp,
3739: pay_element_entry_values_f eev,
3740: pay_element_entries_f ENTRY,
3741: per_all_assignments_f ASGT /* adding this join speeds up the entry query */
3742: where creator_type = c_SSP_creator_type
3743: and creator_id = g_PIW_id
3744: and asgt.person_id = absentee.person_id
3745: and asgt.assignment_id = entry.assignment_id