APPS.PO_VAL_LINES2 dependencies on PER_BUSINESS_GROUPS_PERF

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 754: FROM per_business_groups_perf pbg

750: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
751: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
752: AND NOT EXISTS(
753: SELECT 1
754: FROM per_business_groups_perf pbg
755: WHERE pbg.business_group_id = p_job_business_group_id_tbl(i)
756: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(pbg.date_from), TRUNC(SYSDATE))
757: AND NVL(TRUNC(pbg.date_to), TRUNC(SYSDATE)));
758: