DBA Data[Home] [Help]

APPS.HR_MISC_WEB dependencies on PER_JOBS_VL

Line 568: FROM per_jobs_vl pj,

564: p_effective_date IN DATE
565: ) IS
566: SELECT pj.job_id,
567: pj.name
568: FROM per_jobs_vl pj,
569: per_all_assignments_f paf
570: WHERE paf.assignment_id = p_assignment_id
571: AND paf.job_id = pj.job_id
572: -- AND paf.primary_flag = 'Y' -- To supprot multiple assignments