75: SELECT
76: DISTINCT
77: CURRENCY_CODE
78: FROM
79: JL_CO_FA_APPRAISALS
80: WHERE APPRAISAL_ID = P_APPRAISAL_ID;
81: CURRVAR VARCHAR2(15);
82: DUMMY VARCHAR2(15);
83: ERRMSG VARCHAR2(1000);
119: SELECT
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
155: SELECT
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