APPS.GCS_LEX_MAP_GL_APPLY_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 32

    SELECT	nvl(glic.interface_table_name, 'GL_INTERFACE'),
		glic.interface_run_id
    FROM	gl_interface_control glic,
		gl_je_sources src
    WHERE	glic.group_id = p_group_id
    AND		glic.je_source_name = src.je_source_name
    AND		src.user_je_source_name = p_source
    ORDER BY	glic.rowid;

Line: 43

    SELECT	1
    FROM	fnd_concurrent_requests cr
    WHERE	cr.request_id = c_req_id
    AND		cr.phase_code = 'C';

Line: 74

      INSERT INTO gl_interface_control(je_source_name, status, group_id, set_of_books_id)
      SELECT	src.je_source_name, 'S', p_group_id, sob_id
      FROM	gl_je_sources src
      WHERE	src.user_je_source_name = p_source;

Line: 99

      UPDATE	gl_interface_control glic
      SET	glic.status = 'I'
      WHERE	rowid = (SELECT	min(rowid)
                         FROM	gl_interface_control glic2
                         WHERE	glic2.je_source_name = glic.je_source_name
                         AND	glic2.group_id = glic.group_id)
      AND	glic.je_source_name =
		(SELECT	src.je_source_name
		 FROM	gl_je_sources src
		 WHERE	src.user_je_source_name = p_source)
      AND	glic.group_id = p_group_id;

Line: 119

        SELECT	gl_journal_import_s.nextval
        INTO	inter_run_id
        FROM	dual;

Line: 123

        UPDATE	gl_interface_control glic
        SET	glic.interface_run_id = inter_run_id
        WHERE	rowid = (SELECT	min(rowid)
                         FROM	gl_interface_control glic2
                         WHERE	glic2.je_source_name = glic.je_source_name
                         AND	glic2.group_id = glic.group_id)
        AND	glic.je_source_name =
		(SELECT	src.je_source_name
		 FROM	gl_je_sources src
		 WHERE	src.user_je_source_name = p_source)
        AND	glic.group_id = p_group_id;