48: FROM pn_leases_all pl
49: , pn_tenancies_all pt
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
49: , pn_tenancies_all pt
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
79: FROM pn_leases_all pl
80: , pn_tenancies_all pt
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
80: , pn_tenancies_all pt
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
110: FROM pn_leases_all pl
111: , pn_tenancies_all pt
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
111: , pn_tenancies_all pt
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
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
339: AND prop.property_id(+) = pl.property_id
340: AND NVL (pt.occupancy_date
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
339: AND prop.property_id(+) = pl.property_id
340: AND NVL (pt.occupancy_date
341: , pt.estimated_occupancy_date
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
359: AND prop.property_id(+) = pl.property_id
360: AND NVL (pt.occupancy_date
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
359: AND prop.property_id(+) = pl.property_id
360: AND NVL (pt.occupancy_date
361: , pt.estimated_occupancy_date
440: CURSOR c_lookup_type
441: IS
442: SELECT meaning
443: , lookup_code
444: FROM fnd_lookups
445: WHERE lookup_type = p_lookup_type
446: AND meaning = x_lookup_meaning
447: AND enabled_flag = 'Y'
448: AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (start_date_active
454: CURSOR c_lookup_code
455: IS
456: SELECT meaning
457: , lookup_code
458: FROM fnd_lookups
459: WHERE lookup_type = p_lookup_type
460: AND lookup_code = x_lookup_code
461: AND enabled_flag = 'Y'
462: AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (start_date_active
771: -- The below SQL has been commented and a new SQL has been added by Vivek on 02-DEC-2010
772: /*
773: SELECT meaning
774: , lookup_code
775: FROM fnd_lookups
776: WHERE lookup_type = p_lookup_type --'PN_VAR_CALCULATION_METHOD'
777: AND ( UPPER (lookup_code) = UPPER (x_lookup_code)
778: OR UPPER (meaning) = UPPER (x_lookup_meaning))
779: AND enabled_flag = 'Y'
785: ));
786: */
787: SELECT meaning
788: , lookup_code
789: FROM fnd_lookups
790: WHERE lookup_type = p_lookup_type --'PN_VAR_CALCULATION_METHOD'
791: AND ( UPPER (lookup_code) = UPPER (NVL(x_lookup_code,lookup_code))
792: AND UPPER (meaning) = UPPER (NVL(x_lookup_meaning,meaning)))
793: AND enabled_flag = 'Y'