APPS.HR_ENTRY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1644: per_assignment_status_types ast

1640: begin
1641: select min(asg.effective_start_date)
1642: into v_asg_term_date
1643: from per_assignments_f asg,
1644: per_assignment_status_types ast
1645: where asg.assignment_id = p_assignment_id
1646: and asg.effective_end_date >= p_session_date
1647: and asg.assignment_status_type_id = ast.assignment_status_type_id
1648: and ast.per_system_status = 'TERM_ASSIGN';

Line 1664: per_assignment_status_types ast

1660: begin
1661: select asg.effective_start_date
1662: into v_asg_term_date
1663: from per_assignments_f asg,
1664: per_assignment_status_types ast
1665: where asg.assignment_id = p_assignment_id
1666: and asg.effective_end_date >= p_session_date
1667: and asg.assignment_status_type_id = ast.assignment_status_type_id
1668: and ast.per_system_status = 'END';