APPS.ICX_CAT_POPULATE_STATUS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 103

  SELECT VALID_FOR_POPULATE
  INTO l_ret_status
  FROM po_headers_all ph,
       po_lines_all pl
  WHERE pl.po_line_id = p_po_line_id
  AND ph.po_header_id = pl.po_header_id
  AND ph.type_lookup_code = 'QUOTATION'
  AND ph.status_lookup_code = 'A'
  AND ph.quotation_class_code = 'CATALOG'
  AND (NVL(ph.approval_required_flag,'N') = 'N' OR
       (ph.approval_required_flag ='Y' AND
        EXISTS (SELECT 'current approved effective price break'
                FROM po_line_locations_all pll,
                     po_quotation_approvals_all pqa
                  WHERE pl.po_line_id = pll.po_line_id
                  AND SYSDATE <= NVL(pll.end_date, SYSDATE+1)
                  AND pqa.line_location_id = pll.line_location_id
                  AND pqa.approval_type IS NOT NULL
                  AND SYSDATE <= NVL(pqa.end_date_active, SYSDATE+1) )))
  AND TRUNC(SYSDATE) <= NVL(TRUNC(ph.end_date), TRUNC(SYSDATE + 1));