DBA Data[Home] [Help]

APPS.AMS_UTILITY_PVT dependencies on AK_REGION_ITEMS_VL

Line 2795: SELECT ATTRIBUTE_LABEL_LONG FROM AK_REGION_ITEMS_VL

2791: FROM FND_APPLICATION_VL
2792: WHERE APPLICATION_SHORT_NAME = p_app_short_name;
2793:
2794: CURSOR c_get_ak_region_items(p_app_id IN NUMBER, p_region_code IN VARCHAR2, p_type IN VARCHAR2, p_obj_status IN VARCHAR2, p_obj_attribute IN VARCHAR2) IS
2795: SELECT ATTRIBUTE_LABEL_LONG FROM AK_REGION_ITEMS_VL
2796: WHERE REGION_APPLICATION_ID = p_app_id
2797: AND REGION_CODE = p_region_code
2798: AND ATTRIBUTE_CODE LIKE 'AMS%RULE%'
2799: AND REGION_VALIDATION_API_PKG = p_type