APPS.JA_CN_FSG_XML_SUBMIT_PROG SQL Statements

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

Line: 134

   SELECT COMPANY_NAME
   INTO L_COMPANY_NAME
   FROM JA_CN_SYSTEM_PARAMETERS_ALL
   WHERE LEGAL_ENTITY_ID=L_LEGAL_ENTITY;

Line: 139

    SELECT 	row_set_id,
		column_set_id,
		unit_of_measure_id,
		content_set_id,
		row_order_id,
		rounding_option,
		parameter_set_id,
		minimum_display_level,
		report_display_set_id,
		output_option,
		name,
		segment_override
      INTO    report_rec
      FROM    RG_REPORTS
      WHERE   REPORT_ID = X_REPORT_ID;

Line: 160

         SELECT report_run_type
         INTO   rep_run_type
         FROM   rg_report_content_sets
         WHERE  content_set_id = X_content_set_id;

Line: 209

            UPDATE 	FND_CONCURRENT_REQUESTS
            SET
              OUTPUT_FILE_TYPE = 'XML'
            WHERE
              REQUEST_ID = req_id;

Line: 257

            UPDATE 	FND_CONCURRENT_REQUESTS
            SET
              OUTPUT_FILE_TYPE = 'XML'
            WHERE
              REQUEST_ID = req_id;

Line: 550

      SELECT APP.APPLICATION_ID
        INTO l_template_appl
        FROM FND_APPLICATION_VL      APP,
             FND_CONCURRENT_PROGRAMS FCP,
             FND_CONCURRENT_REQUESTS R
       WHERE FCP.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
         AND R.REQUEST_ID = l_fsg_request_id
         AND APP.APPLICATION_ID = FCP.APPLICATION_ID;

Line: 778

    SELECT COMPANY_NAME
    INTO Lv_company_name
    FROM JA_CN_SYSTEM_PARAMETERS_ALL
    WHERE LEGAL_ENTITY_ID= pn_legal_entity_id;

Line: 808

    SELECT rs.axis_set_id
    INTO ln_row_set_id
    FROM rg_report_axis_sets rs, rg_reports rp
    WHERE rp.report_id = pn_balance_sheet_id
    AND rp.row_set_id = rs.axis_set_id;

Line: 814

    SELECT cs.axis_set_id
    INTO ln_clolumn_set_id
    FROM rg_report_axis_sets cs, rg_reports rp
    WHERE rp.report_id = pn_balance_sheet_id
    AND rp.column_set_id = cs.axis_set_id;

Line: 821

      SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
      INTO lv_unit_of_measure_id
      FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
      WHERE ldg.ledger_id = acc.default_ledger_id
      AND acc.access_set_id = pn_data_access_set_id
      AND rp.report_id = pn_balance_sheet_id;

Line: 833

      SELECT l.meaning
      INTO lv_rounding_option
      FROM rg_lookups l, rg_reports r
      WHERE r.report_id = pn_balance_sheet_id
      AND l.lookup_type = 'ROUNDING_OPTION'
      AND l.lookup_code = r.rounding_option;

Line: 845

      SELECT segment_override
      INTO lv_segment_override
      FROM rg_reports
      WHERE report_id = pn_balance_sheet_id;

Line: 855

      SELECT cs.content_set_id
      INTO ln_content_set_id
      FROM rg_report_content_sets cs, rg_reports rp
      WHERE rp.report_id = pn_balance_sheet_id
      AND rp.content_set_id = cs.content_set_id(+);

Line: 866

      SELECT ro.row_order_id
      INTO ln_row_order_id
      FROM rg_row_orders ro, rg_reports rp
      WHERE rp.report_id = pn_balance_sheet_id
      AND rp.row_order_id = ro.row_order_id(+);

Line: 877

      SELECT ds.report_display_set_id
      INTO ln_report_display_set_id
      FROM rg_report_display_sets ds, rg_reports rp
      WHERE rp.report_id = pn_balance_sheet_id
      AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 888

      SELECT lk.lookup_code
      INTO ln_minimum_display_level
      FROM rg_reports rp, rg_lookups lk
      WHERE rp.report_id = pn_balance_sheet_id
      AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
      AND lk.lookup_type = 'GL_DISPLAY_LEVEL';

