DBA Data[Home] [Help]

APPS.AMS_IS_LINE_PVT dependencies on DUAL

Line 51: FROM dual;

47: l_dummy NUMBER;
48:
49: CURSOR c_id IS
50: SELECT AMS_IMP_SOURCE_LINES_s.NEXTVAL
51: FROM dual;
52:
53: CURSOR c_id_exists (l_id IN NUMBER) IS
54: SELECT 1
55: FROM AMS_IMP_SOURCE_LINES

Line 532: FROM DUAL;

528: where import_source_line_id=p_is_line_rec.import_source_line_id;
529:
530: CURSOR c_get_batch_id IS
531: SELECT AS_IMPORT_INTERFACE_S.NEXTVAL
532: FROM DUAL;
533:
534: -- Hint: Developer need to provide Where clause
535:
536: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Is_Line';