APPS.JL_JLCOFAAR_XMLP_PKG dependencies on JL_CO_FA_APPRAISALS

Line 79: JL_CO_FA_APPRAISALS

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);

Line 123: JL_CO_FA_APPRAISALS AP,

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

Line 159: JL_CO_FA_APPRAISALS AP,

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