Line: 900

      SELECT rp.parameter_set_id
      INTO ln_parameter_set_id
      FROM  rg_reports rp
      WHERE rp.report_id = pn_balance_sheet_id;

Line: 941

    SELECT rs.axis_set_id
    INTO ln_row_set_id
    FROM rg_report_axis_sets rs, rg_reports rp
    WHERE rp.report_id = pn_profit_statement_id
    AND rp.row_set_id = rs.axis_set_id;

Line: 947

    SELECT cs.axis_set_id
    INTO ln_clolumn_set_id
    FROM rg_report_axis_sets cs, rg_reports rp
    WHERE rp.report_id = pn_profit_statement_id
    AND rp.column_set_id = cs.axis_set_id;

Line: 954

      SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
      INTO lv_unit_of_measure_id
      FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
      WHERE ldg.ledger_id = acc.default_ledger_id
      AND acc.access_set_id = pn_profit_statement_id
      AND rp.report_id = pn_balance_sheet_id;

Line: 966

      SELECT l.meaning
      INTO lv_rounding_option
      FROM rg_lookups l, rg_reports r
      WHERE r.report_id = pn_profit_statement_id
      AND l.lookup_type = 'ROUNDING_OPTION'
      AND l.lookup_code = r.rounding_option;

Line: 978

      SELECT segment_override
      INTO lv_segment_override
      FROM rg_reports
      WHERE report_id = pn_profit_statement_id;

Line: 988

      SELECT cs.content_set_id
      INTO ln_content_set_id
      FROM rg_report_content_sets cs, rg_reports rp
      WHERE rp.report_id = pn_profit_statement_id
      AND rp.content_set_id = cs.content_set_id(+);

Line: 999

      SELECT ro.row_order_id
      INTO ln_row_order_id
      FROM rg_row_orders ro, rg_reports rp
      WHERE rp.report_id = pn_profit_statement_id
      AND rp.row_order_id = ro.row_order_id(+);

Line: 1010

      SELECT ds.report_display_set_id
      INTO ln_report_display_set_id
      FROM rg_report_display_sets ds, rg_reports rp
      WHERE rp.report_id = pn_profit_statement_id
      AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 1021

      SELECT lk.lookup_code
      INTO ln_minimum_display_level
      FROM rg_reports rp, rg_lookups lk
      WHERE rp.report_id = pn_profit_statement_id
      AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
      AND lk.lookup_type = 'GL_DISPLAY_LEVEL';

Line: 1033

      SELECT rp.parameter_set_id
      INTO ln_parameter_set_id
      FROM  rg_reports rp
      WHERE rp.report_id = pn_profit_statement_id;

Line: 1075

    SELECT rs.axis_set_id
    INTO ln_row_set_id
    FROM rg_report_axis_sets rs, rg_reports rp
    WHERE rp.report_id = pn_owners_equity_id
    AND rp.row_set_id = rs.axis_set_id;

Line: 1081

    SELECT cs.axis_set_id
    INTO ln_clolumn_set_id
    FROM rg_report_axis_sets cs, rg_reports rp
    WHERE rp.report_id = pn_owners_equity_id
    AND rp.column_set_id = cs.axis_set_id;

Line: 1088

      SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
      INTO lv_unit_of_measure_id
      FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
      WHERE ldg.ledger_id = acc.default_ledger_id
      AND acc.access_set_id = pn_owners_equity_id
      AND rp.report_id = pn_balance_sheet_id;

Line: 1100

      SELECT l.meaning
      INTO lv_rounding_option
      FROM rg_lookups l, rg_reports r
      WHERE r.report_id = pn_owners_equity_id
      AND l.lookup_type = 'ROUNDING_OPTION'
      AND l.lookup_code = r.rounding_option;

Line: 1112

      SELECT segment_override
      INTO lv_segment_override
      FROM rg_reports
      WHERE report_id = pn_owners_equity_id;

Line: 1122

      SELECT cs.content_set_id
      INTO ln_content_set_id
      FROM rg_report_content_sets cs, rg_reports rp
      WHERE rp.report_id = pn_owners_equity_id
      AND rp.content_set_id = cs.content_set_id(+);

