APPS.XDP_PURGE dependencies on XNP_MSG_TYPES_B

Line 797: (SELECT MSG_CODE FROM XNP_MSG_TYPES_B

793: ELSE
794: SELECT COUNT(*) INTO l_temp FROM XNP_MSGS
795: WHERE order_id = p_order_id
796: AND msg_code IN
797: (SELECT MSG_CODE FROM XNP_MSG_TYPES_B
798: WHERE PROTECTED_FLAG='Y');
799: END IF;
800:
801: RECORDS_PURGED_MSGS(l_temp,'XNP_MSGS WHERE ORDER_ID = '||p_order_id

Line 836: (SELECT MSG_CODE FROM XNP_MSG_TYPES_B

832: ELSE
833: DELETE FROM XNP_MSGS
834: WHERE order_id = p_order_id
835: AND msg_code IN
836: (SELECT MSG_CODE FROM XNP_MSG_TYPES_B
837: WHERE PROTECTED_FLAG='Y');
838: END IF;
839:
840: DELETE FROM XNP_CALLBACK_EVENTS