DBA Data[Home] [Help]

APPS.PN_EXP_TO_AP dependencies on PN_DISTRIBUTIONS_ALL

Line 179: FROM pn_distributions_all

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;

Line 313: FROM pn_distributions_all

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