Line: 1133

      SELECT ro.row_order_id
      INTO ln_row_order_id
      FROM rg_row_orders ro, rg_reports rp
      WHERE rp.report_id = pn_owners_equity_id
      AND rp.row_order_id = ro.row_order_id(+);

Line: 1144

      SELECT ds.report_display_set_id
      INTO ln_report_display_set_id
      FROM rg_report_display_sets ds, rg_reports rp
      WHERE rp.report_id = pn_owners_equity_id
      AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 1155

      SELECT lk.lookup_code
      INTO ln_minimum_display_level
      FROM rg_reports rp, rg_lookups lk
      WHERE rp.report_id = pn_owners_equity_id
      AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
      AND lk.lookup_type = 'GL_DISPLAY_LEVEL';

Line: 1167

      SELECT rp.parameter_set_id
      INTO ln_parameter_set_id
      FROM  rg_reports rp
      WHERE rp.report_id = pn_owners_equity_id;

Line: 1210

    SELECT rs.axis_set_id
    INTO ln_row_set_id
    FROM rg_report_axis_sets rs, rg_reports rp
    WHERE rp.report_id = pn_csf_report_id
    AND rp.row_set_id = rs.axis_set_id;

Line: 1216

    SELECT cs.axis_set_id
    INTO ln_clolumn_set_id
    FROM rg_report_axis_sets cs, rg_reports rp
    WHERE rp.report_id = pn_csf_report_id
    AND rp.column_set_id = cs.axis_set_id;

Line: 1223

      SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
      INTO lv_unit_of_measure_id
      FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
      WHERE ldg.ledger_id = acc.default_ledger_id
      AND acc.access_set_id = pn_csf_report_id
      AND rp.report_id = pn_balance_sheet_id;

Line: 1235

      SELECT l.meaning
      INTO lv_rounding_option
      FROM rg_lookups l, rg_reports r
      WHERE r.report_id = pn_csf_report_id
      AND l.lookup_type = 'ROUNDING_OPTION'
      AND l.lookup_code = r.rounding_option;

Line: 1247

      SELECT segment_override
      INTO lv_segment_override
      FROM rg_reports
      WHERE report_id = pn_csf_report_id;

Line: 1257

      SELECT cs.content_set_id
      INTO ln_content_set_id
      FROM rg_report_content_sets cs, rg_reports rp
      WHERE rp.report_id = pn_csf_report_id
      AND rp.content_set_id = cs.content_set_id(+);

Line: 1268

      SELECT ro.row_order_id
      INTO ln_row_order_id
      FROM rg_row_orders ro, rg_reports rp
      WHERE rp.report_id = pn_csf_report_id
      AND rp.row_order_id = ro.row_order_id(+);

Line: 1279

      SELECT ds.report_display_set_id
      INTO ln_report_display_set_id
      FROM rg_report_display_sets ds, rg_reports rp
      WHERE rp.report_id = pn_csf_report_id
      AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 1290

      SELECT lk.lookup_code
      INTO ln_minimum_display_level
      FROM rg_reports rp, rg_lookups lk
      WHERE rp.report_id = pn_csf_report_id
      AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
      AND lk.lookup_type = 'GL_DISPLAY_LEVEL';

Line: 1302

      SELECT rp.parameter_set_id
      INTO ln_parameter_set_id
      FROM  rg_reports rp
      WHERE rp.report_id = pn_csf_report_id;

Line: 1359

      UPDATE 	FND_CONCURRENT_REQUESTS
      SET
        OUTPUT_FILE_TYPE = 'XML'
      WHERE
        REQUEST_ID = ln_reqid_fsg;

Line: 1381

        SELECT
          lookup_code
        INTO
          lv_fsg_req_status_code
        FROM
          fnd_lookup_values
        WHERE lookup_type = 'CP_STATUS_CODE'
          AND view_application_id=0
          AND security_group_id=0
          AND meaning=lv_fsg_req_status
          AND enabled_flag='Y'
          AND language = USERENV('LANG');

Line: 1446

        SELECT
          lookup_code
        INTO
          lv_cal_req_status_code
        FROM
          fnd_lookup_values
        WHERE lookup_type = 'CP_STATUS_CODE'
          AND view_application_id=0
          AND security_group_id=0
          AND meaning=lv_cal_req_status
          AND enabled_flag='Y'
          AND language = USERENV('LANG');

Line: 1491

                SELECT
                  lookup_code
                INTO
                  lv_comb_req_status_code
                FROM
                  fnd_lookup_values
                WHERE lookup_type = 'CP_STATUS_CODE'
                  AND view_application_id=0
                  AND security_group_id=0
                  AND meaning=lv_comb_req_status
                  AND enabled_flag='Y'
                  AND language = USERENV('LANG');

Line: 1540

                      SELECT
                        lookup_code
                      INTO
                        lv_convert_req_status_code
                      FROM
                        fnd_lookup_values
                      WHERE lookup_type = 'CP_STATUS_CODE'
                        AND view_application_id=0
                        AND security_group_id=0
                        AND meaning=lv_comb_req_status
                        AND enabled_flag='Y'
                        AND language = USERENV('LANG');

Line: 1776

    SELECT COMPANY_NAME
    INTO Lv_company_name
    FROM JA_CN_SYSTEM_PARAMETERS_ALL
    WHERE LEGAL_ENTITY_ID= pn_legal_entity_id;

Line: 1806

    SELECT rs.axis_set_id
    INTO ln_row_set_id
    FROM rg_report_axis_sets rs, rg_reports rp
    WHERE rp.report_id = pn_balance_sheet_id
    AND rp.row_set_id = rs.axis_set_id;

Line: 1812

    SELECT cs.axis_set_id
    INTO ln_clolumn_set_id
    FROM rg_report_axis_sets cs, rg_reports rp
    WHERE rp.report_id = pn_balance_sheet_id
    AND rp.column_set_id = cs.axis_set_id;

Line: 1819

      SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
      INTO lv_unit_of_measure_id
      FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
      WHERE ldg.ledger_id = acc.default_ledger_id
      AND acc.access_set_id = pn_data_access_set_id
      AND rp.report_id = pn_balance_sheet_id;

Line: 1831

      SELECT l.meaning
      INTO lv_rounding_option
      FROM rg_lookups l, rg_reports r
      WHERE r.report_id = pn_balance_sheet_id
      AND l.lookup_type = 'ROUNDING_OPTION'
      AND l.lookup_code = r.rounding_option;

Line: 1843

      SELECT segment_override
      INTO lv_segment_override
      FROM rg_reports
      WHERE report_id = pn_balance_sheet_id;

Line: 1853

      SELECT cs.content_set_id
      INTO ln_content_set_id
      FROM rg_report_content_sets cs, rg_reports rp
      WHERE rp.report_id = pn_balance_sheet_id
      AND rp.content_set_id = cs.content_set_id(+);

Line: 1864

      SELECT ro.row_order_id
      INTO ln_row_order_id
      FROM rg_row_orders ro, rg_reports rp
      WHERE rp.report_id = pn_balance_sheet_id
      AND rp.row_order_id = ro.row_order_id(+);

Line: 1875

      SELECT ds.report_display_set_id
      INTO ln_report_display_set_id
      FROM rg_report_display_sets ds, rg_reports rp
      WHERE rp.report_id = pn_balance_sheet_id
      AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 1886

      SELECT lk.lookup_code
      INTO ln_minimum_display_level
      FROM rg_reports rp, rg_lookups lk
      WHERE rp.report_id = pn_balance_sheet_id
      AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
      AND lk.lookup_type = 'GL_DISPLAY_LEVEL';

Line: 1898

      SELECT rp.parameter_set_id
      INTO ln_parameter_set_id
      FROM  rg_reports rp
      WHERE rp.report_id = pn_balance_sheet_id;

Line: 1939

    SELECT rs.axis_set_id
    INTO ln_row_set_id
    FROM rg_report_axis_sets rs, rg_reports rp
    WHERE rp.report_id = pn_profit_statement_id
    AND rp.row_set_id = rs.axis_set_id;

