APPS.WF_DIRECTORY dependencies on WF_DIRECTORY_PARTITIONS

Line 4488: FROM WF_DIRECTORY_PARTITIONS

4484: /* We will place PER in FND_USR */
4485:
4486: SELECT Partition_ID, orig_system
4487: INTO g_partitionID, g_partitionName
4488: FROM WF_DIRECTORY_PARTITIONS
4489: WHERE ORIG_SYSTEM = DECODE(g_origSystem, 'PER', 'FND_USR',
4490: g_origSystem)
4491: AND PARTITION_ID IS NOT NULL;
4492:

Line 4503: FROM WF_DIRECTORY_PARTITIONS

4499: if (g_localPartitionID is NULL) then
4500: begin
4501: SELECT Partition_ID, orig_system
4502: INTO g_localPartitionID, g_localPartitionName
4503: FROM WF_DIRECTORY_PARTITIONS
4504: WHERE ORIG_SYSTEM = 'WF_LOCAL_ROLES';
4505:
4506: exception
4507: when NO_DATA_FOUND then

Line 4744: --package we query from wf_directory_partitions directly.

4740: end if;
4741:
4742: --We can use the global variable set in wf_local.syncroles
4743: --but for standalone so as not to introduce dependency on WF_LOCAL
4744: --package we query from wf_directory_partitions directly.
4745: select count(1)
4746: into mls_enabled
4747: from wf_directory_partitions
4748: where orig_system = l_origSys

Line 4747: from wf_directory_partitions

4743: --but for standalone so as not to introduce dependency on WF_LOCAL
4744: --package we query from wf_directory_partitions directly.
4745: select count(1)
4746: into mls_enabled
4747: from wf_directory_partitions
4748: where orig_system = l_origSys
4749: and ROLE_TL_VIEW is not NULL ;
4750: if (mls_enabled = 1) then
4751: return TRUE;