APPS.QLTCPPLB dependencies on PO_LOOKUP_CODES

Line 438: FROM PO_LOOKUP_CODES

434:
435: IF X_COPY_PLAN_ID IN (1,2147483637) AND QPCAT.LOW_VALUE_OTHER IN ('ACCEPT', 'REJECT') THEN
436: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS
437: SET LOW_VALUE_OTHER = (SELECT DISPLAYED_FIELD
438: FROM PO_LOOKUP_CODES
439: WHERE LOOKUP_TYPE = 'ERT RESULTS ACTION'
440: AND LOOKUP_CODE = QPCAT.LOW_VALUE_OTHER)
441: WHERE PLAN_CHAR_ACTION_TRIGGER_ID = ACTION_TRIGGER_ID;
442: END IF;