APPS.PN_INDEX_RENT_UTILS dependencies on FND_LOOKUPS

Line 411: , fnd_lookups LOC_LKP

407: IS
408: SELECT PT.location_id
409: FROM pn_tenancies_all PT
410: , pn_locations_all PL
411: , fnd_lookups LOC_LKP
412: , fnd_lookups FLG_LKP
413: WHERE PT.location_id = PL.location_id
414: AND PL.org_id = p_org_id
415: AND NVL(PT.occupancy_date, PT.estimated_occupancy_date)

Line 412: , fnd_lookups FLG_LKP

408: SELECT PT.location_id
409: FROM pn_tenancies_all PT
410: , pn_locations_all PL
411: , fnd_lookups LOC_LKP
412: , fnd_lookups FLG_LKP
413: WHERE PT.location_id = PL.location_id
414: AND PL.org_id = p_org_id
415: AND NVL(PT.occupancy_date, PT.estimated_occupancy_date)
416: BETWEEN PL.active_start_date

Line 431: , fnd_lookups LOC_LKP

427: IS
428: SELECT PT.location_id
429: FROM pn_tenancies_all PT
430: , pn_locations_all PL
431: , fnd_lookups LOC_LKP
432: , fnd_lookups FLG_LKP
433: WHERE PT.location_id = PL.location_id
434: AND PL.org_id = p_org_id
435: AND NVL(PT.occupancy_date, PT.estimated_occupancy_date)

Line 432: , fnd_lookups FLG_LKP

428: SELECT PT.location_id
429: FROM pn_tenancies_all PT
430: , pn_locations_all PL
431: , fnd_lookups LOC_LKP
432: , fnd_lookups FLG_LKP
433: WHERE PT.location_id = PL.location_id
434: AND PL.org_id = p_org_id
435: AND NVL(PT.occupancy_date, PT.estimated_occupancy_date)
436: BETWEEN PL.active_start_date

Line 785: FROM fnd_lookups LOOK

781:
782: CURSOR c_lookup
783: IS
784: SELECT DISTINCT LOOK.lookup_code lookup_code
785: FROM fnd_lookups LOOK
786: ,pn_payment_terms_all TERMS
787: WHERE LOOK.lookup_type = 'PN_PAYMENT_TERM_TYPE'
788: AND LOOK.enabled_flag = 'Y'
789: AND TERMS.lease_id = p_lease_id

Line 799: FROM fnd_lookups LOOK

795:
796: CURSOR c_lookup_code
797: IS
798: SELECT DISTINCT LOOK.lookup_code lookup_code
799: FROM fnd_lookups LOOK
800: ,pn_payment_terms_all TERMS
801: WHERE LOOK.lookup_type = 'PN_PAYMENT_TERM_TYPE'
802: AND LOOK.enabled_flag = 'Y'
803: AND TERMS.lease_id = p_lease_id