APPS.CSM_MESSAGES_EVENT_PKG dependencies on FND_NEW_MESSAGES

Line 45: FROM fnd_new_messages msg

41: -- inserts cur
42: CURSOR l_messages_ins_csr(p_last_upd_date date)
43: IS
44: SELECT msg.application_id, msg.message_name, msg.language_code
45: FROM fnd_new_messages msg
46: WHERE
47: ((msg.application_id = 513 -- CSF application
48: AND msg.message_name like 'CSF_M_%')
49: OR msg.application_id = 883) -- CSM application

Line 62: FROM fnd_new_messages msg,

58: -- updates cur
59: CURSOR l_messages_upd_csr(p_last_upd_date date)
60: IS
61: SELECT acc.access_id, msg.application_id, msg.message_name, msg.language_code
62: FROM fnd_new_messages msg,
63: csm_messages_acc acc
64: WHERE (msg.creation_date < p_last_upd_date AND msg.last_update_date > p_last_upd_date)
65:
66: AND ((msg.application_id = 513 -- CSF application

Line 80: FROM fnd_new_messages msg

76: SELECT acc.access_id, acc.language_code
77: FROM csm_messages_acc acc
78: WHERE NOT EXISTS
79: (SELECT 1
80: FROM fnd_new_messages msg
81: WHERE ((msg.application_id = 513 -- CSF application
82: AND msg.message_name like 'CSF_M_%')
83: OR msg.application_id = 883) -- CSM application
84: AND acc.application_id = msg.application_id