APPS.AD_PA_CRITERIA_UTIL dependencies on AD_PM_PROD_FAMILY_MAP

Line 62: ad_pm_product_info pi, ad_pm_prod_family_map pfm

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
66: and pi.PSEUDO_PRODUCT_FLAG='N'

Line 172: ad_pm_product_info pi, ad_pm_prod_family_map pfm

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
176: and pi.PSEUDO_PRODUCT_FLAG='N'

Line 279: ad_pm_product_info pi, ad_pm_prod_family_map pfm

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
283: and pi.PSEUDO_PRODUCT_FLAG='N'