APPS.AD_PATCH_HIST_REPS dependencies on AD_APPLIED_PATCHES

Line 342: from ad_applied_patches

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
342: from ad_applied_patches
343: where applied_patch_id = p_app_ptch_id;
344:
345: if (l_patch_type = 'MAINTENANCE-PACK')
346: then

Line 688: -- from ad_applied_patches aap, ad_patch_driver_langs l,

684: -- decode(pd.driver_type_g_flag, ''Y'',
685: -- decode(pd.driver_type_c_flag, ''Y'', ',Generate',
686: -- decode(pd.driver_type_d_flag, 'Y',
687: -- ,Generate', 'Generate')), null) driver_type,
688: -- from ad_applied_patches aap, ad_patch_driver_langs l,
689: -- ad_patch_drivers pd, ad_appl_tops at, ad_patch_runs pr
690: -- where pr.appl_top_id = at.appl_top_id
691: -- and pr.patch_driver_id = pd.patch_driver_id
692: -- and pd.applied_patch_id = aap.applied_patch_id

Line 741: l_from1 := ' FROM ad_applied_patches aap,ad_patch_driver_langs l,'||

737: ' decode (pr.server_type_node_flag ,''Y'',''Node'',null)||'||
738: ' decode (pr.server_type_web_flag,''Y'',''Web'',null) '||
739: 'servertype';
740:
741: l_from1 := ' FROM ad_applied_patches aap,ad_patch_driver_langs l,'||
742: 'ad_patch_drivers pd,ad_appl_tops at,ad_patch_runs pr ';
743:
744: l_where1 := ' WHERE pr.appl_top_id = at.appl_top_id '||
745: 'and pr.patch_driver_id = pd.patch_driver_id '||