APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on FND_CONCURRENT_REQUESTS

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

87: --salogan::Added Cursor to fetch conc request details CP ER 9299910::01-JUN-2009::BEGIN
88: CURSOR c_conc_req_details(x_cp_req_id IN NUMBER) IS
89: SELECT FLS.MEANING CP_STATUS, FLP.MEANING CP_PHASE, FCR.REQUEST_DATE CP_REQUEST_DATE
90: , FCR.PHASE_CODE CP_PHASE_CODE
91: FROM FND_CONCURRENT_REQUESTS FCR, FND_LOOKUPS FLS, FND_LOOKUPS FLP
92: WHERE FCR.REQUEST_ID = x_cp_req_id
93: AND ((FCR.STATUS_CODE = FLS.LOOKUP_CODE
94: AND FLS.LOOKUP_TYPE = 'CP_STATUS_CODE')
95: AND (FCR.PHASE_CODE = FLP.LOOKUP_CODE

Line 3621: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB

3617:
3618: --Cursor to fetch phase
3619: CURSOR c_conc_req_phase(c_id IN NUMBER) IS
3620: SELECT 'X'
3621: FROM FND_CONCURRENT_REQUESTS FCR, AHL_VISITS_B AVB
3622: WHERE FCR.REQUEST_ID IN ( AVB.CST_EST_REQUEST_ID, AVB.REQUEST_ID )
3623: AND FCR.PHASE_CODE IN ('P', 'R')
3624: AND AVB.VISIT_ID = c_id;
3625: l_dummy c_conc_req_phase%ROWTYPE;