DBA Data[Home] [Help]

APPS.IGC_UPGRADE_DATA_R12 dependencies on PO_REQUISITION_HEADERS_ALL

Line 538: SELECT distinct segment1 INTO l_reference_4 FROM PO_REQUISITION_HEADERS_ALL

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