APPS.HR_ENTRY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1436: per_assignment_status_types ast

1432: begin
1433: select min(asg.effective_start_date)
1434: into v_asg_term_date
1435: from per_assignments_f asg,
1436: per_assignment_status_types ast
1437: where asg.assignment_id = p_assignment_id
1438: and asg.effective_end_date >= p_session_date
1439: and asg.assignment_status_type_id = ast.assignment_status_type_id
1440: and ast.per_system_status = 'TERM_ASSIGN';

Line 1456: per_assignment_status_types ast

1452: begin
1453: select asg.effective_start_date
1454: into v_asg_term_date
1455: from per_assignments_f asg,
1456: per_assignment_status_types ast
1457: where asg.assignment_id = p_assignment_id
1458: and asg.effective_end_date >= p_session_date
1459: and asg.assignment_status_type_id = ast.assignment_status_type_id
1460: and ast.per_system_status = 'END';