DBA Data[Home] [Help]

APPS.PER_VACANCY_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 719: from per_assignment_status_types

715: and not exists ( select 1
716: from per_all_assignments_f f2
717: where asg.assignment_id = f2.assignment_id
718: and f2.assignment_status_type_id in ( select assignment_status_type_id
719: from per_assignment_status_types
720: where per_system_status in ('ACCEPTED')));
721: /*and ( asg.organization_id <> nvl(l_organization_id,asg.organization_id)
722: or nvl(asg.job_id, -1) <> nvl(l_job_id,nvl(asg.job_id, -1))
723: or nvl(asg.grade_id, -1) <> nvl(l_grade_id,nvl(asg.grade_id, -1))