APPS.CSL_WF_NOTIFICATION_AT_ACC_PKG dependencies on JTM_WF_NOTIFICATION_AT_ACC

Line 11: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATION_AT_ACC';

7: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATION_ATTR');
8: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
9: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');
10:
11: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATION_AT_ACC';
12: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATIONS_ACC';
13: g_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATION_ATTRIBUTES';
14: g_table_name2 CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
15: g_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';

Line 80: FROM JTM_WF_NOTIFICATION_AT_ACC

76: /*** Cursor to retrieve all notification attributes for a resource ***/
77: CURSOR c_recipient_attr (b_notification_id NUMBER, b_resource_id NUMBER)
78: IS
79: SELECT notification_id , name
80: FROM JTM_WF_NOTIFICATION_AT_ACC
81: WHERE notification_id = b_notification_id
82: AND resource_id = b_resource_id;
83:
84: r_recipient_attr c_recipient_attr%ROWTYPE;