APPS.PO_VAL_LINES2 dependencies on PER_BUSINESS_GROUPS_PERF

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

759: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
760: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
761: AND NOT EXISTS(
762: SELECT 1
763: FROM per_business_groups_perf pbg
764: WHERE pbg.business_group_id = p_job_business_group_id_tbl(i)
765: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(pbg.date_from), TRUNC(SYSDATE))
766: AND NVL(TRUNC(pbg.date_to), TRUNC(SYSDATE)));
767: