APPS.PN_TENANCIES_PKG dependencies on PN_REC_ARCL_DTL_ALL

Line 1311: FROM pn_rec_arcl_dtl_all mst,

1307: WHERE EXISTS (SELECT NULL
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

Line 1331: FROM pn_rec_arcl_dtl_all mst,

1327: WHERE spc.tenancy_id = p_tenancy_id
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