DBA Data[Home] [Help]

APPS.JL_JLCOFAAR_XMLP_PKG dependencies on FND_LOOKUPS

Line 125: FND_LOOKUPS FLH,

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
129: AND DECODE(P_ALL_ROWS

Line 126: FND_LOOKUPS FLD

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
129: AND DECODE(P_ALL_ROWS
130: ,NULL

Line 161: FND_LOOKUPS FLH,

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
165: AND DECODE(P_ALL_ROWS

Line 162: FND_LOOKUPS FLD

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
165: AND DECODE(P_ALL_ROWS
166: ,NULL