APPS.HR_UTIL_MISC_SS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 521: FROM per_assignments_f2 paf, per_assignment_status_types past

517:
518:
519: cursor fetch_asg (l_person_id NUMBER, l_effective_date DATE) is
520: SELECT 'T'
521: FROM per_assignments_f2 paf, per_assignment_status_types past
522: WHERE paf.person_id = l_person_id
523: AND l_effective_date between paf.effective_start_date and paf.effective_end_date
524: AND paf.primary_flag = 'Y'
525: AND paf.assignment_type IN ('E', 'C')

Line 1013: from per_all_assignments_f asg ,per_assignment_status_types ast

1009: return date is
1010: l_asg_term_date date;
1011: begin
1012: select min(asg.EFFECTIVE_start_DATE) into l_asg_term_date
1013: from per_all_assignments_f asg ,per_assignment_status_types ast
1014: where asg.assignment_id = p_assignment_id
1015: and ast.assignment_status_type_id = asg.assignment_status_type_id
1016: and ast.per_system_status = 'TERM_ASSIGN';
1017: