APPS.AHL_DI_PRO_TYPE_ASO_PUB dependencies on FND_LOOKUP_VALUES_VL

Line 32: FROM FND_LOOKUP_VALUES_VL

28: CURSOR lookup_code_info(c_lookup_type VARCHAR2,
29: c_lookup_code VARCHAR2)
30: IS
31: SELECT lookup_code
32: FROM FND_LOOKUP_VALUES_VL
33: WHERE lookup_type = c_lookup_type
34: AND lookup_code = c_lookup_code
35: AND sysdate between start_date_active
36: AND nvl(end_date_active,sysdate);

Line 42: FROM FND_LOOKUP_VALUES_VL

38: CURSOR lookup_code_value(c_lookup_type VARCHAR2,
39: c_meaning VARCHAR2)
40: IS
41: SELECT lookup_code
42: FROM FND_LOOKUP_VALUES_VL
43: WHERE lookup_type = c_lookup_type
44: AND meaning = c_meaning
45: AND sysdate between start_date_active
46: AND nvl(end_date_active,sysdate);

Line 458: FROM FND_LOOKUP_VALUES_VL

454: CURSOR lookup_code_info(c_lookup_type VARCHAR2,
455: c_lookup_code VARCHAR2)
456: IS
457: SELECT lookup_code
458: FROM FND_LOOKUP_VALUES_VL
459: WHERE lookup_type = c_lookup_type
460: AND lookup_code = c_lookup_code
461: AND sysdate between start_date_active
462: AND nvl(end_date_active,sysdate);

Line 468: FROM FND_LOOKUP_VALUES_VL

464: CURSOR lookup_code_value(c_lookup_type VARCHAR2,
465: c_meaning VARCHAR2)
466: IS
467: SELECT lookup_code
468: FROM FND_LOOKUP_VALUES_VL
469: WHERE lookup_type = c_lookup_type
470: AND meaning = c_meaning
471: AND sysdate between start_date_active
472: AND nvl(end_date_active,sysdate);