APPS.PN_OPEX_TERMS_PKG dependencies on PN_OPEX_RECON_ALL

Line 1551: FROM (SELECT recon_id FROM pn_opex_recon_all

1547: RETURN NULL;
1548: ELSE
1549: BEGIN
1550: SELECT * INTO x_recon_id
1551: FROM (SELECT recon_id FROM pn_opex_recon_all
1552: WHERE agreement_id = agr_id
1553: ORDER BY period_end_dt DESC , revision_number DESC)
1554: WHERE ROWNUM = 1 ;
1555: EXCEPTION

Line 1662: pn_opex_recon_all

1658:
1659: CURSOR recon_cur(p_recon_id IN NUMBER)
1660: IS
1661: SELECT * FROM
1662: pn_opex_recon_all
1663: WHERE recon_id = p_recon_id;
1664:
1665: st_due_rec st_due_cur%ROWTYPE;
1666: recon_rec recon_cur%ROWTYPE;

Line 1789: pn_opex_recon_all WHERE agreement_id = p_agreement_id) LOOP

1785:
1786: -- Deleting reconciliation tables
1787:
1788: FOR i IN (SELECT recon_id FROM
1789: pn_opex_recon_all WHERE agreement_id = p_agreement_id) LOOP
1790: DELETE FROM PN_OPEX_RECON_CRDT_ALL
1791: WHERE recon_id = i.recon_id;
1792:
1793: DELETE FROM PN_OPEX_RECON_PRTBS_ALL

Line 1812: DELETE FROM PN_OPEX_RECON_ALL

1808:
1809: DELETE FROM PN_OPEX_AGREEMENTS_ALL
1810: WHERE agreement_id = p_agreement_id;
1811:
1812: DELETE FROM PN_OPEX_RECON_ALL
1813: WHERE agreement_id = p_agreement_id;
1814:
1815: DELETE FROM PN_OPEX_EST_PAYMENTS_ALL
1816: WHERE agreement_id = p_agreement_id;

Line 1839: select recon_id , ten_tot_charge INTO rec_id,ten_tot_crg FROM pn_opex_recon_all WHERE

1835: pct_change NUMBER;
1836: begin
1837: begin
1838: --Fix for bug#13335165 in R12, added recon_id to the Where condition
1839: select recon_id , ten_tot_charge INTO rec_id,ten_tot_crg FROM pn_opex_recon_all WHERE
1840: agreement_id = p_agr_id
1841: AND recon_id = p_recon_id
1842: AND period_end_dt + 1 = p_period_start_dt
1843: AND current_flag = 'Y';

Line 2352: pn_opex_recon_all recon

2348:
2349: SELECT SUM(item.actual_amount) act_amt
2350: FROM pn_payment_items_all item,
2351: pn_payment_terms_all term,
2352: pn_opex_recon_all recon
2353: WHERE item.payment_item_type_lookup_code = 'CASH'
2354: AND item.payment_term_id = term.payment_term_id
2355: AND term.opex_recon_id = recon.recon_id
2356: AND recon.recon_id = c_recon_id ;

Line 2360: pn_opex_recon_all WHERE recon_id = c_recon_id;

2356: AND recon.recon_id = c_recon_id ;
2357:
2358: CURSOR recon_cur(c_recon_id IN NUMBER) IS
2359: SELECT * FROM
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