APPS.CSL_CONC_NOTIFICATION_PKG dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 24: FROM WF_NOTIFICATION_ATTRIBUTES

20: FROM JTM_WF_NOTIFICATIONS_ACC );
21:
22: CURSOR c_attributes( b_notification_id NUMBER ) IS
23: SELECT NAME
24: FROM WF_NOTIFICATION_ATTRIBUTES
25: WHERE NOTIFICATION_ID = b_notification_id;
26:
27: /** Cursor for retrieving all Mobile Resources ***/
28: CURSOR c_all_mobile_res IS

Line 56: FROM WF_NOTIFICATION_ATTRIBUTES

52:
53: /** Cursor for retrieving all Attributes per Notification ***/
54: CURSOR c_get_attr_per_notification (b_resource_id NUMBER) IS
55: SELECT NOTIFICATION_ID, NAME
56: FROM WF_NOTIFICATION_ATTRIBUTES
57: WHERE NAME IN ('SENDER', 'SUBJECT', 'MESSAGE_TEXT', 'PRIORITY', 'READ_FLAG', 'DELETE_FLAG')
58: AND (NOTIFICATION_ID, NAME) NOT IN
59: (
60: SELECT NOTIFICATION_ID, NAME