APPS.FVFCCHKB_PKG SQL Statements

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

Line: 53

  	SELECT 	nvl(amount,0) amount, debit_credit,
		sgl_acct_number
    	FROM  	fv_facts_temp
   	WHERE	treasury_symbol_id = g_treasury_symbol_id
     	  AND 	fct_int_record_category = 'REPORTED_NEW'
     	  AND 	fct_int_record_type = 'BLK_DTL'
          AND 	sgl_acct_number like '4%'
          AND 	begin_end = 'E'
	  AND   amount <> 0
	ORDER BY sgl_acct_number;

Line: 108

  SELECT ffa.ussgl_account,
         ffa.total_resource_be_flag, ffa.total_resource_dc_flag,
         ffa.resource_status_be_flag, ffa.resource_status_dc_flag
    FROM fv_facts_ussgl_accounts ffa
   WHERE ffa.ussgl_account like '4%'
   AND   EXISTS
	 (SELECT 'x'
	  FROM    fv_facts_temp fft
	  WHERE   fft.treasury_symbol_id = g_treasury_symbol_id
	  AND     fft.sgl_acct_number = ffa.ussgl_account);

Line: 159

       SELECT nvl(sum(amount),0)
         INTO l_begin_bal
         FROM fv_facts_temp
        WHERE treasury_symbol_id = g_treasury_symbol_id
          AND fct_int_record_category = 'REPORTED_NEW'
          AND fct_int_record_type = 'BLK_DTL'
          AND sgl_acct_number = l_ussgl_account
          AND begin_end = 'B';

Line: 184

       SELECT nvl(sum(amount),0)
         INTO l_end_bal
         FROM fv_facts_temp
     	WHERE treasury_symbol_id = g_treasury_symbol_id
          AND fct_int_record_category = 'REPORTED_NEW'
          AND fct_int_record_type = 'BLK_DTL'
       	  AND sgl_acct_number = l_ussgl_account
          AND begin_end = 'E';

Line: 320

        SELECT 	nvl(amount,0) amount, debit_credit, sgl_acct_number
    	FROM	fv_facts_temp
   	WHERE   treasury_symbol_id = g_treasury_symbol_id
   	AND   	fct_int_record_category = 'REPORTED_NEW'
     	AND   	fct_int_record_type = 'BLK_DTL'
     	AND	sgl_acct_number like '4%'
     	AND	begin_end = 'B';

Line: 374

  	SELECT 	nvl(sum(fft.amount),0), fft.sgl_acct_number
    	FROM 	fv_facts_temp fft,
         	fv_facts_ussgl_accounts ffa
   	WHERE   treasury_symbol_id = g_treasury_symbol_id
     	AND	fct_int_record_category = 'REPORTED_NEW'
     	AND	fct_int_record_type = 'BLK_DTL'
     	AND	ffa.ussgl_account = fft.sgl_acct_number
     	AND	ffa.ye_anticipated_flag = 'Y'
     	AND	fft.begin_end = 'E'
   	GROUP BY fft.sgl_acct_number;

Line: 443

  		SELECT 	fft.sgl_acct_number, nvl(amount,0) amount,
	 		ffa.ye_resource_equity_flag
    		FROM 	fv_facts_temp fft,
         		fv_facts_ussgl_accounts ffa
   		WHERE 	fft.treasury_symbol_id = g_treasury_symbol_id
     		AND 	fft.fct_int_record_category = 'REPORTED_NEW'
     		AND 	fft.fct_int_record_type = 'BLK_DTL'
     		AND 	ffa.ussgl_account = fft.sgl_acct_number
     		AND 	ffa.ye_resource_equity_flag in ('R','E')
     		AND 	fft.begin_end = ffa.ye_resource_equity_be_flag;

