APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on FND_PROFILE

Line 158: AND mh.APPLICATION_USG_CODE=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;

154: FROM ahl_mr_routes_v mr, AHL_MR_HEADERS_VL mh,MTL_SYSTEM_ITEMS_KFV mtl
155: WHERE mr.mr_header_id = mh.mr_header_id
156: AND mtl.INVENTORY_ITEM_ID= MH.BILLING_ITEM_ID
157: AND mr.mr_header_id = C_MR_ID
158: AND mh.APPLICATION_USG_CODE=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;
159:
160:
161: --Added by amagrawa to retrieve task number from Task ID
162: CURSOR c_task_number (p_task_id IN NUMBER)