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 2144: FROM pn_leases_all pl,

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