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 1467: SELECT assignment_status_type_id FROM per_assignment_status_types

1463: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1464: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1465: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
1466: and asg.assignment_status_type_id not in (
1467: SELECT assignment_status_type_id FROM per_assignment_status_types
1468: WHERE per_system_status = 'TERM_ASSIGN'
1469: ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date
1470: order by person.last_name
1471: ) where rownum = 1;

Line 1520: from per_assignment_status_types

1516: WHERE person_id = l_person_id
1517: and primary_flag = 'Y' and assignment_type in ('E','C')
1518: and assignment_status_type_id not in
1519: (select assignment_status_type_id
1520: from per_assignment_status_types
1521: where per_system_status = 'TERM_ASSIGN')
1522: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE)
1523: AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
1524: and rownum = 1;