APPS.WF_DIRECTORY dependencies on WF_DIRECTORY_PARTITIONS

Line 837: from wf_directory_partitions_vl

833:
834: select orig_system, display_name
835: into GetRolePartitionInfo.orig_system,
836: GetRolePartitionInfo.display_name
837: from wf_directory_partitions_vl
838: where GetRolePartitionInfo.partition_id <> 1
839: and partition_id = GetRolePartitionInfo.partition_id
840: or GetRolePartitionInfo.partition_id = 1
841: and orig_system = GetRolePartitionInfo.orig_system;

Line 865: from wf_directory_partitions_vl

861:
862: select orig_system, display_name
863: into GetRolePartitionInfo.orig_system,
864: GetRolePartitionInfo.display_name
865: from wf_directory_partitions_vl
866: where GetRolePartitionInfo.partition_id <> 1
867: and partition_id = GetRolePartitionInfo.partition_id
868: or GetRolePartitionInfo.partition_id = 1
869: and orig_system = GetRolePartitionInfo.orig_system;

Line 4638: FROM WF_DIRECTORY_PARTITIONS

4634: /* We will place PER in FND_USR */
4635:
4636: SELECT Partition_ID, orig_system
4637: INTO g_partitionID, g_partitionName
4638: FROM WF_DIRECTORY_PARTITIONS
4639: WHERE ORIG_SYSTEM = DECODE(g_origSystem, 'PER', 'FND_USR',
4640: g_origSystem)
4641: AND PARTITION_ID IS NOT NULL;
4642:

Line 4653: FROM WF_DIRECTORY_PARTITIONS

4649: if (g_localPartitionID is NULL) then
4650: begin
4651: SELECT Partition_ID, orig_system
4652: INTO g_localPartitionID, g_localPartitionName
4653: FROM WF_DIRECTORY_PARTITIONS
4654: WHERE ORIG_SYSTEM = 'WF_LOCAL_ROLES';
4655:
4656: exception
4657: when NO_DATA_FOUND then

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

4877: end if;
4878:
4879: --We can use the global variable set in wf_local.syncroles
4880: --but for standalone so as not to introduce dependency on WF_LOCAL
4881: --package we query from wf_directory_partitions directly.
4882: select count(1)
4883: into mls_enabled
4884: from wf_directory_partitions
4885: where orig_system = l_origSys

Line 4884: from wf_directory_partitions

4880: --but for standalone so as not to introduce dependency on WF_LOCAL
4881: --package we query from wf_directory_partitions directly.
4882: select count(1)
4883: into mls_enabled
4884: from wf_directory_partitions
4885: where orig_system = l_origSys
4886: and ROLE_TL_VIEW is not NULL ;
4887: if (mls_enabled = 1) then
4888: return TRUE;