APPS.ICX_CAT_SQE_PVT dependencies on DUAL

Line 69: FROM dual;

65: -- we can fit the expressions into sqes, go ahead and create the sqes
66: -- for this we first get the next sequence
67: SELECT icx_cat_sqe_name_s.nextval
68: INTO l_sqe_sequence
69: FROM dual;
70:
71: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
72: l_log_string := 'New sqe sequence is: ' || l_sqe_sequence;
73: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 601: FROM dual);

597: START WITH parent_category_id = p_category_ids(i)
598: CONNECT BY NOCYCLE PRIOR child_category_id = parent_category_id
599: UNION ALL
600: SELECT p_category_ids(i)
601: FROM dual);
602:
603: l_err_loc := 650;
604: -- now construct the list for that browsing category or for item category it is just itself
605: FOR j in 1..l_category_ids.COUNT LOOP