DBA Data[Home] [Help]

APPS.PN_OPEX_TERMS_PKG dependencies on PN_PROPERTIES_ALL

Line 2092: -- PN_PROPERTIES_ALL

2088: -- 15-MAY-2007 sdmahesh o Bug # 6039220
2089: -- Changed the order of concurrent program
2090: -- parameters
2091: -- Modifed CURSOR opex_recs w.r.t. join with
2092: -- PN_PROPERTIES_ALL
2093: -- 23-MAY-07 sdmahesh o Bug 6069029
2094: -- Modifed CURSOR OPEX_RECS w.r.t. join with
2095: -- PN_PROPERTIES_ALL.Used PN_OPEX_TERMS_PKG.GET_PROP_ID
2096: -------------------------------------------------------------------------------

Line 2095: -- PN_PROPERTIES_ALL.Used PN_OPEX_TERMS_PKG.GET_PROP_ID

2091: -- Modifed CURSOR opex_recs w.r.t. join with
2092: -- PN_PROPERTIES_ALL
2093: -- 23-MAY-07 sdmahesh o Bug 6069029
2094: -- Modifed CURSOR OPEX_RECS w.r.t. join with
2095: -- PN_PROPERTIES_ALL.Used PN_OPEX_TERMS_PKG.GET_PROP_ID
2096: -------------------------------------------------------------------------------
2097:
2098: PROCEDURE approve_opex_pay_term_batch (
2099: errbuf OUT NOCOPY VARCHAR2

Line 2147: pn_properties_all prop,

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