APPS.PO_VAL_LINES2 dependencies on PER_JOBS_VL

Line 557: FROM per_jobs_vl pj, financials_system_parameters fsp

553: FROM DUAL
554: WHERE p_purchase_basis_tbl(i) = 'TEMP LABOR'
555: AND NOT EXISTS(
556: SELECT 1
557: FROM per_jobs_vl pj, financials_system_parameters fsp
558: WHERE pj.job_id = p_job_id_tbl(i)
559: AND pj.business_group_id = fsp.business_group_id
560: AND fsp.business_group_id = NVL(p_job_business_group_id_tbl(i),
561: fsp.business_group_id)

Line 603: FROM per_jobs_vl pj, per_business_groups_perf pbg

599: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
600: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
601: AND NOT EXISTS(
602: SELECT 1
603: FROM per_jobs_vl pj, per_business_groups_perf pbg
604: WHERE pj.job_id = p_job_id_tbl(i)
605: AND pj.business_group_id = p_job_business_group_id_tbl(i)
606: AND pj.business_group_id = pbg.business_group_id
607: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(pj.date_from),

Line 644: FROM po_job_associations_b pja, per_jobs_vl pj

640: WHERE p_purchase_basis_tbl(i) = 'TEMP LABOR'
641: AND p_category_id_tbl(i) IS NOT NULL
642: AND NOT EXISTS(
643: SELECT 1
644: FROM po_job_associations_b pja, per_jobs_vl pj
645: WHERE pja.job_id = p_job_id_tbl(i)
646: AND pja.category_id = p_category_id_tbl(i)
647: AND pja.job_id = pj.job_id
648: AND NVL(TRUNC(pja.inactive_date), TRUNC(sysdate)) >= TRUNC(sysdate)