DBA Data[Home] [Help]

APPS.ICX_CAT_FPI_UPGRADE dependencies on DUAL

Line 1010: FROM sys.dual;

1006: xErrLoc := 240;
1007: -- Create new rt_item_id
1008: SELECT icx_por_itemid.nextval
1009: INTO xRtItemId
1010: FROM sys.dual;
1011:
1012: xErrLoc := 300;
1013: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1014: 'Create a new item: ' || xRtItemId ||

Line 2509: FROM dual

2505: xResult NUMBER;
2506: BEGIN
2507: SELECT 1
2508: INTO xResult
2509: FROM dual
2510: WHERE EXISTS (SELECT 'schema records'
2511: FROM icx_cat_categories_tl
2512: WHERE rt_category_id > 0)
2513: OR EXISTS (SELECT 'data records'