DBA Data[Home] [Help]

APPS.PN_OPEX_TERMS_PKG dependencies on PN_OPEX_NOTES_ALL

Line 1770: DELETE FROM PN_OPEX_NOTES_ALL

1766: IF l_deletion_allowed = 'Y' THEN
1767: pnp_debug_pkg.debug ('Deleting.agreement');
1768: -- Deleting agreement tables
1769:
1770: DELETE FROM PN_OPEX_NOTES_ALL
1771: WHERE agreement_id = p_agreement_id;
1772:
1773: DELETE FROM PN_OPEX_CRITICAL_DATES_ALL
1774: WHERE agreement_id = p_agreement_id;

Line 1802: DELETE FROM PN_OPEX_NOTES_ALL

1798:
1799: DELETE FROM PN_OPEX_RECON_DETAILS_ALL
1800: WHERE recon_id = i.recon_id;
1801:
1802: DELETE FROM PN_OPEX_NOTES_ALL
1803: WHERE recon_id = i.recon_id;
1804: END LOOP;
1805:
1806: DELETE FROM PN_PAYMENT_TERMS_ALL