Line: 1945

    SELECT cs.axis_set_id
    INTO ln_clolumn_set_id
    FROM rg_report_axis_sets cs, rg_reports rp
    WHERE rp.report_id = pn_profit_statement_id
    AND rp.column_set_id = cs.axis_set_id;

Line: 1952

      SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
      INTO lv_unit_of_measure_id
      FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
      WHERE ldg.ledger_id = acc.default_ledger_id
      AND acc.access_set_id = pn_profit_statement_id
      AND rp.report_id = pn_balance_sheet_id;

Line: 1964

      SELECT l.meaning
      INTO lv_rounding_option
      FROM rg_lookups l, rg_reports r
      WHERE r.report_id = pn_profit_statement_id
      AND l.lookup_type = 'ROUNDING_OPTION'
      AND l.lookup_code = r.rounding_option;

Line: 1976

      SELECT segment_override
      INTO lv_segment_override
      FROM rg_reports
      WHERE report_id = pn_profit_statement_id;

Line: 1986

      SELECT cs.content_set_id
      INTO ln_content_set_id
      FROM rg_report_content_sets cs, rg_reports rp
      WHERE rp.report_id = pn_profit_statement_id
      AND rp.content_set_id = cs.content_set_id(+);

Line: 1997

      SELECT ro.row_order_id
      INTO ln_row_order_id
      FROM rg_row_orders ro, rg_reports rp
      WHERE rp.report_id = pn_profit_statement_id
      AND rp.row_order_id = ro.row_order_id(+);

Line: 2008

      SELECT ds.report_display_set_id
      INTO ln_report_display_set_id
      FROM rg_report_display_sets ds, rg_reports rp
      WHERE rp.report_id = pn_profit_statement_id
      AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 2019

      SELECT lk.lookup_code
      INTO ln_minimum_display_level
      FROM rg_reports rp, rg_lookups lk
      WHERE rp.report_id = pn_profit_statement_id
      AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
      AND lk.lookup_type = 'GL_DISPLAY_LEVEL';

Line: 2031

      SELECT rp.parameter_set_id
      INTO ln_parameter_set_id
      FROM  rg_reports rp
      WHERE rp.report_id = pn_profit_statement_id;

Line: 2073

    SELECT rs.axis_set_id
    INTO ln_row_set_id
    FROM rg_report_axis_sets rs, rg_reports rp
    WHERE rp.report_id = pn_owners_equity_id
    AND rp.row_set_id = rs.axis_set_id;

Line: 2079

    SELECT cs.axis_set_id
    INTO ln_clolumn_set_id
    FROM rg_report_axis_sets cs, rg_reports rp
    WHERE rp.report_id = pn_owners_equity_id
    AND rp.column_set_id = cs.axis_set_id;

Line: 2086

      SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
      INTO lv_unit_of_measure_id
      FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
      WHERE ldg.ledger_id = acc.default_ledger_id
      AND acc.access_set_id = pn_owners_equity_id
      AND rp.report_id = pn_balance_sheet_id;

Line: 2098

      SELECT l.meaning
      INTO lv_rounding_option
      FROM rg_lookups l, rg_reports r
      WHERE r.report_id = pn_owners_equity_id
      AND l.lookup_type = 'ROUNDING_OPTION'
      AND l.lookup_code = r.rounding_option;

Line: 2110

      SELECT segment_override
      INTO lv_segment_override
      FROM rg_reports
      WHERE report_id = pn_owners_equity_id;

Line: 2120

      SELECT cs.content_set_id
      INTO ln_content_set_id
      FROM rg_report_content_sets cs, rg_reports rp
      WHERE rp.report_id = pn_owners_equity_id
      AND rp.content_set_id = cs.content_set_id(+);

Line: 2131

      SELECT ro.row_order_id
      INTO ln_row_order_id
      FROM rg_row_orders ro, rg_reports rp
      WHERE rp.report_id = pn_owners_equity_id
      AND rp.row_order_id = ro.row_order_id(+);

Line: 2142

      SELECT ds.report_display_set_id
      INTO ln_report_display_set_id
      FROM rg_report_display_sets ds, rg_reports rp
      WHERE rp.report_id = pn_owners_equity_id
      AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 2153

      SELECT lk.lookup_code
      INTO ln_minimum_display_level
      FROM rg_reports rp, rg_lookups lk
      WHERE rp.report_id = pn_owners_equity_id
      AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
      AND lk.lookup_type = 'GL_DISPLAY_LEVEL';

