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 1780: DELETE FROM PN_OPEX_AGREEMENTS_ALL

1776:
1777: DELETE FROM PN_PAYMENT_TERMS_ALL
1778: WHERE opex_agr_id = p_agreement_id;
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;

Line 2145: pn_opex_agreements_all popex,

2141: prop.property_id,
2142: loc.location_code,
2143: popex.created_by
2144: FROM pn_leases_all pl,
2145: pn_opex_agreements_all popex,
2146: pn_payment_terms_all ppt,
2147: pn_properties_all prop,
2148: pn_locations_all loc,
2149: pn_tenancies_all ten