DBA Data[Home] [Help]

APPS.OTA_LP_NOTIFY_SS dependencies on HR_WORKFLOW_ITEM_KEY_S

Line 201: select hr_workflow_item_key_s.nextval

197: CLOSE csr_get_lp_details;
198:
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');