APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on DUAL

Line 602: select AMW_OPINIONS_S2.nextval into v_opinion_id from dual;

598:
599: if eff_details_rec.control_opinion is not null then
600:
601:
602: select AMW_OPINIONS_S2.nextval into v_opinion_id from dual;
603:
604: -- Inserting into amw_opinions table
605:
606: INSERT into amw_opinions(opinion_set_id,opinion_id,object_opinion_type_id,pk1_value,pk2_value,

Line 644: select AMW_OPINIONS_LOG_S.nextval into v_opinion_log_id from dual;

640: commit;
641:
642: -- Inserting into Opinion Log Tables
643:
644: select AMW_OPINIONS_LOG_S.nextval into v_opinion_log_id from dual;
645:
646:
647: select opinion_id into v_opinions_logid from amw_opinions where
648: pk1_value = eff_details_rec.control_id and pk2_value = eff_details_rec.audit_project_id and

Line 818: FROM dual;

814: l_create_Attached_Doc boolean := true;
815:
816: CURSOR c_attached_doc_id IS
817: SELECT FND_ATTACHED_DOCUMENTS_S.nextval
818: FROM dual;
819:
820: CURSOR c_attached_doc_id_exists (l_id IN NUMBER) IS
821: SELECT 1
822: FROM FND_ATTACHED_DOCUMENTS