APPS.PNP_UTIL_FUNC dependencies on PN_TENANCIES_ALL

Line 1425: pn_tenancies_all pnt

1421: p_as_of_date IN DATE ) IS
1422:
1423: (SELECT NVL(SUM(pnl.RENTABLE_AREA),0) AS Area
1424: FROM pn_locations_all pnl,
1425: pn_tenancies_all pnt
1426: WHERE pnt.lease_id = p_leaseId
1427: AND pnt.status = 'A'
1428: AND pnl.location_id = pnt.location_id
1429: AND p_as_of_date BETWEEN pnl.active_start_date AND pnl.active_end_date

Line 7598: from pn_tenancies_all

7594: SELECT 'Y'
7595: FROM dual
7596: WHERE exists
7597: (select tenancy_id
7598: from pn_tenancies_all
7599: where location_id in
7600: (select loc.location_id
7601: from pn_locations_all loc
7602: connect by prior loc.location_id = loc.parent_location_id

Line 7644: from pn_tenancies_all

7640: SELECT 'Y'
7641: FROM dual
7642: WHERE exists
7643: (select tenancy_id
7644: from pn_tenancies_all
7645: where location_id in
7646: (select loc.location_id
7647: from pn_locations_all loc
7648: connect by prior loc.location_id = loc.parent_location_id

Line 7778: FROM pn_tenancies_all tnc

7774: -- that payment term dates has to lie between tenancy dates
7775:
7776: CURSOR get_assoc_payment_terms_w_type IS
7777: SELECT 'Y' answer
7778: FROM pn_tenancies_all tnc
7779: WHERE tnc.tenancy_id = p_tenancy_id
7780: AND EXISTS (SELECT 'Y' FROM pn_payment_terms_all trm
7781: WHERE trm.lease_id = tnc.lease_id
7782: AND trm.location_id = tnc.location_id

Line 7787: FROM pn_tenancies_all tnc

7783: AND trm.area_type_code = p_type);
7784:
7785: CURSOR get_assoc_payment_terms IS
7786: SELECT 'Y' answer
7787: FROM pn_tenancies_all tnc
7788: WHERE tnc.tenancy_id = p_tenancy_id
7789: AND EXISTS (SELECT 'Y' FROM pn_payment_terms_all trm
7790: WHERE trm.lease_id = tnc.lease_id
7791: AND trm.location_id = tnc.location_id);

Line 7851: FROM pn_tenancies_all

7847: estimated_occupancy_date,
7848: occupancy_date,
7849: expiration_date,
7850: location_id
7851: FROM pn_tenancies_all
7852: WHERE tenancy_id = p_tenancy_id;
7853:
7854: CURSOR get_affected_payment_terms (p_loc_id NUMBER, p_occ_date DATE, p_exp_date DATE) IS
7855: SELECT trm.area_type_code,

Line 7962: FROM pn_tenancies_all

7958: p_as_of_date DATE) RETURN NUMBER
7959: IS
7960: CURSOR get_share IS
7961: SELECT tenants_proportionate_share share_pct
7962: FROM pn_tenancies_all
7963: WHERE location_id = p_location_id
7964: AND lease_id = p_lease_id
7965: AND p_as_of_date BETWEEN nvl(occupancy_date, estimated_occupancy_date)
7966: AND expiration_date;

Line 8000: FROM pn_tenancies_all tnc

7996: CURSOR get_tenancy_info IS
7997: SELECT sum(tnc.lease_assignable_area) lease_assignable_area,
7998: sum(tnc.lease_rentable_area) lease_rentable_area,
7999: sum(tnc.lease_usable_area) lease_usable_area
8000: FROM pn_tenancies_all tnc
8001: WHERE tnc.lease_id = p_lease_id
8002: AND tnc.location_id = p_location_id
8003: AND p_as_of_date BETWEEN nvl(tnc.occupancy_date, tnc.estimated_occupancy_date) AND tnc.expiration_date;
8004:

Line 8730: FROM pn_tenancies_all

8726: l_location_name_rec location_name_rec;
8727:
8728: CURSOR get_loc_cur(p_lease_id NUMBER) IS
8729: SELECT location_id
8730: FROM pn_tenancies_all
8731: WHERE lease_id = p_lease_id
8732: AND NVL(primary_flag ,'N') = 'Y'
8733: AND ROWNUM < 2;
8734:

Line 8774: FROM pn_tenancies_all

8770: l_location_name_rec location_name_rec;
8771:
8772: CURSOR get_loc_cur(p_lease_id NUMBER) IS
8773: SELECT location_id
8774: FROM pn_tenancies_all
8775: WHERE lease_id = p_lease_id
8776: AND NVL(primary_flag ,'N') = 'Y'
8777: AND ROWNUM < 2;
8778:

Line 8818: FROM pn_tenancies_all

8814: l_location_name_rec location_name_rec;
8815:
8816: CURSOR get_loc_cur(p_lease_id NUMBER) IS
8817: SELECT location_id
8818: FROM pn_tenancies_all
8819: WHERE lease_id = p_lease_id
8820: AND NVL(primary_flag ,'N') = 'Y'
8821: AND ROWNUM < 2;
8822: