APPS.PA_AUTOALLOC_WF_PKG dependencies on DUAL

Line 29: from dual;

25:
26: -- generate PA workflow item key
27: select pa_workflow_itemkey_s.nextval
28: into PA_AUTOALLOC_WF_PKG.PA_item_key
29: from dual;
30:
31: /* dbms_output.put_line('Item Key is '||PA_item_key); */
32: wf_engine.CreateProcess( itemtype => PA_item_type,
33: itemkey => PA_item_key,

Line 2220: From dual

2216: 'ROLLBACK_ALLOWED');
2217:
2218: select 'FAIL'
2219: into v_result
2220: From dual
2221: where exists (select 'Y'
2222: from PA_Expenditure_Items_All EI,
2223: PA_Expenditures_All ES
2224: where ES.expenditure_group = v_expenditure_group

Line 2408: from dual

2404: WriteDebugMsg(v_err_stack);
2405:
2406: select 'FAIL'
2407: into v_summarization_status
2408: from dual
2409: where exists
2410: (select 'Exception'
2411: from pa_projects_for_accum
2412: where request_id = p_request_id

Line 3203: FROM dual ;

3199:
3200: IF (INSTR(TEMP_UTL,' ') > 0 AND TEMP_UTL IS NOT NULL) THEN
3201: SELECT SUBSTRB(TEMP_UTL, 1, INSTR(TEMP_UTL,' ') - 1)
3202: INTO TEMP_DIR
3203: FROM dual ;
3204: ELSIF (TEMP_UTL IS NOT NULL) THEN
3205: TEMP_DIR := TEMP_UTL;
3206: END IF;
3207: