APPS.AHL_VWP_PROJ_PROD_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 450: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB

446: --salogan::Modified the cursor to handle both request id from P2P and Cost Estimation CP ER 9299910::01-JUN-2009::BEGIN
447: --Cursor to fetch phase
448: CURSOR c_conc_req_phase(c_id IN NUMBER) IS
449: SELECT 'X'
450: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB
451: WHERE FCR.REQUEST_ID IN ( AVB.CST_EST_REQUEST_ID, AVB.REQUEST_ID )
452: AND FCR.PHASE_CODE IN ('P', 'R')
453: AND AVB.VISIT_ID = c_id;
454: l_dummy_val c_conc_req_phase%ROWTYPE;

Line 7759: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB

7755: --salogan::Modified the cursor to handle both request id from P2P and Cost Estimation CP ER 9299910::01-JUN-2009::BEGIN
7756: --Cursor to fetch phase
7757: CURSOR c_conc_req_phase(c_id IN NUMBER) IS
7758: SELECT 'X'
7759: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB
7760: WHERE FCR.REQUEST_ID IN ( AVB.CST_EST_REQUEST_ID, AVB.REQUEST_ID )
7761: AND FCR.PHASE_CODE IN ('P', 'R')
7762: AND AVB.VISIT_ID = c_id;
7763: l_dummy_val c_conc_req_phase%ROWTYPE;