APPS.AHL_VWP_VISITS_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 1294: FROM FND_CONCURRENT_REQUESTS FCR, FND_LOOKUPS FLS, FND_LOOKUPS FLP

1290: --TCHIMIRA::P2P CP ER 9151144::02-DEC-2009
1291: --Cursor to fetch CP related details
1292: CURSOR c_conc_req_details(x_cp_req_id IN NUMBER) IS
1293: SELECT FLS.MEANING CP_STATUS_CODE, FLP.MEANING CP_PHASE_CODE, FCR.REQUEST_DATE CP_REQUEST_DATE
1294: FROM FND_CONCURRENT_REQUESTS FCR, FND_LOOKUPS FLS, FND_LOOKUPS FLP
1295: WHERE FCR.REQUEST_ID = x_cp_req_id
1296: AND ((FCR.STATUS_CODE = FLS.LOOKUP_CODE
1297: AND FLS.LOOKUP_TYPE = 'CP_STATUS_CODE')
1298: AND (FCR.PHASE_CODE = FLP.LOOKUP_CODE

Line 3500: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB

3496: --salogan::Modified the cursor to handle both request id from P2P and Cost Estimation CP ER 9299910::01-JUN-2009::BEGIN
3497: --Cursor to fetch phase
3498: CURSOR c_conc_req_phase(c_id IN NUMBER) IS
3499: SELECT 'X'
3500: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB
3501: WHERE FCR.REQUEST_ID IN ( AVB.CST_EST_REQUEST_ID, AVB.REQUEST_ID )
3502: AND FCR.PHASE_CODE IN ('P', 'R')
3503: AND AVB.VISIT_ID = c_id;
3504: l_dummy_val c_conc_req_phase%ROWTYPE;