DBA Data[Home] [Help]

APPS.PN_OPEX_TERMS_PKG dependencies on PN_OPEX_NOTES_ALL

Line 1741: DELETE FROM PN_OPEX_NOTES_ALL

1737: IF l_deletion_allowed = 'Y' THEN
1738: pnp_debug_pkg.debug ('Deleting.agreement');
1739: -- Deleting agreement tables
1740:
1741: DELETE FROM PN_OPEX_NOTES_ALL
1742: WHERE agreement_id = p_agreement_id;
1743:
1744: DELETE FROM PN_OPEX_CRITICAL_DATES_ALL
1745: WHERE agreement_id = p_agreement_id;

Line 1773: DELETE FROM PN_OPEX_NOTES_ALL

1769:
1770: DELETE FROM PN_OPEX_RECON_DETAILS_ALL
1771: WHERE recon_id = i.recon_id;
1772:
1773: DELETE FROM PN_OPEX_NOTES_ALL
1774: WHERE recon_id = i.recon_id;
1775: END LOOP;
1776:
1777: DELETE FROM PN_PAYMENT_TERMS_ALL