DBA Data[Home] [Help]

APPS.OTA_LP_NOTIFY_SS dependencies on DUAL

Line 203: from sys.dual;

199: IF p_lp_notification_type ='LP_COMPLETE' THEN
200: -- Get the next item key from the sequence
201: select hr_workflow_item_key_s.nextval
202: into l_item_key
203: from sys.dual;
204: ELSE
205: l_item_key := 'LP^' ||p_lp_enrollment_id || '^' || l_lp_details.notify_days_before_target||'^' ||to_char(sysdate,'DDMMRRRR');
206: END IF;
207: