APPS.POS_SUPP_APPR dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 460: SELECT assignment_status_type_id FROM per_assignment_status_types

456: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
457: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
458: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
459: and asg.assignment_status_type_id not in (
460: SELECT assignment_status_type_id FROM per_assignment_status_types
461: WHERE per_system_status = 'TERM_ASSIGN'
462: ) and trunc(sysdate) between asg.effective_start_date
463: and asg.effective_end_date order by person.last_name
464: ) where rownum = 1;

Line 1438: SELECT assignment_status_type_id FROM per_assignment_status_types

1434: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1435: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1436: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
1437: and asg.assignment_status_type_id not in (
1438: SELECT assignment_status_type_id FROM per_assignment_status_types
1439: WHERE per_system_status = 'TERM_ASSIGN'
1440: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date
1441: order by person.last_name
1442: ) where rownum = 1;

Line 1491: from per_assignment_status_types

1487: WHERE person_id = l_person_id
1488: and primary_flag = 'Y' and assignment_type in ('E','C')
1489: and assignment_status_type_id not in
1490: (select assignment_status_type_id
1491: from per_assignment_status_types
1492: where per_system_status = 'TERM_ASSIGN')
1493: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE)
1494: AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
1495: and rownum = 1;