APPS.IBE_DSP_HIERARCHY_QUERY_PVT dependencies on DUAL

Line 1230: SELECT INSTR(x_section_path,'/', -1, 1) into l_position FROM DUAL;

1226: x_section_path := '';
1227: END;
1228: -- need to remove the last path from the section path string
1229: -- get the last occurence of / in the string.
1230: SELECT INSTR(x_section_path,'/', -1, 1) into l_position FROM DUAL;
1231:
1232: -- get the substring uptil the last '/'
1233: SELECT SUBSTR(x_section_path,1,l_position) into x_section_path from dual;
1234:

Line 1233: SELECT SUBSTR(x_section_path,1,l_position) into x_section_path from dual;

1229: -- get the last occurence of / in the string.
1230: SELECT INSTR(x_section_path,'/', -1, 1) into l_position FROM DUAL;
1231:
1232: -- get the substring uptil the last '/'
1233: SELECT SUBSTR(x_section_path,1,l_position) into x_section_path from dual;
1234:
1235: -- get the section name and desc
1236: OPEN c1(p_section_id);
1237: FETCH c1 INTO x_section_name, x_section_desc;