APPS.PN_OPEX_TERMS_PKG dependencies on PN_OPEX_AGREEMENTS_ALL

Line 53: FROM pn_opex_agreements_all agr,

49:
50: CURSOR agreement_cur(agr_id IN NUMBER)
51: IS
52: SELECT agr.* , loc.location_id
53: FROM pn_opex_agreements_all agr,
54: pn_locations_all loc,
55: pn_tenancies_all ten
56: WHERE agreement_id = agr_id
57: AND agr.tenancy_id = ten.tenancy_id

Line 653: FROM pn_opex_agreements_all agr,

649:
650: CURSOR agreement_cur(agr_id IN NUMBER)
651: IS
652: SELECT agr.* , loc.location_id
653: FROM pn_opex_agreements_all agr,
654: pn_locations_all loc,
655: pn_tenancies_all ten
656: WHERE agreement_id = agr_id
657: AND agr.tenancy_id = ten.tenancy_id

Line 1809: DELETE FROM PN_OPEX_AGREEMENTS_ALL

1805:
1806: DELETE FROM PN_PAYMENT_TERMS_ALL
1807: WHERE opex_agr_id = p_agreement_id;
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;

Line 2176: pn_opex_agreements_all popex,

2172: prop.property_id,
2173: loc.location_code,
2174: popex.created_by
2175: FROM pn_leases_all pl,
2176: pn_opex_agreements_all popex,
2177: pn_payment_terms_all ppt,
2178: pn_properties_all prop,
2179: pn_locations_all loc,
2180: pn_tenancies_all ten