DBA Data[Home] [Help]

APPS.BEN_TCS_STMT_PROCESS dependencies on PER_JOBS_TL

Line 170: FROM per_jobs_tl jobs , per_all_assignments_f assign,

166:
167: IF ( p_assignment_id IS NOT NULL) THEN
168: SELECT jobs.name
169: INTO p_job
170: FROM per_jobs_tl jobs , per_all_assignments_f assign,
171: ( SELECT assignment.assignment_id , max(assignment.effective_end_date)end_date
172: FROM per_all_assignments_f assignment
173: WHERE assignment.assignment_id = p_assignment_id GROUP BY assignment_id) b
174: WHERE