APPS.PON_FBO_PKG dependencies on PO_LOOKUP_CODES

Line 336: l_setaside_value PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

332: l_classcode_query VARCHAR2(1000);
333:
334: l_setaside_code pon_form_field_values.TEXTCOL1%TYPE;
335: l_setaside_code_query VARCHAR2(1000);
336: l_setaside_value PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
337: l_amendment_id pon_auctioN_headers_all.auction_Header_id%TYPE;
338:
339: BEGIN
340:

Line 448: SELECT DISPLAYED_FIELD INTO l_setaside_value FROM PO_LOOKUP_CODES

444:
445: EXECUTE IMMEDIATE l_setaside_code_query INTO l_setaside_code
446: USING p_auction_header_id,p_form_id;
447:
448: SELECT DISPLAYED_FIELD INTO l_setaside_value FROM PO_LOOKUP_CODES
449: WHERE LOOKUP_TYPE = 'PO_CLM_SET_ASIDE_TYPE'
450: AND lookup_code = l_setaside_code
451: AND ROWNUM < 2;
452: