APPS.AMS_WFCMPAPR_PVT dependencies on AMS_ACT_MESSAGES

Line 3474: FROM ams_messages_vl m,ams_act_messages a

3470: CURSOR C_theme(l_my_campaign_id IN NUMBER,
3471: l_my_obj_type IN VARCHAR2)
3472: IS
3473: SELECT m.message_name
3474: FROM ams_messages_vl m,ams_act_messages a
3475: WHERE a.message_used_by_id = l_my_campaign_id
3476: AND a.message_used_by = l_my_obj_type
3477: AND a.message_id = m.message_id ;
3478: