APPS.PN_VAREN_UTIL dependencies on PN_LOCATIONS_ALL

Line 54: , pn_locations_all ploc

50: , pn_lease_details_all pld
51: , fnd_user fnr
52: , fnd_lookups lse_lkp
53: , fnd_lookups flg_lkp
54: , pn_locations_all ploc
55: , pn_properties_all prop
56: WHERE pt.lease_id(+) = pl.lease_id
57: AND ploc.location_id(+) = pt.location_id
58: AND prop.property_id(+) = ploc.property_id

Line 85: , pn_locations_all ploc

81: , pn_lease_details_all pld
82: , fnd_user fnr
83: , fnd_lookups lse_lkp
84: , fnd_lookups flg_lkp
85: , pn_locations_all ploc
86: , pn_properties_all prop
87: WHERE pt.lease_id(+) = pl.lease_id
88: AND ploc.location_id(+) = pt.location_id
89: AND prop.property_id(+) = ploc.property_id

Line 116: , pn_locations_all ploc

112: , pn_lease_details_all pld
113: , fnd_user fnr
114: , fnd_lookups lse_lkp
115: , fnd_lookups flg_lkp
116: , pn_locations_all ploc
117: , pn_properties_all prop
118: WHERE pt.lease_id(+) = pl.lease_id
119: AND ploc.location_id(+) = pt.location_id
120: AND prop.property_id(+) = ploc.property_id

Line 334: , pn_locations_all pl

330: CURSOR c_location_id
331: IS
332: SELECT pl.location_id
333: FROM pn_tenancies_all pt
334: , pn_locations_all pl
335: , pn_properties_all prop
336: , fnd_lookups loc_lkp
337: , fnd_lookups flg_lkp
338: WHERE pt.location_id = pl.location_id

Line 354: , pn_locations_all pl

350: CURSOR c_location_code
351: IS
352: SELECT pl.location_id
353: FROM pn_tenancies_all pt
354: , pn_locations_all pl
355: , pn_properties_all prop
356: , fnd_lookups loc_lkp
357: , fnd_lookups flg_lkp
358: WHERE pt.location_id = pl.location_id