Line: 508

  SELECT ffa.rt7_code_id,
         ffc.rt7_code,
         ffa.preclosing_unexpended_amt
    FROM fv_facts_authorizations ffa,
	 fv_facts_rt7_codes ffc
   WHERE ffa.treasury_symbol_id = g_treasury_symbol_id
     AND ffa.rt7_code_id = ffc.rt7_code_id
     AND ffa.set_of_books_id = l_set_of_books_id;

Line: 546

      SELECT NVL(sum(fft.amount),0)
        INTO l_accounts_balance
        FROM fv_facts_temp fft,
    	     fv_facts_rt7_accounts rta
       WHERE rta.rt7_code_id = l_rt7_code_id
         AND rta.rt7_ussgl_account = fft.sgl_acct_number
         AND fft.treasury_symbol_id = g_treasury_symbol_id
         AND fft.fct_int_record_category = 'REPORTED_NEW'
         AND fft.fct_int_record_type = 'BLK_DTL'
         AND fft.begin_end = decode(rta.rt7_ussgl_account, '4139','B','4149','B','E');

Line: 605

  		SELECT nvl(fft.amount,0) amount, fft.sgl_acct_number
    		FROM fv_facts_temp fft,
         	     fv_facts_ussgl_accounts ffa
   		WHERE ffa.fund_balance_account_flag = 'Y'
     		AND fft.sgl_acct_number = ffa.ussgl_account
     		AND fft.treasury_symbol_id = g_treasury_symbol_id
     		AND fft.fct_int_record_category = 'REPORTED_NEW'
     		AND fft.fct_int_record_type = 'BLK_DTL'
     		AND fft.begin_end = 'E';

Line: 624

   SELECT preclosing_unexpended_amt
     INTO l_unexp_amount
     FROM fv_treasury_symbols
    WHERE treasury_symbol_id = g_treasury_symbol_id;

Line: 674

  SELECT fft.sgl_acct_number,
         SUM(NVL(fft.amount,0)) amount
    FROM fv_facts_temp fft,
	 fv_facts_ussgl_accounts ffacc
   WHERE ffacc.ussgl_account = fft.sgl_acct_number
     AND fft.treasury_symbol_id = g_treasury_symbol_id
     AND fft.fct_int_record_category = 'REPORTED_NEW'
     AND fft.fct_int_record_type = 'BLK_DTL'
     AND fft.begin_end = 'E'
     AND ffacc.cancelled_flag = 'Y'
   GROUP BY fft.sgl_acct_number;

Line: 721

  SELECT ffacc.ussgl_account,
         NVL(sum(fft.amount),0),
         ffacc.ye_neg_receivables_flag,
         ffacc.natural_balance
    FROM fv_facts_temp fft,
	 fv_facts_ussgl_accounts ffacc
   WHERE (ffacc.ye_neg_receivables_flag = 'Y'
          OR ffacc.ye_neg_payables_flag = 'Y')
     AND ffacc.ussgl_account = fft.sgl_acct_number
     AND fft.treasury_symbol_id = g_treasury_symbol_id
     AND fft.fct_int_record_category = 'REPORTED_NEW'
     AND fft.fct_int_record_type = 'BLK_DTL'
     AND fft.begin_end = 'E'
  GROUP BY ffacc.ussgl_account, ffacc.ye_neg_receivables_flag, ffacc.natural_balance;

Line: 737

  SELECT ffacc.ussgl_account, nvl(sum(fft.amount),0),
	 ffacc.natural_balance
    FROM fv_facts_temp fft,
         fv_facts_ussgl_accounts ffacc
   WHERE ffacc.ye_general_flag = 'Y'
     AND ffacc.ussgl_account = fft.sgl_acct_number
     AND fft.treasury_symbol_id = g_treasury_symbol_id
     AND fft.fct_int_record_category = 'REPORTED_NEW'
     AND fft.fct_int_record_type = 'BLK_DTL'
     AND fft.begin_end = 'E'
   GROUP BY ffacc.ussgl_account, ffacc.natural_balance;

Line: 776

      SELECT DECODE (l_neg_receivables_flag,'Y','NR','NP')
      INTO l_acc_type
      FROM DUAL;

