APPS.FV_FACTS_EDIT_CHECK SQL Statements

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

Line: 62

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

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

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

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

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

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

  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 = p_ledger_id;

Line: 543

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

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

   SELECT preclosing_unexpended_amt
     INTO l_unexp_amount
     FROM fv_treasury_symbols
    WHERE treasury_symbol_id = g_treasury_symbol_id;

Line: 672

  SELECT NVL(SUM(DECODE(fft.begin_end, 'B', -1*NVL(fft.amount,0), NVL(fft.amount,0))), 0) obligations_incurred_s_amt
    FROM fv_facts_temp fft,
         fv_facts_ussgl_accounts ffa
   WHERE ffa.obligations_incurred_flag = 'Y'
     AND ffa.ussgl_account = fft.sgl_acct_number
     AND fft.treasury_symbol_id = p_treasury_symbol_id
     AND fft.fct_int_record_category = 'REPORTED_NEW'
     AND fft.fct_int_record_type = 'BLK_DTL';

Line: 690

  SELECT NVL(SUM(DECODE(fft.begin_end, 'B', -1*NVL(fft.amount,0), NVL(fft.amount,0))), 0) spndng_from_coll_and_pya_s_amt
    FROM fv_facts_temp fft,
         fv_facts_ussgl_accounts ffa
   WHERE ffa.spndng_from_coll_and_pya_flag = 'Y'
     AND ffa.ussgl_account = fft.sgl_acct_number
     AND fft.treasury_symbol_id = p_treasury_symbol_id
     AND fft.fct_int_record_category = 'REPORTED_NEW'
     AND fft.fct_int_record_type = 'BLK_DTL';

Line: 707

  SELECT SUM(NVL(amount,0)) obligations_as_of_10_1_amt
    FROM fv_facts_temp fft,
         fv_facts_ussgl_accounts ffa
   WHERE ffa.obligations_as_of_10_1_flag = 'Y'
     AND ffa.ussgl_account = fft.sgl_acct_number
     AND fft.treasury_symbol_id = p_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: 724

  SELECT NVL(SUM(DECODE(ffa.obligations_transferred_flag, 'Y', NVL(amount,0), 0)),0) obligations_transferred_amt,
         NVL(SUM(DECODE(ffa.obligations_period_end_flag, 'Y', NVL(amount,0), 0)),0) obligations_period_end_amt
    FROM fv_facts_temp fft,
         fv_facts_ussgl_accounts ffa
   WHERE (
           ffa.obligations_transferred_flag = 'Y' OR
           ffa.obligations_period_end_flag = 'Y'
         )
     AND ffa.ussgl_account = fft.sgl_acct_number
     AND fft.treasury_symbol_id = p_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: 745

  SELECT NVL(SUM(DECODE(ffa.disbursements_flag, 'Y', NVL(amount,0), 0)),0) disbursements_amt,
         NVL(SUM(DECODE(ffa.collections_flag, 'Y', NVL(amount,0), 0)),0) collections_amt
    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 = p_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 ffa.edck12_balance_type IN ('E' ,'S');--  by ks for bug bug 5328107

Line: 769

  SELECT NVL(SUM(DECODE(fft.begin_end, 'B', -1*NVL(fft.amount,0),0)), 0) beg_disbursements_amt
    FROM fv_facts_temp fft,
         fv_facts_ussgl_accounts ffa
   WHERE ffa.disbursements_flag = 'Y'
     AND ffa.ussgl_account = fft.sgl_acct_number
     AND fft.treasury_symbol_id = p_treasury_symbol_id
     AND fft.fct_int_record_category = 'REPORTED_NEW'
     AND fft.fct_int_record_type = 'BLK_DTL'
     AND ffa.edck12_balance_type = 'S';

Line: 787

  SELECT NVL(SUM(DECODE(fft.begin_end, 'B', -1*NVL(fft.amount,0), 0)), 0) beg_collections_amt
    FROM fv_facts_temp fft,
         fv_facts_ussgl_accounts ffa
   WHERE ffa.collections_flag = 'Y'
     AND ffa.ussgl_account = fft.sgl_acct_number
     AND fft.treasury_symbol_id = p_treasury_symbol_id
     AND fft.fct_int_record_category = 'REPORTED_NEW'
     AND fft.fct_int_record_type = 'BLK_DTL'
     AND ffa.edck12_balance_type = 'S';

Line: 947

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

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

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

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

Line: 1069

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

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

Line: 1124

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

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

Line: 1146

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

Line: 1174

  SELECT fft.sgl_acct_number,
	 ffa.disbursements_flag,
         ffa.collections_flag,
         ffa.edck12_balance_type,
	 sum(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'
    group by
          fft.sgl_acct_number,
	 ffa.disbursements_flag,
         ffa.collections_flag,
         ffa.edck12_balance_type;

Line: 1203

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

                   SELECT sum(nvl(fft.amount,0))
		   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: 1321

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

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

    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			) ;