609: /* AND TRUNC(POL.creation_date) NOT BETWEEN
610: NVL(TRUNC(p_start_date), POL.creation_date - 1)
611: AND NVL(TRUNC(p_end_date), POL.creation_date + 1) */
612: AND POH.approved_date IS NOT NULL
613: AND TRUNC(POH.approved_date) > TRUNC(p_end_date+ nvl(FND_PROFILE.VALUE('PO_REL_CREATE_TOLERANCE'),0))
614: AND NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED'
615: AND NVL(POH.cancel_flag, 'N') <> 'Y';
616:
617: -- return a row violating the effective dates