APPS.QA_PLANS_PUB dependencies on ALR_ACTION_SET_MEMBERS

Line 1793: alr_action_set_members_s.nextval,

1789:
1790: SELECT
1791: alr_actions_s.nextval,
1792: alr_action_sets_s.nextval,
1793: alr_action_set_members_s.nextval,
1794: qa_alr_action_name_s.nextval,
1795: qa_alr_action_set_name_s.nextval
1796: INTO
1797: new_action_id,

Line 1937: FROM alr_action_set_members

1933:
1934: BEGIN
1935: SELECT nvl(max(sequence),0) + 1
1936: INTO l_action_set_members_seq
1937: FROM alr_action_set_members
1938: WHERE application_id = 250 AND
1939: alert_id = 10177 AND
1940: action_set_id = new_action_set_id;
1941: EXCEPTION

Line 1946: INSERT INTO alr_action_set_members (

1942: WHEN no_data_found THEN
1943: l_action_set_members_seq := 1;
1944: END;
1945:
1946: INSERT INTO alr_action_set_members (
1947: application_id,
1948: action_set_member_id,
1949: action_set_id,
1950: action_id,