DBA Data[Home] [Help]

APPS.PAY_CA_ARCHIVE dependencies on HR_GENERAL

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

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