APPS.PN_TENANCIES_PKG dependencies on PN_REC_ARCL_DTLLN_ALL

Line 1312: pn_rec_arcl_dtlln_all dtl

1308: FROM pn_space_assign_cust_all spc
1309: WHERE spc.tenancy_id = p_tenancy_id
1310: AND (EXISTS (SELECT NULL
1311: FROM pn_rec_arcl_dtl_all mst,
1312: pn_rec_arcl_dtlln_all dtl
1313: WHERE mst.area_class_dtl_id = dtl.area_class_dtl_id
1314: AND dtl.cust_space_assign_id = spc.cust_space_assign_id) OR
1315: EXISTS (SELECT NULL
1316: FROM pn_rec_expcl_dtl_all mst,

Line 1332: pn_rec_arcl_dtlln_all dtl

1328: AND (NVL(spc.cust_assign_end_date,p_cust_assign_end_dt) >= p_cust_assign_start_dt OR
1329: spc.cust_assign_start_date <= p_cust_assign_end_dt)
1330: AND (EXISTS (SELECT NULL
1331: FROM pn_rec_arcl_dtl_all mst,
1332: pn_rec_arcl_dtlln_all dtl
1333: WHERE mst.area_class_dtl_id = dtl.area_class_dtl_id
1334: AND mst.status = 'LOCKED'
1335: AND dtl.cust_space_assign_id = spc.cust_space_assign_id) OR
1336: EXISTS (SELECT NULL

Line 2203: DELETE FROM pn_rec_arcl_dtlln_all

2199: FROM pn_space_assign_cust_all
2200: WHERE tenancy_id = p_tenancy_id);
2201: l_count := SQL%ROWCOUNT;
2202:
2203: DELETE FROM pn_rec_arcl_dtlln_all
2204: WHERE cust_space_assign_id IN (SELECT cust_space_assign_id
2205: FROM pn_space_assign_cust_all
2206: WHERE tenancy_id = p_tenancy_id);
2207: l_count := SQL%ROWCOUNT + l_count;