APPS.ECX_DIAGNOSTICS_TEST dependencies on ALL_ARGUMENTS

Line 153: from all_arguments aa,

149: is
150: select aa.argument_name,
151: aa.data_type,
152: aa.in_out
153: from all_arguments aa,
154: all_objects ao
155: where ao.object_id = aa.object_id
156: and aa.object_name =v_rec_package_details.procedure_name
157: and aa.owner =v_rec_package_details.schema_name

Line 171: from all_arguments aa,

167:
168: cursor cur_get_overload_num
169: is
170: select distinct nvl(overload, 1) overloadnum
171: from all_arguments aa,
172: all_objects ao
173: where ao.object_id = aa.object_id
174: and aa.object_name =v_rec_package_details.procedure_name
175: and aa.owner =v_rec_package_details.schema_name

Line 193: from all_arguments aa,

189: is
190: select aa.argument_name,
191: aa.data_type,
192: aa.in_out
193: from all_arguments aa,
194: all_objects ao
195: where ao.object_id = aa.object_id
196: and ao.object_name =v_rec_package_details.procedure_name
197: and ao.owner =v_rec_package_details.schema_name