175: CURSOR get_acnt_info(p_term_id NUMBER) IS
176: SELECT account_id,
177: account_class,
178: percentage
179: FROM pn_distributions_all
180: WHERE payment_term_id = p_term_id;
181:
182: TYPE acnt_type IS TABLE OF get_acnt_info%ROWTYPE
183: INDEX BY BINARY_INTEGER;
309: RETURN NUMBER IS
310:
311: CURSOR get_lia_acnt(p_term_id IN NUMBER) IS
312: SELECT account_id
313: FROM pn_distributions_all
314: WHERE payment_term_id = p_term_id
315: AND account_class = 'LIA';
316:
317: CURSOR get_lia_vendor_site(p_vendor_site IN NUMBER) IS