APPS.QA_PLANS_PUB dependencies on ALR_ACTION_SET_MEMBERS

Line 1923: alr_action_set_members_s.nextval,

1919:
1920: SELECT
1921: alr_actions_s.nextval,
1922: alr_action_sets_s.nextval,
1923: alr_action_set_members_s.nextval,
1924: qa_alr_action_name_s.nextval,
1925: qa_alr_action_set_name_s.nextval
1926: INTO
1927: new_action_id,

Line 2067: FROM alr_action_set_members

2063:
2064: BEGIN
2065: SELECT nvl(max(sequence),0) + 1
2066: INTO l_action_set_members_seq
2067: FROM alr_action_set_members
2068: WHERE application_id = 250 AND
2069: alert_id = 10177 AND
2070: action_set_id = new_action_set_id;
2071: EXCEPTION

Line 2076: INSERT INTO alr_action_set_members (

2072: WHEN no_data_found THEN
2073: l_action_set_members_seq := 1;
2074: END;
2075:
2076: INSERT INTO alr_action_set_members (
2077: application_id,
2078: action_set_member_id,
2079: action_set_id,
2080: action_id,