DBA Data[Home] [Help]

APPS.PO_VAL_LINES2 dependencies on FINANCIALS_SYSTEM_PARAMETERS

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 723: FROM financials_system_parameters fsp

719: FROM DUAL
720: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
721: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
722: AND NOT EXISTS(SELECT 1
723: FROM financials_system_parameters fsp
724: WHERE fsp.business_group_id = p_job_business_group_id_tbl(i));
725:
726: IF (SQL%ROWCOUNT > 0) THEN
727: x_result_type := po_validations.c_result_type_failure;