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