Line: 2165

      SELECT rp.parameter_set_id
      INTO ln_parameter_set_id
      FROM  rg_reports rp
      WHERE rp.report_id = pn_owners_equity_id;

Line: 2208

    SELECT rs.axis_set_id
    INTO ln_row_set_id
    FROM rg_report_axis_sets rs, rg_reports rp
    WHERE rp.report_id = pn_csf_report_id
    AND rp.row_set_id = rs.axis_set_id;

Line: 2214

    SELECT cs.axis_set_id
    INTO ln_clolumn_set_id
    FROM rg_report_axis_sets cs, rg_reports rp
    WHERE rp.report_id = pn_csf_report_id
    AND rp.column_set_id = cs.axis_set_id;

Line: 2221

      SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
      INTO lv_unit_of_measure_id
      FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
      WHERE ldg.ledger_id = acc.default_ledger_id
      AND acc.access_set_id = pn_csf_report_id
      AND rp.report_id = pn_balance_sheet_id;

Line: 2233

      SELECT l.meaning
      INTO lv_rounding_option
      FROM rg_lookups l, rg_reports r
      WHERE r.report_id = pn_csf_report_id
      AND l.lookup_type = 'ROUNDING_OPTION'
      AND l.lookup_code = r.rounding_option;

Line: 2245

      SELECT segment_override
      INTO lv_segment_override
      FROM rg_reports
      WHERE report_id = pn_csf_report_id;

Line: 2255

      SELECT cs.content_set_id
      INTO ln_content_set_id
      FROM rg_report_content_sets cs, rg_reports rp
      WHERE rp.report_id = pn_csf_report_id
      AND rp.content_set_id = cs.content_set_id(+);

Line: 2266

      SELECT ro.row_order_id
      INTO ln_row_order_id
      FROM rg_row_orders ro, rg_reports rp
      WHERE rp.report_id = pn_csf_report_id
      AND rp.row_order_id = ro.row_order_id(+);

Line: 2277

      SELECT ds.report_display_set_id
      INTO ln_report_display_set_id
      FROM rg_report_display_sets ds, rg_reports rp
      WHERE rp.report_id = pn_csf_report_id
      AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 2288

      SELECT lk.lookup_code
      INTO ln_minimum_display_level
      FROM rg_reports rp, rg_lookups lk
      WHERE rp.report_id = pn_csf_report_id
      AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
      AND lk.lookup_type = 'GL_DISPLAY_LEVEL';

Line: 2300

      SELECT rp.parameter_set_id
      INTO ln_parameter_set_id
      FROM  rg_reports rp
      WHERE rp.report_id = pn_csf_report_id;

Line: 2357

      UPDATE 	FND_CONCURRENT_REQUESTS
      SET
        OUTPUT_FILE_TYPE = 'XML'
      WHERE
        REQUEST_ID = ln_reqid_fsg;

Line: 2379

        SELECT
          lookup_code
        INTO
          lv_fsg_req_status_code
        FROM
          fnd_lookup_values
        WHERE lookup_type = 'CP_STATUS_CODE'
          AND view_application_id=0
          AND security_group_id=0
          AND meaning=lv_fsg_req_status
          AND enabled_flag='Y'
          AND language = USERENV('LANG');

Line: 2444

        SELECT
          lookup_code
        INTO
          lv_cal_req_status_code
        FROM
          fnd_lookup_values
        WHERE lookup_type = 'CP_STATUS_CODE'
          AND view_application_id=0
          AND security_group_id=0
          AND meaning=lv_cal_req_status
          AND enabled_flag='Y'
          AND language = USERENV('LANG');

Line: 2489

                SELECT
                  lookup_code
                INTO
                  lv_comb_req_status_code
                FROM
                  fnd_lookup_values
                WHERE lookup_type = 'CP_STATUS_CODE'
                  AND view_application_id=0
                  AND security_group_id=0
                  AND meaning=lv_comb_req_status
                  AND enabled_flag='Y'
                  AND language = USERENV('LANG');