APPS.PO_COPYDOC_SUB dependencies on PER_JOBS

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:

Line 2203: FROM per_jobs

2199: l_progress := '030';
2200:
2201: SELECT 'Y'
2202: INTO l_valid_flag
2203: FROM per_jobs
2204: WHERE job_id = p_job_id
2205: AND sysdate between date_from and nvl(date_to,sysdate+1);
2206:
2207: Exception