APPS.PNP_UTIL_FUNC dependencies on PN_TENANCIES_ALL

Line 1580: pn_tenancies_all pnt

1576: p_as_of_date IN DATE ) IS
1577:
1578: (SELECT NVL(SUM(pnl.RENTABLE_AREA),0) AS Area
1579: FROM pn_locations_all pnl,
1580: pn_tenancies_all pnt
1581: WHERE pnt.lease_id = p_leaseId
1582: AND pnt.status = 'A'
1583: AND pnl.location_id = pnt.location_id
1584: AND p_as_of_date BETWEEN pnl.active_start_date AND pnl.active_end_date

Line 7765: from pn_tenancies_all

7761: SELECT 'Y'
7762: FROM dual
7763: WHERE exists
7764: (select tenancy_id
7765: from pn_tenancies_all
7766: where location_id in
7767: (select loc.location_id
7768: from pn_locations_all loc
7769: connect by prior loc.location_id = loc.parent_location_id

Line 7811: from pn_tenancies_all

7807: SELECT 'Y'
7808: FROM dual
7809: WHERE exists
7810: (select tenancy_id
7811: from pn_tenancies_all
7812: where location_id in
7813: (select loc.location_id
7814: from pn_locations_all loc
7815: connect by prior loc.location_id = loc.parent_location_id

Line 7945: FROM pn_tenancies_all tnc

7941: -- that payment term dates has to lie between tenancy dates
7942:
7943: CURSOR get_assoc_payment_terms_w_type IS
7944: SELECT 'Y' answer
7945: FROM pn_tenancies_all tnc
7946: WHERE tnc.tenancy_id = p_tenancy_id
7947: AND EXISTS (SELECT 'Y' FROM pn_payment_terms_all trm
7948: WHERE trm.lease_id = tnc.lease_id
7949: AND trm.location_id = tnc.location_id

Line 7954: FROM pn_tenancies_all tnc

7950: AND trm.area_type_code = p_type);
7951:
7952: CURSOR get_assoc_payment_terms IS
7953: SELECT 'Y' answer
7954: FROM pn_tenancies_all tnc
7955: WHERE tnc.tenancy_id = p_tenancy_id
7956: AND EXISTS (SELECT 'Y' FROM pn_payment_terms_all trm
7957: WHERE trm.lease_id = tnc.lease_id
7958: AND trm.location_id = tnc.location_id);

Line 8018: FROM pn_tenancies_all

8014: estimated_occupancy_date,
8015: occupancy_date,
8016: expiration_date,
8017: location_id
8018: FROM pn_tenancies_all
8019: WHERE tenancy_id = p_tenancy_id;
8020:
8021: CURSOR get_affected_payment_terms (p_loc_id NUMBER, p_occ_date DATE, p_exp_date DATE) IS
8022: SELECT trm.area_type_code,

Line 8130: FROM pn_tenancies_all

8126: p_as_of_date DATE) RETURN NUMBER
8127: IS
8128: CURSOR get_share IS
8129: SELECT allocated_area_pct share_pct /* 8819189 */
8130: FROM pn_tenancies_all
8131: WHERE location_id = p_location_id
8132: AND lease_id = p_lease_id
8133: AND p_as_of_date BETWEEN nvl(occupancy_date, estimated_occupancy_date)
8134: AND expiration_date;

Line 8168: FROM pn_tenancies_all tnc

8164: CURSOR get_tenancy_info IS
8165: SELECT sum(tnc.lease_assignable_area) lease_assignable_area,
8166: sum(tnc.lease_rentable_area) lease_rentable_area,
8167: sum(tnc.lease_usable_area) lease_usable_area
8168: FROM pn_tenancies_all tnc
8169: WHERE tnc.lease_id = p_lease_id
8170: AND tnc.location_id = p_location_id
8171: AND p_as_of_date BETWEEN nvl(tnc.occupancy_date, tnc.estimated_occupancy_date) AND tnc.expiration_date;
8172:

Line 8908: FROM pn_tenancies_all

8904: l_location_name_rec location_name_rec;
8905:
8906: CURSOR get_loc_cur(p_lease_id NUMBER) IS
8907: SELECT location_id
8908: FROM pn_tenancies_all
8909: WHERE lease_id = p_lease_id
8910: AND NVL(primary_flag ,'N') = 'Y'
8911: AND ROWNUM < 2;
8912:

Line 8952: FROM pn_tenancies_all

8948: l_location_name_rec location_name_rec;
8949:
8950: CURSOR get_loc_cur(p_lease_id NUMBER) IS
8951: SELECT location_id
8952: FROM pn_tenancies_all
8953: WHERE lease_id = p_lease_id
8954: AND NVL(primary_flag ,'N') = 'Y'
8955: AND ROWNUM < 2;
8956:

Line 8996: FROM pn_tenancies_all

8992: l_location_name_rec location_name_rec;
8993:
8994: CURSOR get_loc_cur(p_lease_id NUMBER) IS
8995: SELECT location_id
8996: FROM pn_tenancies_all
8997: WHERE lease_id = p_lease_id
8998: AND NVL(primary_flag ,'N') = 'Y'
8999: AND ROWNUM < 2;
9000: