DBA Data[Home] [Help]

APPS.PAY_CA_ARCHIVE dependencies on HR_GENERAL

Line 904: or trunc(paf.effective_end_date) = hr_general.END_OF_TIME

900: and paf.person_id >= stperson
901: and paf.person_id <= endperson
902: and paf.assignment_type in ('E','C')
903: and (paf.effective_end_date >= b_end_date
904: or trunc(paf.effective_end_date) = hr_general.END_OF_TIME
905: )
906: and paf.effective_start_date <= b_start_date
907: group by
908: paf.assignment_id,