APPS.PN_OPEX_TERMS_PKG dependencies on PN_OPEX_RECON_ALL

Line 1522: FROM (SELECT recon_id FROM pn_opex_recon_all

1518: RETURN NULL;
1519: ELSE
1520: BEGIN
1521: SELECT * INTO x_recon_id
1522: FROM (SELECT recon_id FROM pn_opex_recon_all
1523: WHERE agreement_id = agr_id
1524: ORDER BY period_end_dt DESC , revision_number DESC)
1525: WHERE ROWNUM = 1 ;
1526: EXCEPTION

Line 1633: pn_opex_recon_all

1629:
1630: CURSOR recon_cur(p_recon_id IN NUMBER)
1631: IS
1632: SELECT * FROM
1633: pn_opex_recon_all
1634: WHERE recon_id = p_recon_id;
1635:
1636: st_due_rec st_due_cur%ROWTYPE;
1637: recon_rec recon_cur%ROWTYPE;

Line 1760: pn_opex_recon_all WHERE agreement_id = p_agreement_id) LOOP

1756:
1757: -- Deleting reconciliation tables
1758:
1759: FOR i IN (SELECT recon_id FROM
1760: pn_opex_recon_all WHERE agreement_id = p_agreement_id) LOOP
1761: DELETE FROM PN_OPEX_RECON_CRDT_ALL
1762: WHERE recon_id = i.recon_id;
1763:
1764: DELETE FROM PN_OPEX_RECON_PRTBS_ALL

Line 1783: DELETE FROM PN_OPEX_RECON_ALL

1779:
1780: DELETE FROM PN_OPEX_AGREEMENTS_ALL
1781: WHERE agreement_id = p_agreement_id;
1782:
1783: DELETE FROM PN_OPEX_RECON_ALL
1784: WHERE agreement_id = p_agreement_id;
1785:
1786: DELETE FROM PN_OPEX_EST_PAYMENTS_ALL
1787: WHERE agreement_id = p_agreement_id;

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

1805: ten_tot_crg NUMBER;
1806: pct_change NUMBER;
1807: begin
1808: begin
1809: select recon_id , ten_tot_charge INTO rec_id,ten_tot_crg FROM pn_opex_recon_all WHERE
1810: agreement_id = p_agr_id
1811: AND period_end_dt + 1 = p_period_start_dt
1812: AND current_flag = 'Y';
1813: EXCEPTION

Line 2321: pn_opex_recon_all recon

2317:
2318: SELECT SUM(item.actual_amount) act_amt
2319: FROM pn_payment_items_all item,
2320: pn_payment_terms_all term,
2321: pn_opex_recon_all recon
2322: WHERE item.payment_item_type_lookup_code = 'CASH'
2323: AND item.payment_term_id = term.payment_term_id
2324: AND term.opex_recon_id = recon.recon_id
2325: AND recon.recon_id = c_recon_id ;

Line 2329: pn_opex_recon_all WHERE recon_id = c_recon_id;

2325: AND recon.recon_id = c_recon_id ;
2326:
2327: CURSOR recon_cur(c_recon_id IN NUMBER) IS
2328: SELECT * FROM
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