DBA Data[Home] [Help]

APPS.PN_OPEX_TERMS_PKG dependencies on PN_LEASES_ALL

Line 109: FROM pn_leases_all pl,

105: pl.org_id
106: INTO l_lease_class_code,
107: l_lease_change_id,
108: l_org_id
109: FROM pn_leases_all pl,
110: pn_lease_details_all pld
111: WHERE pl.lease_id = pld.lease_id
112: AND pld.lease_id = p_lease_id;
113:

Line 719: FROM pn_leases_all pl,

715: pl.org_id
716: INTO l_lease_class_code,
717: l_lease_change_id,
718: l_org_id
719: FROM pn_leases_all pl,
720: pn_lease_details_all pld
721: WHERE pl.lease_id = pld.lease_id
722: AND pld.lease_id = agreement_rec.lease_id;
723: EXCEPTION

Line 2175: FROM pn_leases_all pl,

2171: DECODE(ppt.normalize, 'Y', 'NORMALIZE') "NORMALIZE",
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,