APPS.WF_ROLE_HIERARCHY dependencies on WF_DIRECTORY_PARTITIONS

Line 117: FROM WF_DIRECTORY_PARTITIONS

113: --set to 'NOBS' or if the partition is not registered, we return true.
114: begin
115: SELECT ROLE_VIEW
116: INTO l_viewName
117: FROM WF_DIRECTORY_PARTITIONS
118: WHERE ORIG_SYSTEM = UPPER(p_origSystem)
119: AND PARTITION_ID <> 0 --
120: AND (ROLE_VIEW is NULL
121: or ROLE_VIEW <> 'NOBS');