[Home] [Help]
142: -- declare cursors.....
143: CURSOR pterm (V_LEASE_ID IN NUMBER) IS
144: SELECT payment_term_id,start_date,end_date,payment_term_type_code,vendor_id,
145: vendor_site_id, customer_id, customer_site_use_id
146: FROM pn_payment_terms_all
147: WHERE lease_id = V_LEASE_ID
148: AND payment_term_type_code in ('BASE','DEP','OEXP');
149:
150: