DBA Data[Home] [Help]

APPS.SSP_SSP_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 3740: pay_element_entries_f ENTRY,

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

Line 3761: from pay_element_entries_f ENTRY2

3757: and not exists (
3758: /* Do not select entries which have already had reversal action *
3759: * taken against them because they are effectively cancelled out */
3760: select 1
3761: from pay_element_entries_f ENTRY2
3762: where entry.element_entry_id = entry2.target_entry_id
3763: and entry.assignment_id = entry2.assignment_id)
3764: and inp.element_type_id <> g_SSP_correction.element_type_id
3765: /* Do not select reversal entries */