DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_HELPER dependencies on WF_NOTIFICATIONS

Line 729: l_notification_id wf_notifications.notification_id%type;

725: l_tk_audit_item_key hxc_timecard_summary.tk_audit_item_key%type;
726: l_resource_id hxc_time_building_blocks.resource_id%type;
727: l_recipient_action_code wf_item_attribute_values.text_value%type;
728: l_action_code wf_item_attribute_values.text_value%type;
729: l_notification_id wf_notifications.notification_id%type;
730: l_recipient_role wf_local_roles.name%type;
731: l_app_mech varchar2(30);
732: l_app_start_date date;
733: l_app_end_date date;

Line 769: from wf_notifications wn,

765: is
766: select wias.item_key,
767: wn.notification_id,
768: wna3.text_value bb_id
769: from wf_notifications wn,
770: wf_notification_attributes wna1,
771: wf_notification_attributes wna2,
772: wf_notification_attributes wna3,
773: wf_item_activity_statuses wias