APPS.EAM_PROCESS_ISOLATION_PVT dependencies on DUAL

Line 258: CURSOR C IS SELECT EAM_ISOLATIONS_S.NEXTVAL FROM SYS.DUAL;

254: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
255: , x_return_status OUT NOCOPY VARCHAR2
256: )IS
257:
258: CURSOR C IS SELECT EAM_ISOLATIONS_S.NEXTVAL FROM SYS.DUAL;
259:
260: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
261: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
262: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 641: CURSOR C2 IS SELECT EAM_ESTABLISHMENT_DETAILS_S.NEXTVAL FROM SYS.DUAL;

637: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
638: , x_return_status OUT NOCOPY VARCHAR2
639: ) IS
640:
641: CURSOR C2 IS SELECT EAM_ESTABLISHMENT_DETAILS_S.NEXTVAL FROM SYS.DUAL;
642:
643: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
644: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
645: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 872: FROM DUAL;

868: IF( p_approval_required AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE')) THEN
869:
870: SELECT EAM_SAFETYWORKFLOW_EVENT_S.NEXTVAL
871: INTO l_wf_event_seq
872: FROM DUAL;
873:
874: l_parameter_list := wf_parameter_list_t();
875: l_event_name := l_status_pending_event;
876: