APPS.PN_SCHEDULES_ITEMS dependencies on PN_REC_ARCL_DTLLN_ALL

Line 3037: pn_rec_arcl_dtlln_all dtl

3033: FROM pn_space_assign_cust_all psa
3034: WHERE psa.tenancy_id = p_tenancy_id
3035: AND (EXISTS (SELECT NULL
3036: FROM pn_rec_arcl_dtl_all mst,
3037: pn_rec_arcl_dtlln_all dtl
3038: WHERE mst.area_class_dtl_id = dtl.area_class_dtl_id
3039: AND mst.status = 'LOCKED'
3040: AND dtl.cust_space_assign_id = psa.cust_space_assign_id) OR
3041: EXISTS (SELECT NULL