DBA Data[Home] [Help]

APPS.PAY_NO_EOY_ARCHIVE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 559: ,per_assignment_status_types pas

555: ,least( p_effective_date, paf.effective_end_date) end_date
556: FROM per_all_assignments_f paf
557: ,hr_soft_coding_keyflex sck
558: ,hr_organization_information hoi
559: ,per_assignment_status_types pas
560: WHERE paf.person_id = p_person_id
561: AND sck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
562: AND pas.assignment_status_type_id = paf.assignment_status_type_id
563: AND pas.user_status = 'Active Assignment'

Line 659: ,per_assignment_status_types pas

655: ,least( p_effective_date, paf.effective_end_date) end_date
656: FROM per_all_assignments_f paf
657: ,hr_soft_coding_keyflex sck
658: ,hr_organization_information hoi
659: ,per_assignment_status_types pas
660: WHERE paf.person_id = p_person_id
661: AND sck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
662: AND pas.assignment_status_type_id = paf.assignment_status_type_id
663: AND pas.user_status = 'Active Assignment'