APPS.PO_COPYDOC_SUB dependencies on PER_JOBS_VL

Line 2169: l_job_name per_jobs_vl.name%TYPE;

2165: ) IS
2166:
2167: l_valid_flag VARCHAR2(2);
2168: l_progress VARCHAR2(4) := NULL;
2169: l_job_name per_jobs_vl.name%TYPE;
2170: l_bg_name per_business_groups_perf.name%TYPE;
2171: l_category mtl_categories_kfv.concatenated_segments%TYPE;
2172:
2173: BEGIN

Line 2189: FROM per_jobs_vl pj,

2185: SELECT pj.name,
2186: pb.name
2187: INTO l_job_name,
2188: l_bg_name
2189: FROM per_jobs_vl pj,
2190: per_business_groups_perf pb
2191: WHERE pj.business_group_id = pb.business_group_id
2192: AND pj.job_id = p_job_id;
2193: