APPS.ALR_MLR_PACKAGE dependencies on ALR_ACTIONS

Line 696: from alr_actions a, alr_distribution_lists d,

692: a.maximum_summary_message_width, a.action_level_type,
693: ' ', a.file_name, a.argument_string, a.program_application_id,
694: a.list_application_id, a.response_set_id, a.follow_up_after_days,
695: NVL(a.version_number,0)
696: from alr_actions a, alr_distribution_lists d,
697: alr_response_actions r
698: where r.application_id = p_app_id and
699: r.alert_id = p_alert_id and
700: r.response_set_id = p_response_set_id and

Line 828: alr_actions where action_id=p_action_id;

824: where message_handle=msg_handle and
825: node_handle=node_handle;
826:
827: select max(version_number) into p_version_num from
828: alr_actions where action_id=p_action_id;
829:
830: select to_recipients, cc_recipients, bcc_recipients,
831: reply_to, subject
832: into p_to_recip, p_cc_recip, p_bcc_recip,

Line 834: from alr_actions

830: select to_recipients, cc_recipients, bcc_recipients,
831: reply_to, subject
832: into p_to_recip, p_cc_recip, p_bcc_recip,
833: p_reply_to, p_subject
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;