DBA Data[Home] [Help]

APPS.OTA_LP_NOTIFY_SS dependencies on DUAL

Line 201: from sys.dual;

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