DBA Data[Home] [Help]

APPS.PN_MASS_APPR_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 355: FROM pn_payment_terms_all ppt,

351: ,p_ship_address_rule IN VARCHAR) IS
352: SELECT 'Y'
353: FROM DUAL
354: WHERE EXISTS (SELECT NULL
355: FROM pn_payment_terms_all ppt,
356: pn_payment_items_all ppi
357: WHERE ppi.payment_term_id = ppt.payment_term_id
358: AND ppi.payment_schedule_id = p_schedule_id
359: AND (ppt.customer_id IS NULL

Line 378: FROM pn_payment_terms_all ppt,

374: CURSOR check_pay_term (p_schedule_id IN NUMBER) IS
375: SELECT 'Y'
376: FROM dual
377: WHERE EXISTS (SELECT NULL
378: FROM pn_payment_terms_all ppt,
379: pn_payment_items_all ppi
380: WHERE ppi.payment_term_id = ppt.payment_term_id
381: AND ppi.payment_schedule_id = p_schedule_id
382: AND (ppt.vendor_id IS NULL OR