DBA Data[Home] [Help]

APPS.CSL_CONC_NOTIFICATION_PKG dependencies on JTM_WF_NOTIFICATIONS_ACC

Line 20: FROM JTM_WF_NOTIFICATIONS_ACC );

16: FROM WF_NOTIFICATIONS
17: WHERE BEGIN_DATE >=NVL( b_last_date, BEGIN_DATE )
18: AND NOTIFICATION_ID NOT IN
19: ( SELECT NOTIFICATION_ID
20: FROM JTM_WF_NOTIFICATIONS_ACC );
21:
22: CURSOR c_attributes( b_notification_id NUMBER ) IS
23: SELECT NAME
24: FROM WF_NOTIFICATION_ATTRIBUTES

Line 67: FROM JTM_WF_NOTIFICATIONS_ACC

63: )
64: AND NOTIFICATION_ID IN
65: (
66: SELECT NOTIFICATION_ID
67: FROM JTM_WF_NOTIFICATIONS_ACC
68: WHERE RESOURCE_ID = b_resource_id
69: );
70:
71: r_get_attr_per_notification c_get_attr_per_notification%ROWTYPE;