APPS.AHL_UMP_FORECAST_REQ_PVT dependencies on FND_PROFILE

Line 9: G_APP_MODULE CONSTANT VARCHAR2(30) := RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));

5: -- Declare Constants --
6: -----------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_FORECAST_REQ_PVT';
8: --G_APP_MODULE CONSTANT VARCHAR2(30) := 'AHL';
9: G_APP_MODULE CONSTANT VARCHAR2(30) := RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
10:
11: -- UMP Statuses
12: G_REQ_TYPE_FORECAST CONSTANT VARCHAR2(30) := 'FORECAST';
13:

Line 138: --AND MR.APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')))

134: -- FROM AHL_UNIT_EFFECTIVITIES_APP_V UE, AHL_MR_ROUTES_V MR
135: FROM AHL_UNIT_EFFECTIVITIES_B UE, AHL_ROUTES_B R, AHL_MR_ROUTES MR
136: WHERE UE.mr_header_id = MR.mr_header_id
137: AND R.route_id = MR.ROUTE_ID
138: --AND MR.APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')))
139: AND UE.APPLICATION_USG_CODE = G_APP_MODULE
140: AND (UE.status_code IS NULL OR UE.status_code = 'INIT-DUE')
141: AND UE.due_date IS NOT NULL
142: AND UE.csi_item_instance_id = p_item_indtance_id