APPS.XTR_FORECAST_REMOTE_SOURCES SQL Statements

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

Line: 51

    SELECT nvl(derive_type, 'NONE')
    FROM   gl_currencies
    WHERE  currency_code = p_cur;

Line: 56

    SELECT end_date,
           level_of_summary
    FROM   xtr_forecast_period_temp
    WHERE  forecast_period_temp_id = p_pid;

Line: 63

    main_query := 'SELECT count(*) from ' || source_view;

Line: 80

  main_query :=   'SELECT 	cab.forecast_period_temp_id,
        src.currency_code,
        SUM(src.transaction_amount) ';

Line: 147

        INSERT INTO xtr_external_cashflows(amount_date,
	  				   amount,
					   currency,
					   company_code,
					   trx_type,
					   level_of_summary)
        VALUES (amount_date,
	        forecast_amount,
	        currency,
	        XTR_CASH_FCST.G_party_code,
	        XTR_CASH_FCST.G_trx_type,
                level_of_summary);