534: ELSIF (l_cbc_je_lines.JE_SOURCE = 'Purchasing') THEN
535: SELECT distinct segment1 INTO l_reference_4 FROM PO_HEADERS_ALL
536: WHERE po_header_id = p_cc_header_id;
537: ELSIF (l_cbc_je_lines.JE_SOURCE = 'Requisitions') THEN
538: SELECT distinct segment1 INTO l_reference_4 FROM PO_REQUISITION_HEADERS_ALL
539: WHERE requisition_header_id = p_cc_header_id;
540: ELSIF (l_cbc_je_lines.JE_SOURCE = 'Contract Commitment') THEN
541: BEGIN
542: SELECT distinct cc_num INTO l_reference_4 FROM igc_cc_headers_all