APPS.FII_SIZING_UTIL dependencies on PA_LOOKUPS

Line 114: FROM PA_LOOKUPS PL,

110: FROM PA_EXPENDITURE_TYPES
111: WHERE last_update_date BETWEEN p_from_date AND p_to_date
112: UNION ALL
113: select count(*) cnt
114: FROM PA_LOOKUPS PL,
115: PA_LOOKUPS PLU
116: WHERE PL.LOOKUP_TYPE = 'ADW DIM LEVEL NAME'
117: AND PL.LOOKUP_CODE = 'ALL_EXP_TYPES'
118: AND PLU.LOOKUP_TYPE = 'ADW RESOURCE NAME'

Line 115: PA_LOOKUPS PLU

111: WHERE last_update_date BETWEEN p_from_date AND p_to_date
112: UNION ALL
113: select count(*) cnt
114: FROM PA_LOOKUPS PL,
115: PA_LOOKUPS PLU
116: WHERE PL.LOOKUP_TYPE = 'ADW DIM LEVEL NAME'
117: AND PL.LOOKUP_CODE = 'ALL_EXP_TYPES'
118: AND PLU.LOOKUP_TYPE = 'ADW RESOURCE NAME'
119: AND PLU.LOOKUP_CODE = 'UNKNOWN');