52: SELECT FL.LOOKUP_CODE,FL.MEANING INTO L_DOCUMENT_TYPE_CODE,L_DOCUMENT_TYPE
53: FROM
54: PON_AUCTION_HEADERS_ALL PAH,
55: PON_AUC_DOCTYPES DOC,
56: FND_LOOKUPS FL
57: WHERE
58: PAH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID
59: AND
60: PAH.DOCTYPE_ID=DOC.DOCTYPE_ID
458: SELECT FL.LOOKUP_CODE,FL.MEANING INTO L_DOCUMENT_TYPE_CODE,L_DOCUMENT_TYPE
459: FROM
460: PON_AUCTION_HEADERS_ALL PAH,
461: PON_AUC_DOCTYPES DOC,
462: FND_LOOKUPS FL
463: WHERE
464: PAH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID
465: AND
466: PAH.DOCTYPE_ID=DOC.DOCTYPE_ID