DBA Data[Home] [Help]

APPS.AHL_DI_ASSO_DOCASO_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 416: FROM FND_LOOKUP_VALUES_VL

412: as
413: CURSOR get_lookup_meaning_to_code(c_meaning VARCHAR2,c_lookup_type VARCHAR2)
414: IS
415: SELECT lookup_code
416: FROM FND_LOOKUP_VALUES_VL
417: WHERE lookup_type= c_lookup_type
418: AND upper(meaning)=upper(c_meaning)
419: AND sysdate between NVL(start_date_active,sysdate)
420: AND nvl(end_date_active,sysdate);

Line 721: FROM FND_LOOKUP_VALUES_VL

717:
718: CURSOR get_aso_obj_type_code(c_aso_object_type_code VARCHAR2)
719: IS
720: SELECT lookup_code
721: FROM FND_LOOKUP_VALUES_VL
722: WHERE lookup_code = c_aso_object_type_code
723: AND lookup_type = 'AHL_OBJECT_TYPE'
724: AND sysdate between start_date_active
725: AND nvl(end_date_active,sysdate);