APPS.AD_PATCH_HIST_REPS dependencies on AD_PATCH_DRIVER_MINIPKS

Line 289: from ad_patch_driver_minipks

285:
286:
287: cursor c1(p_patch_driver_id number) is
288: select patch_level
289: from ad_patch_driver_minipks
290: where patch_driver_id = p_patch_driver_id;
291: begin
292: l_concat_minipks := null;
293: l_first_iter := TRUE;

Line 337: from ad_patch_driver_minipks

333: l_maint_pack_level varchar(30);
334:
335: cursor c1(p_patch_driver_id number) is
336: select patch_level
337: from ad_patch_driver_minipks
338: where patch_driver_id = p_patch_driver_id;
339: begin
340: select patch_type, maint_pack_level
341: into l_patch_type, l_maint_pack_level

Line 814: 'from ad_patch_driver_minipks mi '||

810: 'select pd2.applied_patch_id '||
811: 'from ad_patch_drivers pd2 '||
812: 'where pd2.patch_driver_id in ('||
813: 'select mi.patch_driver_id '||
814: 'from ad_patch_driver_minipks mi '||
815: 'where mi.patch_level = '''||p_level||'''';
816: l_where3:=l_where3||'))';
817: else
818: null;