DBA Data[Home] [Help]

APPS.MTL_CCEOI_CONC_PVT dependencies on DUAL

Line 179: dual;

175: MTL_CC_ENTRIES_INTERFACE_S2.nextval
176: INTO
177: L_cc_entry_iface_group_id
178: FROM
179: dual;
180: END IF;
181: --
182: -- Only one parameter can be used
183: IF P_Cycle_Count_Entry_Id IS NOT NULL THEN

Line 592: DUAL;

588: SELECT ROUND(L_MaxNumRows/L_CountWorker)
589: INTO
590: L_CountRows
591: FROM
592: DUAL;
593: --
594: IF(L_CountRows*L_CountWorker 595: L_CountRows := L_CountRows + (L_MaxNumRows-(L_CountRows*L_CountWorker));
596: END IF;

Line 630: DUAL;

626: SELECT MTL_CC_ENTRIES_INTERFACE_S1.NEXTVAL
627: INTO
628: L_NextGroupID
629: FROM
630: DUAL;
631: -- UPDATE the interface entries with the group ID
632: IF p_cycle_count_header_id IS NULL THEN
633: --dbms_output.put_line('Updating with cc header is null');
634: UPDATE mtl_cc_entries_interface