DBA Data[Home] [Help]

APPS.PO_CLM_CAR_UTIL dependencies on PO_HEADERS_ALL

Line 441: FROM PO_HEADERS_ALL

437: l_ref_idv_id NUMBER;
438: BEGIN
439: SELECT CLM_SOURCE_DOCUMENT_ID
440: INTO l_ref_idv_id
441: FROM PO_HEADERS_ALL
442: WHERE PO_HEADER_ID = p_po_header_id;
443:
444: IF l_ref_idv_id IS NOT NULL THEN
445: BEGIN

Line 462: FROM PO_HEADERS_ALL

458: ELSE
459:
460: SELECT CLM_EXTERNAL_IDV
461: INTO x_ref_idv_piid
462: FROM PO_HEADERS_ALL
463: WHERE PO_HEADER_ID = p_po_header_id;
464:
465: END IF;
466:

Line 506: FROM PO_HEADERS_ALL

502: l_report_type VARCHAR2(60);
503: BEGIN
504: SELECT TYPE_LOOKUP_CODE
505: INTO l_type_lookup_code
506: FROM PO_HEADERS_ALL
507: WHERE PO_HEADER_ID = p_po_header_id;
508: IF l_type_lookup_code = 'STANDARD' THEN
509: l_report_type := 'AWARD';
510: ELSIF l_type_lookup_code = 'BLANKET' THEN