Line: 798

      update fv_facts_temp
      set    document_number = 'Y'
      where sgl_acct_number = l_ussgl_account
      and treasury_symbol_id = g_treasury_symbol_id
      and fct_int_record_category = 'REPORTED_NEW'
      and fct_int_record_type = 'BLK_DTL';

Line: 807

	UPDATE fv_facts_submission
	SET    foot_note_flag = 'Y'
	WHERE  treasury_symbol_id = g_treasury_symbol_id;

Line: 852

      update fv_facts_temp
      set    document_number = 'Y'
      where sgl_acct_number = l_ussgl_account
      and treasury_symbol_id = g_treasury_symbol_id
      and fct_int_record_category = 'REPORTED_NEW'
      and fct_int_record_type = 'BLK_DTL';

Line: 861

	UPDATE fv_facts_submission
	SET    foot_note_flag = 'Y'
	WHERE  treasury_symbol_id = g_treasury_symbol_id;

Line: 874

	UPDATE fv_facts_submission
	SET    foot_note_flag = 'N'
	WHERE  treasury_symbol_id = g_treasury_symbol_id;

Line: 906

  SELECT fft.sgl_acct_number,
	 ffa.disbursements_flag,
         ffa.collections_flag,
         ffa.edck12_balance_type,
	 nvl(amount,0) amount
    FROM fv_facts_temp fft,
	 fv_facts_ussgl_accounts ffa
   WHERE (ffa.disbursements_flag = 'Y' or ffa.collections_flag = 'Y')
     AND ffa.ussgl_account = fft.sgl_acct_number
     AND fft.treasury_symbol_id = g_treasury_symbol_id
     AND fft.fct_int_record_category = 'REPORTED_NEW'
     AND fft.fct_int_record_type = 'BLK_DTL'
     AND fft.begin_end = 'E';

Line: 931

    select decode(p_facts_run_quarter,1,sf224_qtr1_outlay,
		  2,sf224_qtr2_outlay,3,sf224_qtr3_outlay,sf224_qtr4_outlay)
      into l_224_outlays
      from fv_treasury_symbols
     where treasury_symbol_id = g_treasury_symbol_id;

Line: 960

                   SELECT fft.amount
		   INTO   v_begin_amount
    		   FROM   fv_facts_temp fft
   	 	   WHERE  fft.sgl_acct_number = check12_rec.sgl_acct_number
     		   AND fft.treasury_symbol_id = g_treasury_symbol_id
     		   AND fft.fct_int_record_category = 'REPORTED_NEW'
     		   AND fft.fct_int_record_type = 'BLK_DTL'
     		   AND fft.begin_end = 'B';

Line: 1046

    SELECT to_number(to_char(cancellation_date,'YYYY'))
    INTO   l_cancel_date
    FROM   fv_treasury_symbols
    WHERE  treasury_symbol_id = g_treasury_symbol_id;

Line: 1145

	INSERT INTO fv_facts_edit_check_status
		(treasury_symbol_id,
		 edit_check_number,
		 edit_check_status)
 	 VALUES (g_treasury_symbol_id,
		 p_edit_check_number,
		 p_edit_check_status) ;

Line: 1169

    Insert into FV_FACTS_TEMP
        (FCT_INT_RECORD_CATEGORY	,
	 TREASURY_SYMBOL_ID		,
	 TBAL_ACCT_NUM			,
	 FACTS_REPORT_INFO		,
	 edit_check_number		,
	 amount				,
	 amount1			,
	 amount2			,
	 sgl_acct_number		,
	 budget_function		)
    Values
	('FACTS2_EDIT_CHECK_LOG'	,
	 g_treasury_symbol_id		,
	 v_log_counter			,
	 text				,
	 v_edit_check_number		,
	 v_amount			,
	 v_amount1			,
	 v_amount2			,
	 v_sgl_acct_number		,
	 v_dummy_var			) ;