APPS.PO_VAL_LINES2 dependencies on PER_JOBS_VL

Line 566: FROM per_jobs_vl pj, financials_system_parameters fsp

562: FROM DUAL
563: WHERE p_purchase_basis_tbl(i) = 'TEMP LABOR'
564: AND NOT EXISTS(
565: SELECT 1
566: FROM per_jobs_vl pj, financials_system_parameters fsp
567: WHERE pj.job_id = p_job_id_tbl(i)
568: AND pj.business_group_id = fsp.business_group_id
569: AND fsp.business_group_id = NVL(p_job_business_group_id_tbl(i),
570: fsp.business_group_id)

Line 612: FROM per_jobs_vl pj, per_business_groups_perf pbg

608: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
609: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
610: AND NOT EXISTS(
611: SELECT 1
612: FROM per_jobs_vl pj, per_business_groups_perf pbg
613: WHERE pj.job_id = p_job_id_tbl(i)
614: AND pj.business_group_id = p_job_business_group_id_tbl(i)
615: AND pj.business_group_id = pbg.business_group_id
616: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(pj.date_from),

Line 653: FROM po_job_associations_b pja, per_jobs_vl pj

649: WHERE p_purchase_basis_tbl(i) = 'TEMP LABOR'
650: AND p_category_id_tbl(i) IS NOT NULL
651: AND NOT EXISTS(
652: SELECT 1
653: FROM po_job_associations_b pja, per_jobs_vl pj
654: WHERE pja.job_id = p_job_id_tbl(i)
655: AND pja.category_id = p_category_id_tbl(i)
656: AND pja.job_id = pj.job_id
657: AND NVL(TRUNC(pja.inactive_date), TRUNC(sysdate)) >= TRUNC(sysdate)