APPS.QLTCPPLB dependencies on PO_LOOKUP_CODES

Line 446: FROM PO_LOOKUP_CODES

442:
443: IF X_COPY_PLAN_ID IN (1,2147483637) AND QPCAT.LOW_VALUE_OTHER IN ('ACCEPT', 'REJECT') THEN
444: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS
445: SET LOW_VALUE_OTHER = (SELECT DISPLAYED_FIELD
446: FROM PO_LOOKUP_CODES
447: WHERE LOOKUP_TYPE = 'ERT RESULTS ACTION'
448: AND LOOKUP_CODE = QPCAT.LOW_VALUE_OTHER)
449: WHERE PLAN_CHAR_ACTION_TRIGGER_ID = ACTION_TRIGGER_ID;
450: END IF;