APPS.AD_PA_CRITERIA_UTIL dependencies on FND_APPLICATION

Line 61: from fnd_product_installations fpi, fnd_application a,

57: insert into ad_pa_criteria_prod_fams
58: (PRODUCT_FAMILY_ABBREVIATION,ADVISOR_CRITERIA_ID,RECOMMENDED_PATCH_FLAG,NEW_CODE_LEVEL_FLAG,LICENSED_FLAG,
59: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
60: select distinct pfm.product_family_abbreviation,'Recommended Patches','Y','N','Y',sysdate,1,sysdate,1
61: from fnd_product_installations fpi, fnd_application a,
62: ad_pm_product_info pi, ad_pm_prod_family_map pfm
63: where fpi.status in ('S', 'I')
64: and fpi.application_id = a.application_id
65: and a.application_short_name= pi.application_short_name

Line 171: from fnd_product_installations fpi, fnd_application a,

167: insert into ad_pa_criteria_prod_fams
168: (PRODUCT_FAMILY_ABBREVIATION,ADVISOR_CRITERIA_ID,RECOMMENDED_PATCH_FLAG,NEW_CODE_LEVEL_FLAG,LICENSED_FLAG,
169: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
170: select distinct pfm.product_family_abbreviation,'New Codelevels','N','Y','Y',sysdate,1,sysdate,1
171: from fnd_product_installations fpi, fnd_application a,
172: ad_pm_product_info pi, ad_pm_prod_family_map pfm
173: where fpi.status in ('S', 'I')
174: and fpi.application_id = a.application_id
175: and a.application_short_name= pi.application_short_name

Line 278: from fnd_product_installations fpi, fnd_application a,

274: insert into ad_pa_criteria_prod_fams
275: (PRODUCT_FAMILY_ABBREVIATION,ADVISOR_CRITERIA_ID,RECOMMENDED_PATCH_FLAG,NEW_CODE_LEVEL_FLAG,LICENSED_FLAG,
276: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
277: select distinct pfm.product_family_abbreviation,'Recommended Patches and New Codelevels','Y','Y','Y',sysdate,1,sysdate,1
278: from fnd_product_installations fpi, fnd_application a,
279: ad_pm_product_info pi, ad_pm_prod_family_map pfm
280: where fpi.status in ('S', 'I')
281: and fpi.application_id = a.application_id
282: and a.application_short_name= pi.application_short_name