APPS.PN_TENANCIES_PKG dependencies on PN_LEASES_ALL

Line 109: FROM pn_leases_all

105: l_returnStatus VARCHAR2(30) := NULL;
106:
107: CURSOR org_cur IS
108: SELECT org_id
109: FROM pn_leases_all
110: WHERE lease_id = x_lease_id;
111:
112: l_org_id NUMBER;
113:

Line 953: FROM pn_leases_all pnl

949: l_LeaseId NUMBER := NULL;
950:
951: CURSOR org_cur IS
952: SELECT org_id
953: FROM pn_leases_all pnl
954: WHERE pnl.lease_id = x_lease_id;
955:
956: l_org_id NUMBER;
957:

Line 975: FROM pn_leases_all pnl

971:
972: -- we need to find IF the lease has a master lease defined
973: SELECT pnl.parent_lease_id
974: INTO l_parentLeaseId
975: FROM pn_leases_all pnl
976: WHERE pnl.lease_id = x_lease_id;
977:
978: ----------------------------------------------------------------
979: -- i.e. no master lease has been defined THEN it's a vanilla lease

Line 1030: FROM pn_leases_all

1026: BEGIN
1027:
1028: SELECT lease_num
1029: INTO l_leaseNumber
1030: FROM pn_leases_all
1031: WHERE lease_id <> x_lease_id
1032: AND parent_lease_id IS NULL
1033: AND lease_id =
1034: (SELECT lease_id

Line 1082: FROM pn_leases_all

1078: -- with dates IN su-leases for this lease
1079:
1080: SELECT lease_num
1081: INTO l_leaseNumber
1082: FROM pn_leases_all
1083: WHERE parent_lease_id = x_lease_id
1084: AND lease_id =
1085: (SELECT lease_id
1086: FROM pn_tenancies_all pnt

Line 1167: FROM pn_leases_all

1163:
1164: BEGIN
1165: SELECT lease_num
1166: INTO l_leaseNumber
1167: FROM pn_leases_all
1168: WHERE lease_id =
1169: (SELECT lease_id
1170: FROM pn_tenancies_all pnt
1171: WHERE pnt.status = 'A'

Line 1906: FROM pn_leases_all pnl,

1902: CURSOR csr_assign_exists IS
1903: SELECT 'Y'
1904: FROM DUAl
1905: WHERE EXISTS (SELECT NULL
1906: FROM pn_leases_all pnl,
1907: pn_tenancies_all ten
1908: WHERE pnl.lease_id <> p_lease_id
1909: AND pnl.lease_class_code <> 'DIRECT'
1910: AND pnl.lease_id = ten.lease_id

Line 1936: FROM pn_leases_all pnl

1932: l_auto_space_assign VARCHAR2(30);
1933:
1934: CURSOR org_cur IS
1935: SELECT org_id
1936: FROM pn_leases_all pnl
1937: WHERE pnl.lease_id = p_lease_id;
1938:
1939: l_org_id NUMBER;
1940:

Line 2049: FROM pn_leases_all pnl

2045: l_auto_space_dist VARCHAR2(20) := NULL;
2046:
2047: CURSOR org_cur IS
2048: SELECT org_id
2049: FROM pn_leases_all pnl
2050: WHERE pnl.lease_id = p_lease_id;
2051:
2052: l_org_id NUMBER;
2053:

Line 3096: FROM pn_leases_all leases,

3092:
3093: CURSOR cur_lease_code IS
3094: SELECT leases.lease_class_code lease_code,
3095: allocated_area_pct
3096: FROM pn_leases_all leases,
3097: pn_tenancies_all tenant
3098: WHERE leases.lease_id = tenant.lease_id
3099: AND tenant.tenancy_id = p_tenancy_id;
3100:

Line 3148: FROM pn_leases_all leases,

3144:
3145: CURSOR get_lease_class IS
3146: SELECT leases.lease_class_code lease_code,
3147: allocated_area
3148: FROM pn_leases_all leases,
3149: pn_tenancies_all tenant
3150: WHERE leases.lease_id = tenant.lease_id
3151: AND tenant.tenancy_id = p_tenancy_id;
3152: