APPS.PO_COPYDOC_SUB dependencies on PER_BUSINESS_GROUPS_PERF

Line 1852: FROM per_workforce_current_x per, per_business_groups_perf pb

1848:
1849: --Bug 13542908 Using per_workforce_current_x instead of per_employees_current_x
1850: SELECT distinct 'Y'
1851: INTO x_valid_flag
1852: FROM per_workforce_current_x per, per_business_groups_perf pb
1853: WHERE per.business_group_id = pb.business_group_id
1854: AND per.person_id = x_deliver_to_person_id;
1855: /*
1856: SELECT distinct 'Y'

Line 2316: l_bg_name per_business_groups_perf.name%TYPE;

2312:
2313: l_valid_flag VARCHAR2(2);
2314: l_progress VARCHAR2(4) := NULL;
2315: l_job_name per_jobs_vl.name%TYPE;
2316: l_bg_name per_business_groups_perf.name%TYPE;
2317: l_category mtl_categories_kfv.concatenated_segments%TYPE;
2318:
2319: BEGIN
2320: l_progress := '010';

Line 2336: per_business_groups_perf pb

2332: pb.name
2333: INTO l_job_name,
2334: l_bg_name
2335: FROM per_jobs_vl pj,
2336: per_business_groups_perf pb
2337: WHERE pj.business_group_id = pb.business_group_id
2338: AND pj.job_id = p_job_id;
2339:
2340: