APPS.JA_CN_PS_FSG_XML_SUBMIT_PROG SQL Statements

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

Line: 148

SELECT COMPANY_NAME
INTO Lv_company_name
FROM JA_CN_SYSTEM_PARAMETERS_ALL
WHERE LEGAL_ENTITY_ID= pn_legal_entity_id;

Line: 176

    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: 182

    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: 189

      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: 201

      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: 213

      SELECT segment_override
      INTO lv_segment_override
      FROM rg_reports
      WHERE report_id = pn_balance_sheet_id;

Line: 223

      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: 234

      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: 245

      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: 256

      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: 268

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

Line: 309

	    SELECT rs.axis_set_id
	    INTO ln_row_set_id
	    FROM rg_report_axis_sets rs, rg_reports rp
	    WHERE rp.report_id = pn_revenue_expenditure_id  --parameter: pn_revenue_expenditure_id
	    AND rp.row_set_id = rs.axis_set_id;

Line: 315

	    SELECT cs.axis_set_id
	    INTO ln_clolumn_set_id
	    FROM rg_report_axis_sets cs, rg_reports rp
	    WHERE rp.report_id = pn_revenue_expenditure_id  --parameter: pn_revenue_expenditure_id
	    AND rp.column_set_id = cs.axis_set_id;

Line: 322

	      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_revenue_expenditure_id;  --parameter: pn_revenue_expenditure_id

Line: 334

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

Line: 346

	      SELECT segment_override
	      INTO lv_segment_override
	      FROM rg_reports
	      WHERE report_id = pn_revenue_expenditure_id;  --parameter: pn_revenue_expenditure_id

Line: 356

	      SELECT cs.content_set_id
	      INTO ln_content_set_id
	      FROM rg_report_content_sets cs, rg_reports rp
	      WHERE rp.report_id = pn_revenue_expenditure_id  --parameter: pn_revenue_expenditure_id
	      AND rp.content_set_id = cs.content_set_id(+);

Line: 367

	      SELECT ro.row_order_id
	      INTO ln_row_order_id
	      FROM rg_row_orders ro, rg_reports rp
	      WHERE rp.report_id = pn_revenue_expenditure_id  --parameter: pn_revenue_expenditure_id
	      AND rp.row_order_id = ro.row_order_id(+);

Line: 378

	      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_revenue_expenditure_id  --parameter: pn_revenue_expenditure_id
	      AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 389

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

Line: 401

	      SELECT rp.parameter_set_id
	      INTO ln_parameter_set_id
	      FROM  rg_reports rp
	      WHERE rp.report_id = pn_revenue_expenditure_id;  --parameter: pn_revenue_expenditure_id

Line: 441

	    SELECT rs.axis_set_id
	    INTO ln_row_set_id
	    FROM rg_report_axis_sets rs, rg_reports rp
	    WHERE rp.report_id = pn_expenditure_detail_id  --parameter: pn_expenditure_detail_id
	    AND rp.row_set_id = rs.axis_set_id;

Line: 447

	    SELECT cs.axis_set_id
	    INTO ln_clolumn_set_id
	    FROM rg_report_axis_sets cs, rg_reports rp
	    WHERE rp.report_id = pn_expenditure_detail_id  --parameter: pn_expenditure_detail_id
	    AND rp.column_set_id = cs.axis_set_id;

Line: 454

	      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_expenditure_detail_id;  --parameter: pn_expenditure_detail_id

Line: 466

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

Line: 478

	      SELECT segment_override
	      INTO lv_segment_override
	      FROM rg_reports
	      WHERE report_id = pn_expenditure_detail_id;  --parameter: pn_expenditure_detail_id

Line: 488

	      SELECT cs.content_set_id
	      INTO ln_content_set_id
	      FROM rg_report_content_sets cs, rg_reports rp
	      WHERE rp.report_id = pn_expenditure_detail_id  --parameter: pn_expenditure_detail_id
	      AND rp.content_set_id = cs.content_set_id(+);

Line: 499

	      SELECT ro.row_order_id
	      INTO ln_row_order_id
	      FROM rg_row_orders ro, rg_reports rp
	      WHERE rp.report_id = pn_expenditure_detail_id  --parameter: pn_expenditure_detail_id
	      AND rp.row_order_id = ro.row_order_id(+);

Line: 510

	      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_expenditure_detail_id  --parameter: pn_expenditure_detail_id
	      AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 521

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

Line: 533

	      SELECT rp.parameter_set_id
	      INTO ln_parameter_set_id
	      FROM  rg_reports rp
	      WHERE rp.report_id = pn_expenditure_detail_id;  --parameter: pn_expenditure_detail_id

Line: 586

                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: 635

                      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_convert_req_status
                        AND enabled_flag='Y'
                        AND language = USERENV('LANG');