APPS.ALR_MLR_PACKAGE dependencies on DUAL

Line 838: select alr_response_messages_s.nextval into seq from dual;

834: from alr_actions
835: where action_id = p_action_id and
836: version_number = p_version_num;
837:
838: select alr_response_messages_s.nextval into seq from dual;
839: received := SYSDATE;
840:
841: insert into alr_response_messages(message_handle, node_handle,
842: application_id, alert_id, response_set_id, response_type,

Line 898: from dual where not exists

894: alr_init_resp_tbl(i).name,
895: alr_init_resp_tbl(i).default_value,
896: alr_init_resp_tbl(i).data_type,
897: alr_init_resp_tbl(i).max_len
898: from dual where not exists
899: (select null from alr_response_variable_values
900: where message_handle=msg_handle and
901: node_handle=node_handle and
902: variable_name=alr_init_resp_tbl(i).name);

Line 943: from dual where not exists

939: variable_name,
940: value,
941: alr_init_resp_tbl(t_counter).data_type,
942: alr_init_resp_tbl(t_counter).max_len
943: from dual where not exists
944: (select null from alr_response_variable_values
945: where message_handle=msg_handle and
946: node_handle=node_handle and
947: variable_name=variable_name);