DBA Data[Home] [Help]

APPS.WF_ROLE_HIERARCHY dependencies on DUAL

Line 141: from dual

137: if NOT (l_hierarchyEnabled) then
138: begin
139: select 'NOBS'
140: into l_viewName
141: from dual
142: where EXISTS (select NULL
143: from WF_ROLE_HIERARCHIES
144: where PARTITION_ID = l_partitionID
145: or SUPERIOR_PARTITION_ID = l_partitionID);

Line 2627: from dual;

2623:
2624: -- Obtain the relationship_id from WF_ROLE_HIERARCHIES_S.
2625: select WF_ROLE_HIERARCHIES_S.NEXTVAL
2626: into l_RelationshipID
2627: from dual;
2628:
2629: -- Perform the insert
2630: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2631: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,