APPS.AZ_VALIDATE_ACTIVE dependencies on AZ_SELECTION_SETS_B

Line 7: UPDATE az_selection_sets_b

3:
4: PROCEDURE validate_selsets AS
5: BEGIN
6:
7: UPDATE az_selection_sets_b
8: SET active = 'N'
9: WHERE selection_set_code IN
10: (SELECT selection_set_code
11: FROM az_selection_sets_b

Line 11: FROM az_selection_sets_b

7: UPDATE az_selection_sets_b
8: SET active = 'N'
9: WHERE selection_set_code IN
10: (SELECT selection_set_code
11: FROM az_selection_sets_b
12: WHERE user_id <> 1
13: AND structure_code IN (SELECT structure_code
14: FROM az_structures_b
15: WHERE active = 'N'));

Line 87: az_selection_sets_b sset,

83: SET active = 'Y'
84: WHERE api_code IN (
85: SELECT DISTINCT api.api_code
86: FROM az_structures_b strct,
87: az_selection_sets_b sset,
88: az_selection_set_entities_b ent,
89: az_structure_apis_b sapi,
90: az_apis api
91: WHERE strct.structure_code = sset.structure_code