APPS.AZ_VALIDATE_ACTIVE dependencies on AZ_APIS

Line 82: UPDATE az_apis

78:
79: PROCEDURE activate_apis AS
80: BEGIN
81:
82: UPDATE az_apis
83: SET active = 'Y'
84: WHERE api_code IN (
85: SELECT DISTINCT api.api_code
86: FROM az_structures_b strct,

Line 90: az_apis api

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
92: AND strct.structure_code = sapi.structure_code
93: AND sset.selection_set_code = ent.selection_set_code
94: AND sapi.api_code = api.api_code

Line 122: FROM az_structures_b strct, az_apis api

118:
119: UPDATE az_requests req
120: SET req.active = (
121: SELECT decode(COUNT(api.active), 0, 'N', 'R')
122: FROM az_structures_b strct, az_apis api
123: WHERE strct.structure_code = -- query b
124: (SELECT extractvalue(VALUE(e),
125: '/H/V[@N="StructureCode"]/text()')
126: FROM az_requests d,

Line 205: FROM az_structures_b strct, az_apis api

201:
202: UPDATE az_requests req
203: SET req.active = (
204: SELECT decode(COUNT(api.active), 0, 'N', 'R')
205: FROM az_structures_b strct, az_apis api
206: WHERE strct.structure_code = -- query b
207: (SELECT extractvalue(VALUE(e),
208: '/H/V[@N="StructureCode"]/text()')
209: FROM az_requests d,