1795:
1796: DELETE FROM PN_OPEX_RECON_EXP_GRP_ALL
1797: WHERE recon_id = i.recon_id;
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;
2360: pn_opex_recon_all WHERE recon_id = c_recon_id;
2361:
2362: CURSOR recon_det_cur(c_recon_id IN NUMBER) IS
2363: SELECT NVL(expected_ovr , expected) AS amt FROM
2364: pn_opex_recon_details_all
2365: WHERE recon_id = c_recon_id
2366: AND TYPE = '1PRP';
2367:
2368: CURSOR csr_recon_exp_grp(c_recon_id IN NUMBER) IS