APPS.OTA_LP_NOTIFY_SS dependencies on HR_WORKFLOW_ITEM_KEY_S

Line 199: select hr_workflow_item_key_s.nextval

195: CLOSE csr_get_lp_details;
196:
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');