APPS.IEM_ARCH_PVT dependencies on DUAL

Line 45: select iem_arch_requests_s1.nextval into l_seq_id from dual;

41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: SAVEPOINT SUBMIT_REQUEST_PVT;
43: -- Create a New Request Id
44: IF p_message_id.count>0 THEN --There are messages to process
45: select iem_arch_requests_s1.nextval into l_seq_id from dual;
46:
47: -- Creating the Source message ids in the archive details table
48: IEM_ARCH_DTLS_PVT. create_item (p_api_version_number=>1.0 ,
49: p_init_msg_list=>'F' ,

Line 373: select to_date(p_date,p_date_format) into l_date from dual;

369: email_account_id=p_email_account_id and mailproc_Status=substr(p_folder,1,1)
370: and creation_date 371: ERROR_FOLDER_COUNT EXCEPTION;
372: BEGIN
373: select to_date(p_date,p_date_format) into l_date from dual;
374: BEGIN
375: select to_char(max(creation_date),p_date_format)
376: into x_arch_date
377: from iem_arch_requests