APPS.PN_RECOVERY_TENANCY_UPG_PKG dependencies on PN_SPACE_ASSIGN_CUST_ALL

Line 56: FROM pn_space_assign_cust_all psc

52: AND pl.lease_num <= NVL(p_lease_num_to, pl.lease_num)
53: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)
54: AND pl.lease_class_code IN ('SUB_LEASE', 'THIRD_PARTY')
55: AND NOT EXISTS (SELECT NULL
56: FROM pn_space_assign_cust_all psc
57: WHERE psc.tenancy_id = pt.tenancy_id);
58:
59: TYPE t_tenancy_id IS
60: TABLE OF PN_TENANCIES_ALL.TENANCY_ID%TYPE

Line 311: -- Returns true IF a row exists in pn_space_assign_cust_all for a tenancy_id

307: --
308: -- HISTORY
309: -- 19-Jun-2003 Pooja Sidhu o Created.
310: --
311: -- Returns true IF a row exists in pn_space_assign_cust_all for a tenancy_id
312: --
313: ---------------------------------------------------------------------------
314: FUNCTION cust_space_assign_exists(p_tenancy_id NUMBER)
315: RETURN BOOLEAN

Line 319: FROM pn_space_assign_cust_all

315: RETURN BOOLEAN
316: IS
317: CURSOR c_exists IS
318: SELECT 'Y'
319: FROM pn_space_assign_cust_all
320: WHERE tenancy_id = p_tenancy_id
321: AND rownum = 1;
322:
323: l_exists VARCHAR2(1) := 'N';