APPS.PNRX_RENT_LES dependencies on FND_LOOKUPS

Line 354: fnd_lookups fnd,

350: ldet.created_by CREATED_BY,
351: les.payment_term_proration_rule PRORATION_RULE -- added for bug#2102098
352: FROM pn_lease_details ldet,
353: pn_tenancies_all ten,
354: fnd_lookups fnd,
355: fnd_lookups fnd1,
356: fnd_lookups fnd2,
357: fnd_lookups fnd3,
358: fnd_user fnd4,

Line 355: fnd_lookups fnd1,

351: les.payment_term_proration_rule PRORATION_RULE -- added for bug#2102098
352: FROM pn_lease_details ldet,
353: pn_tenancies_all ten,
354: fnd_lookups fnd,
355: fnd_lookups fnd1,
356: fnd_lookups fnd2,
357: fnd_lookups fnd3,
358: fnd_user fnd4,
359: pn_leases_all les

Line 356: fnd_lookups fnd2,

352: FROM pn_lease_details ldet,
353: pn_tenancies_all ten,
354: fnd_lookups fnd,
355: fnd_lookups fnd1,
356: fnd_lookups fnd2,
357: fnd_lookups fnd3,
358: fnd_user fnd4,
359: pn_leases_all les
360: WHERE ten.lease_id = les.lease_id

Line 357: fnd_lookups fnd3,

353: pn_tenancies_all ten,
354: fnd_lookups fnd,
355: fnd_lookups fnd1,
356: fnd_lookups fnd2,
357: fnd_lookups fnd3,
358: fnd_user fnd4,
359: pn_leases_all les
360: WHERE ten.lease_id = les.lease_id
361: AND les.lease_id = ldet.lease_id

Line 561: fnd_lookups fnd,

557: loc.gross_area GROSS_AREA,
558: fnd.meaning TENURE
559: FROM pn_locations_all loc,
560: pn_addresses_all pa,
561: fnd_lookups fnd,
562: fnd_lookups fnd1
563: WHERE pa.address_id(+) = loc.address_id
564: AND loc.lease_or_owned = fnd.lookup_code(+)
565: AND fnd.lookup_type(+) = 'PN_LEASED_OR_OWNED'

Line 562: fnd_lookups fnd1

558: fnd.meaning TENURE
559: FROM pn_locations_all loc,
560: pn_addresses_all pa,
561: fnd_lookups fnd,
562: fnd_lookups fnd1
563: WHERE pa.address_id(+) = loc.address_id
564: AND loc.lease_or_owned = fnd.lookup_code(+)
565: AND fnd.lookup_type(+) = 'PN_LEASED_OR_OWNED'
566: AND fnd1.lookup_code(+) = loc.location_type_lookup_code