APPS.PN_OPEX_TERMS_PKG dependencies on PN_OPEX_RECON_DETAILS_ALL

Line 1770: DELETE FROM PN_OPEX_RECON_DETAILS_ALL

1766:
1767: DELETE FROM PN_OPEX_RECON_EXP_GRP_ALL
1768: WHERE recon_id = i.recon_id;
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;

Line 2333: pn_opex_recon_details_all

2329: pn_opex_recon_all WHERE recon_id = c_recon_id;
2330:
2331: CURSOR recon_det_cur(c_recon_id IN NUMBER) IS
2332: SELECT NVL(expected_ovr , expected) AS amt FROM
2333: pn_opex_recon_details_all
2334: WHERE recon_id = c_recon_id
2335: AND TYPE = '1PRP';
2336:
2337: CURSOR csr_recon_exp_grp(c_recon_id IN NUMBER) IS