DBA Data[Home] [Help]

APPS.HR_APPRAISAL_WORKFLOW_SS dependencies on WF_NOTIFICATIONS

Line 312: from wf_notifications wn, wf_message_attributes_vl wma

308: -- get the translated display name for the url link
309: begin
310: select wma.display_name
311: into lv_link_label
312: from wf_notifications wn, wf_message_attributes_vl wma
313: where wn.notification_id = document_id
314: and wn.message_name = wma.message_name
315: and wma.message_type = lv_item_type
316: and wma.name = 'OBJECT_URL';

Line 397: comments wf_notifications .user_comment%type;

393:
394: colon pls_integer;
395: avalue varchar2(240);
396: notid pls_integer;
397: comments wf_notifications .user_comment%type;
398: document varchar2(240);
399: document_type varchar2(240);
400:
401: begin