DBA Data[Home] [Help]

APPS.HR_APPROVAL_CUSTOM dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 241: from per_assignment_status_types

237: and paf.effective_end_date
238: and paf.assignment_type in ('E','C')
239: and paf.assignment_status_type_id not in
240: (select assignment_status_type_id
241: from per_assignment_status_types
242: where per_system_status = 'TERM_ASSIGN' and business_group_id=paf.business_group_id)
243: and ppf.person_id = paf.supervisor_id
244: and (ppf.current_employee_flag = 'Y' Or ppf.current_npw_flag = 'Y')
245: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date;