APPS.EAM_ASSET_OPERATION_TXN_PVT dependencies on DUAL

Line 294: select qa_collection_id_s.nextval into l_collection_id from dual;

290: l_elements(p_eam_ops_quality_tbl(results).ELEMENT_ID).value := p_eam_ops_quality_tbl(results).ELEMENT_VALUE;
291: l_collection_id := p_eam_ops_quality_tbl(results).collection_id;
292: IF (l_collection_id is null)
293: THEN
294: select qa_collection_id_s.nextval into l_collection_id from dual;
295: END IF;
296: END IF;
297: END LOOP;
298:

Line 975: FROM dual;

971: --generate txnid from sequence
972: SELECT
973: eam_asset_operation_txn_s.nextval
974: INTO l_txn_id
975: FROM dual;
976:
977:
978: IF p_txn_type=1 THEN
979: l_event_id:=10;