APPS.CS_WORKFLOW_PUB dependencies on DUAL

Line 89: FROM dual;

85: l_SR_CLOSED_STATUS EXCEPTION;
86:
87: CURSOR l_WorkflowProcID_csr IS
88: SELECT cs_wf_process_id_s.nextval
89: FROM dual;
90:
91: CURSOR l_ServeReq_csr IS
92: SELECT inc.incident_id,
93: inc.workflow_process_id,

Line 1438: FROM dual;

1434: FOR UPDATE OF workflow_process_id;
1435:
1436: CURSOR l_wf_proc_id_csr IS
1437: SELECT cs_action_wf_proc_id_s.nextval
1438: FROM dual;
1439:
1440: BEGIN
1441: -- Standard Start of API savepoint
1442: SAVEPOINT Launch_Action_Workflow_PUB;

Line 1614: SELECT cs_incident_action_audit_s.NEXTVAL INTO l_action_audit_id FROM dual;

1610: CLOSE l_action_csr;
1611: END IF;
1612:
1613: -- Insert audit record
1614: SELECT cs_incident_action_audit_s.NEXTVAL INTO l_action_audit_id FROM dual;
1615:
1616: INSERT INTO cs_incident_action_audit
1617: ( incident_action_audit_id,
1618: last_update_date,