APPS.AMS_WFCMPAPR_PVT dependencies on AMS_MESSAGES_VL

Line 3502: FROM ams_messages_vl m,ams_act_messages a

3498: CURSOR C_theme(l_my_campaign_id IN NUMBER,
3499: l_my_obj_type IN VARCHAR2)
3500: IS
3501: SELECT m.message_name
3502: FROM ams_messages_vl m,ams_act_messages a
3503: WHERE a.message_used_by_id = l_my_campaign_id
3504: AND a.message_used_by = l_my_obj_type
3505: AND a.message_id = m.message_id ;
3506: