1624: BEGIN
1625:
1626: SELECT 'invoice date is ok'
1627: INTO l_temp
1628: FROM ra_terms
1629: WHERE term_id = p_term_id
1630: AND p_trx_date BETWEEN START_DATE_ACTIVE
1631: AND NVL(END_DATE_ACTIVE, p_trx_date);
1632: