APPS.AHL_PRD_DISPOSITION_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 3980: SELECT fl.lookup_code FROM fnd_lookup_values_vl FL

3976:
3977:
3978: CURSOR problem_code_csr(p_problem_meaning IN VARCHAR2) IS
3979: /*
3980: SELECT fl.lookup_code FROM fnd_lookup_values_vl FL
3981: WHERE fl.meaning = p_problem_meaning
3982: AND lookup_type = 'REQUEST_PROBLEM_CODE'
3983: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active,sysdate)) AND trunc(nvl(end_date_active,sysdate))
3984: AND (( NOT EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V WHERE INCIDENT_TYPE_ID = FND_PROFILE.Value('AHL_PRD_SR_TYPE')

Line 3992: FROM fnd_lookup_values_vl FL

3988: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(MAP.START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(MAP.END_DATE_ACTIVE,SYSDATE)))));
3989: */
3990: -- AnRaj: Changed query, Perf Bug#4908609,Issue#6
3991: SELECT fl.lookup_code
3992: FROM fnd_lookup_values_vl FL
3993: WHERE fl.meaning = p_problem_meaning
3994: AND lookup_type = 'REQUEST_PROBLEM_CODE'
3995: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active,sysdate))
3996: AND trunc(nvl(end_date_active,sysdate)) ;