APPS.PA_PROGRESS_REPORT_WORKFLOW dependencies on DUAL

Line 102: from dual;

98: BEGIN
99:
100: SELECT pa_workflow_itemkey_s.nextval
101: INTO l_item_key
102: from dual;
103:
104: x_item_key := To_char(l_item_key);
105:
106: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 501: FROM dual

497: l_auto_approved VARCHAR2(10);
498:
499: CURSOR is_auto_published IS
500: SELECT 'Y'
501: FROM dual
502: WHERE exists
503: (SELECT * FROM pa_progress_report_vers pprv, pa_object_page_layouts popl
504: WHERE pprv.version_id = l_version_id
505: AND pprv.object_id = popl.object_id

Line 761: from dual;

757: --debug_msg_s1 ('start workflow 1: starting');
758:
759: SELECT To_char(pa_workflow_itemkey_s.NEXTVAL)
760: INTO l_item_key
761: from dual;
762:
763:
764: x_return_status := FND_API.G_RET_STS_SUCCESS;
765: