DBA Data[Home] [Help]

APPS.PN_R12_UTIL_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 288: pn_payment_terms_all ppt

284: CURSOR chk_other_dist_ins IS
285: SELECT ppt.legal_entity_id le_id,
286: dist.account_id cc_id
287: FROM pn_distributions dist,
288: pn_payment_terms_all ppt
289: WHERE dist.payment_term_id = p_payment_term_id
290: AND ppt.payment_term_id = p_payment_term_id
291: AND rownum < 2;
292:

Line 306: pn_payment_terms_all ppt

302: CURSOR chk_other_dist_upd IS
303: SELECT ppt.legal_entity_id le_id,
304: dist.account_id cc_id
305: FROM pn_distributions dist,
306: pn_payment_terms_all ppt
307: WHERE dist.payment_term_id = p_payment_term_id
308: AND ppt.payment_term_id = p_payment_term_id
309: AND distribution_id <> p_distribution_id
310: AND rownum < 2;