963: and trunc(sysdate) between start_date_active and NVL(end_date_active, (SYSDATE+1)) ;
964:
965: cursor C_billing_term is
966: SELECT 1 967: FROM ra_terms 968: WHERE term_id = g_award_rec.billing_term ;
969:
970:
971: cursor C_invoice_format(x_formatID NUMBER,x_format varchar2 ) is