DBA Data[Home] [Help]

APPS.OTA_ENROLL_IN_TRAINING_SS dependencies on DUAL

Line 924: -- select sysdate into l_raised_date from dual; -- Select Date from the System for p_date_raised

920: -- ----------------------------------------------
921: -- Call Finance Lines API (Cancel Finance Line)
922: -- ----------------------------------------------
923:
924: -- select sysdate into l_raised_date from dual; -- Select Date from the System for p_date_raised
925: -- END IF;
926:
927: OPEN finance_count (l_finance_header_id);
928: FETCH finance_count INTO l_finance_count;

Line 1227: from sys.dual;

1223: hr_utility.set_location('Entering:'||l_proc, 10);
1224: -- Get the next item key from the sequence
1225: select hr_workflow_item_key_s.nextval
1226: into l_item_key
1227: from sys.dual;
1228:
1229:
1230: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1231: WF_ENGINE.setitemattrtext(p_itemtype, l_item_key, 'CURRENT_PERSON_ID', p_person_id);