APPS.AMW_WF_HIERARCHY_PKG dependencies on DUAL

Line 119: select fnd_profile.value('AMW_SET_STD_PROCESS') into l_std_process_flag from dual;

115: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119: select fnd_profile.value('AMW_SET_STD_PROCESS') into l_std_process_flag from dual;
120:
121: -- 8.1.7 compatibility issue
122: /*
123: open c_amwp_name;

Line 2165: select LTRIM(l_org_string, '1234567890') into str from dual;

2161: END IF;
2162:
2163: l_org_string := p_org_string;
2164: while LENGTH(l_org_string) <> 0 loop
2165: select LTRIM(l_org_string, '1234567890') into str from dual;
2166: diff := LENGTH(l_org_string) - LENGTH(str);
2167: if LENGTH(str) is null then diff := LENGTH(l_org_string); end if;
2168: select SUBSTR(l_org_string, 1, diff) into orgstr from dual;
2169: orgid := to_number(orgstr);

Line 2168: select SUBSTR(l_org_string, 1, diff) into orgstr from dual;

2164: while LENGTH(l_org_string) <> 0 loop
2165: select LTRIM(l_org_string, '1234567890') into str from dual;
2166: diff := LENGTH(l_org_string) - LENGTH(str);
2167: if LENGTH(str) is null then diff := LENGTH(l_org_string); end if;
2168: select SUBSTR(l_org_string, 1, diff) into orgstr from dual;
2169: orgid := to_number(orgstr);
2170:
2171: refresh_process_per_org (
2172: p_process_id => p_process_id,

Line 2182: select LTRIM(str, 'x') into l_org_string from dual;

2178: if l_return_status <> 'S' then
2179: raise amw_exception;
2180: end if;
2181:
2182: select LTRIM(str, 'x') into l_org_string from dual;
2183: end loop;
2184:
2185: reset_org_count;
2186:

Line 2669: from dual where p_org_id in

2665: exit when c_orgs%notfound;
2666:
2667: begin
2668: select 1 into l_dummy
2669: from dual where p_org_id in
2670: (select organization_id_child
2671: from
2672: (select organization_id_parent, organization_id_child from per_org_structure_elements
2673: where org_structure_version_id =