APPS.PN_LEASE_PVT dependencies on PN_TENANCIES_ALL

Line 209: From pn_tenancies_all

205: recovery_space_std_code,
206: recovery_type_code,
207: fin_oblig_end_date,
208: allocated_area_pct
209: From pn_tenancies_all
210: Where tenancy_id = p_tenancy_id;
211: c_loc_rec c_loc%ROWTYPE;
212:
213: PROCEDURE Create_Space_Assign( p_lease_tenancies_rec IN lease_tenancies_rec

Line 1485: FROM pn_tenancies_all

1481: CURSOR cur_tenancies_details (
1482: p_tenancy_id NUMBER)
1483: IS
1484: SELECT *
1485: FROM pn_tenancies_all
1486: WHERE tenancy_id = p_tenancy_id;
1487:
1488: l_api_version CONSTANT NUMBER := 1.0;
1489: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Tenancies';

Line 2948: -- l_location_id pn_tenancies_all.location_id%TYPE;

2944: -- l_lastUpdateDate DATE := NULL;
2945: -- l_creationDate DATE := NULL;
2946: -- l_tenancy_ovelap_wrn VARCHAR2(30) := NULL;
2947: -- l_message VARCHAR2(30) := NULL; --CAM
2948: -- l_location_id pn_tenancies_all.location_id%TYPE;
2949: -- l_customer_id pn_tenancies_all.customer_id%TYPE;
2950: -- l_customer_site_use_id pn_tenancies_all.customer_site_use_id%TYPE;
2951: -- l_org_id NUMBER;
2952: -- l_allocated_area NUMBER;

Line 2949: -- l_customer_id pn_tenancies_all.customer_id%TYPE;

2945: -- l_creationDate DATE := NULL;
2946: -- l_tenancy_ovelap_wrn VARCHAR2(30) := NULL;
2947: -- l_message VARCHAR2(30) := NULL; --CAM
2948: -- l_location_id pn_tenancies_all.location_id%TYPE;
2949: -- l_customer_id pn_tenancies_all.customer_id%TYPE;
2950: -- l_customer_site_use_id pn_tenancies_all.customer_site_use_id%TYPE;
2951: -- l_org_id NUMBER;
2952: -- l_allocated_area NUMBER;
2953: l_loc_area NUMBER;

Line 2950: -- l_customer_site_use_id pn_tenancies_all.customer_site_use_id%TYPE;

2946: -- l_tenancy_ovelap_wrn VARCHAR2(30) := NULL;
2947: -- l_message VARCHAR2(30) := NULL; --CAM
2948: -- l_location_id pn_tenancies_all.location_id%TYPE;
2949: -- l_customer_id pn_tenancies_all.customer_id%TYPE;
2950: -- l_customer_site_use_id pn_tenancies_all.customer_site_use_id%TYPE;
2951: -- l_org_id NUMBER;
2952: -- l_allocated_area NUMBER;
2953: l_loc_area NUMBER;
2954: l_min_pct NUMBER;

Line 13207: FROM pn_tenancies_all

13203:
13204: BEGIN
13205: SELECT tenancy_id
13206: INTO l_tenancy_id
13207: FROM pn_tenancies_all
13208: WHERE lease_id = l_lease_hdr_rec.lease_id
13209: AND org_id = g_org_id;
13210:
13211: ----------dbms_output.put_line('l_tenancy_id'||l_tenancy_id||x_return_status);

Line 17889: FROM pn_tenancies_all

17885: END IF;
17886: BEGIN
17887: SELECT COUNT(1)
17888: INTO l_locations_count
17889: FROM pn_tenancies_all
17890: WHERE lease_id = p_lease_id
17891: AND org_id = g_org_id;
17892: EXCEPTION
17893: WHEN OTHERS THEN

Line 18662: FROM pn_tenancies_ALL

18658: )
18659: IS SELECT 'Y'
18660: FROM dual
18661: WHERE EXISTS (SELECT 1
18662: FROM pn_tenancies_ALL
18663: WHERE lease_id= p_lease_id
18664: AND org_id = g_org_id
18665: );
18666: