APPS.PQH_COMMITMENT_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 2085: FROM per_assignments_f asg, per_assignment_status_types ast
2081: RETURN BOOLEAN
2082: is
2083: cursor curs_susp_chk is
2084: SELECT 1 2085: FROM per_assignments_f asg, per_assignment_status_types ast 2086: WHERE asg.assignment_id = p_assignment_id
2087: AND p_commit_calculation_dt between asg.effective_start_date and asg.effective_end_date
2088: AND asg.assignment_status_type_id = ast.assignment_status_type_id
2089: AND ast.per_system_status <> 'TERM_ASSIGN'