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 593: DUAL;

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

Line 631: DUAL;

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