DBA Data[Home] [Help]

APPS.SSP_SSP_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 3854: pay_element_entries_f ENTRY,

3850: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
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

Line 3875: from pay_element_entries_f ENTRY2

3871: and not exists (
3872: /* Do not select entries which have already had reversal action *
3873: * taken against them because they are effectively cancelled out */
3874: select 1
3875: from pay_element_entries_f ENTRY2
3876: where entry.element_entry_id = entry2.target_entry_id
3877: and entry.assignment_id = entry2.assignment_id)
3878: and inp.element_type_id <> g_SSP_correction.element_type_id
3879: /* Do not select reversal entries */