DBA Data[Home] [Help]

APPS.PN_OPEX_TERMS_PKG dependencies on PN_PROPERTIES_ALL

Line 2123: -- PN_PROPERTIES_ALL

2119: -- 15-MAY-2007 sdmahesh o Bug # 6039220
2120: -- Changed the order of concurrent program
2121: -- parameters
2122: -- Modifed CURSOR opex_recs w.r.t. join with
2123: -- PN_PROPERTIES_ALL
2124: -- 23-MAY-07 sdmahesh o Bug 6069029
2125: -- Modifed CURSOR OPEX_RECS w.r.t. join with
2126: -- PN_PROPERTIES_ALL.Used PN_OPEX_TERMS_PKG.GET_PROP_ID
2127: -------------------------------------------------------------------------------

Line 2126: -- PN_PROPERTIES_ALL.Used PN_OPEX_TERMS_PKG.GET_PROP_ID

2122: -- Modifed CURSOR opex_recs w.r.t. join with
2123: -- PN_PROPERTIES_ALL
2124: -- 23-MAY-07 sdmahesh o Bug 6069029
2125: -- Modifed CURSOR OPEX_RECS w.r.t. join with
2126: -- PN_PROPERTIES_ALL.Used PN_OPEX_TERMS_PKG.GET_PROP_ID
2127: -------------------------------------------------------------------------------
2128:
2129: PROCEDURE approve_opex_pay_term_batch (
2130: errbuf OUT NOCOPY VARCHAR2

Line 2178: pn_properties_all prop,

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
2181: WHERE pl.lease_id = popex.lease_id
2182: AND popex.agreement_id = ppt.opex_agr_id