APPS.AHL_PRD_DISPOSITION_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 3536: SELECT fl.lookup_code FROM fnd_lookup_values_vl FL

3532: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate));
3533:
3534: CURSOR problem_code_csr(p_problem_meaning IN VARCHAR2) IS
3535: /*
3536: SELECT fl.lookup_code FROM fnd_lookup_values_vl FL
3537: WHERE fl.meaning = p_problem_meaning
3538: AND lookup_type = 'REQUEST_PROBLEM_CODE'
3539: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active,sysdate)) AND trunc(nvl(end_date_active,sysdate))
3540: AND (( NOT EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V WHERE INCIDENT_TYPE_ID = FND_PROFILE.Value('AHL_PRD_SR_TYPE')

Line 3548: FROM fnd_lookup_values_vl FL

3544: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(MAP.START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(MAP.END_DATE_ACTIVE,SYSDATE)))));
3545: */
3546: -- AnRaj: Changed query, Perf Bug#4908609,Issue#6
3547: SELECT fl.lookup_code
3548: FROM fnd_lookup_values_vl FL
3549: WHERE fl.meaning = p_problem_meaning
3550: AND lookup_type = 'REQUEST_PROBLEM_CODE'
3551: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active,sysdate))
3552: AND trunc(nvl(end_date_active,sysdate)) ;