DBA Data[Home] [Help]

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'