APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on PER_JOBS_VL
Line 110: FROM per_jobs_vl pj,
106: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
107: p_effective_date IN DATE
108: ) IS
109: SELECT pj.name 110: FROM per_jobs_vl pj, 111: per_assignments_f paf
112: WHERE paf.assignment_id = p_assignment_id
113: AND paf.job_id = pj.job_id
114: AND paf.primary_flag = 'Y'