DBA Data[Home] [Help]

APPS.PQH_COMMITMENT_PKG dependencies on PER_ASSIGNMENTS_F

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'