APPS.PO_VAL_LINES2 dependencies on FINANCIALS_SYSTEM_PARAMETERS

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

728: FROM DUAL
729: WHERE p_job_business_group_id_tbl(i) IS NOT NULL
730: AND p_purchase_basis_tbl(i) = 'TEMP LABOR'
731: AND NOT EXISTS(SELECT 1
732: FROM financials_system_parameters fsp
733: WHERE fsp.business_group_id = p_job_business_group_id_tbl(i));
734:
735: IF (SQL%ROWCOUNT > 0) THEN
736: x_result_type := po_validations.c_result_type_failure;

Line 4323: from financials_system_parameters;

4319: -- When we call the validate_ccid() function, we should ideally be passing inventory_org_id for the OU in which the PO is created.
4320: -- Currently we are passing the org_id of the OU in which the PO is created.
4321: select inventory_organization_id
4322: into x_org_id
4323: from financials_system_parameters;
4324: -- Bug 14622747
4325:
4326:
4327: FOR i IN 1..p_po_line_id_tbl.Count