DBA Data[Home] [Help]

APPS.JL_JLCOFAAR_XMLP_PKG dependencies on JL_CO_FA_ASSET_APPRS

Line 124: JL_CO_FA_ASSET_APPRS ASP,

120: COUNT(*)
121: INTO X
122: FROM
123: JL_CO_FA_APPRAISALS AP,
124: JL_CO_FA_ASSET_APPRS ASP,
125: FND_LOOKUPS FLH,
126: FND_LOOKUPS FLD
127: WHERE AP.APPRAISAL_ID = P_APPRAISAL_ID
128: AND ASP.APPRAISAL_ID = AP.APPRAISAL_ID

Line 160: JL_CO_FA_ASSET_APPRS ASP,

156: COUNT(*)
157: INTO X
158: FROM
159: JL_CO_FA_APPRAISALS AP,
160: JL_CO_FA_ASSET_APPRS ASP,
161: FND_LOOKUPS FLH,
162: FND_LOOKUPS FLD
163: WHERE AP.APPRAISAL_ID = P_APPRAISAL_ID
164: AND ASP.APPRAISAL_ID = AP.APPRAISAL_ID