664: END IF;
665: BEGIN
666: SELECT NVL(GL_ID_REV, 0)
667: INTO L_SALESREP_REV_DERIVED
668: FROM RA_SALESREPS
669: WHERE SALESREP_ID = L_SALESREP_ID;
670: IF (DEBUG_COGS) THEN
671: PRINTLN('L_SALESREP_REV_DERIVED = '||L_SALESREP_REV_DERIVED);
672: END IF;