APPS.POR_VIEW_REQS_PKG dependencies on PO_LOOKUP_CODES

Line 813: value PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE := '';

809: /****************************************************************************
810: * This function returns urgent flag value of a given requisition header id *
811: ****************************************************************************/
812: function get_urgent_flag(req_header_id IN NUMBER) RETURN VARCHAR2 is
813: value PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE := '';
814: begin
815: select plc_urg.displayed_field
816: into value
817: from

Line 820: po_lookup_codes plc_urg

816: into value
817: from
818: po_requisition_headers_all prh,
819: po_requisition_lines_all prl,
820: po_lookup_codes plc_urg
821: where
822: prh.requisition_header_id = req_header_id and
823: prl.requisition_header_id = prh.requisition_header_id and
824: plc_urg.lookup_code = nvl(prl.urgent_flag, 'N') and