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 608: FROM dual);

604: START WITH parent_category_id = p_category_ids(i)
605: CONNECT BY NOCYCLE PRIOR child_category_id = parent_category_id
606: UNION ALL
607: SELECT p_category_ids(i)
608: FROM dual);
609:
610: l_err_loc := 650;
611: -- now construct the list for that browsing category or for item category it is just itself
612: FOR j in 1..l_category_ids.COUNT LOOP