DBA Data[Home] [Help]

APPS.BIS_REPORT_PUB dependencies on FND_APPLICATION_VL

Line 170: SELECT application_name FROM ak_regions R, fnd_application_vl A

166:
167: FUNCTION getRegionApplicationName(pRegionCode IN VARCHAR2) RETURN VARCHAR2 IS
168:
169: CURSOR region_app_name_cursor(cp_region_code VARCHAR2) IS
170: SELECT application_name FROM ak_regions R, fnd_application_vl A
171: WHERE R.region_code = cp_region_code AND R.region_application_id = A.application_id;
172:
173: l_code VARCHAR2(3);
174:

Line 177: FROM fnd_application_vl app

173: l_code VARCHAR2(3);
174:
175: CURSOR app_name_from_table is
176: SELECT application_name
177: FROM fnd_application_vl app
178: WHERE app.application_short_name = l_code;
179:
180: l_region_app_name VARCHAR2(2000);
181: