APPS.EAM_PROCESS_CLEARANCE_PVT dependencies on DUAL

Line 246: CURSOR C4 IS SELECT EAM_WORK_PERMIT_S.NEXTVAL FROM SYS.DUAL;

242: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
243: , x_return_status OUT NOCOPY VARCHAR2
244: )IS
245:
246: CURSOR C4 IS SELECT EAM_WORK_PERMIT_S.NEXTVAL FROM SYS.DUAL;
247:
248: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
249: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
250: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 650: FROM DUAL;

646: IF( p_approval_required AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE')) THEN
647:
648: SELECT EAM_SAFETYWORKFLOW_EVENT_S.NEXTVAL
649: INTO l_wf_event_seq
650: FROM DUAL;
651:
652: l_parameter_list := wf_parameter_list_t();
653: l_event_name := l_status_pending_event;
654:

Line 767: CURSOR C IS SELECT EAM_CLEARANCE_NAME_S.NEXTVAL FROM SYS.DUAL;

763: , x_return_status OUT NOCOPY VARCHAR2
764: , x_msg_count OUT NOCOPY NUMBER
765:
766: )IS
767: CURSOR C IS SELECT EAM_CLEARANCE_NAME_S.NEXTVAL FROM SYS.DUAL;
768: l_api_name CONSTANT VARCHAR2(30) := G_PKG_NAME;
769: l_validation_level NUMBER := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
770:
771: l_return_status VARCHAR2(1);