APPS.FV_FUNDS_AVAIL_PKG SQL Statements

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

Line: 43

    vg_select       VARCHAR2(2000);

Line: 163

  SELECT flex_value_set_id
    FROM fnd_id_flex_segments
   WHERE application_id = 101
     AND application_column_name =vg_acct_segment
     AND id_flex_code = vg_id_flex_code
     AND id_flex_num = vp_coa_id
     AND enabled_flag = 'Y' ;

Line: 264

      SELECT application_column_name
      FROM   Fnd_Id_Flex_Segments
      WHERE  application_id = vg_apps_id
      AND    id_flex_code   = vg_id_flex_code
      AND    id_flex_num    = vp_coa_id
      ORDER BY segment_num;

Line: 312

      SELECT segment_num
      FROM   Fnd_Id_Flex_Segments
      WHERE  application_id = vg_apps_id
      AND    id_flex_code   = vg_id_flex_code
      AND    id_flex_num    = vp_coa_id
      AND    application_column_name=p_application_column_name ;

Line: 376

    vg_select:= '' ;

Line: 382

                vg_select:= vg_select||'||'||''''||vg_delimiter
                ||''''||'||'||'glcc.'||vt_seg_name(i);

Line: 385

                vg_select:= vg_select||'glcc.'||vt_seg_name(i);

Line: 391

vg_select:= vg_select||' , glcc.'||vg_acct_segment||
            ' , glcc.' ||vg_bal_segment  ;

Line: 395

   FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' SELECT STATEMENT IS   ' ||VG_SELECT);

Line: 422

Populate_CCIDs(vg_select,vg_where);

Line: 455

    SELECT COUNT(1) INTO vl_fund  FROM FV_FUND_PARAMETERS
    WHERE TREASURY_SYMBOL_ID = vp_treasury_symbol_id
    AND  set_of_books_id = vp_sob_id ;

Line: 473

  vg_select:= 'glcc.'||vg_bal_segment||'||'||''''||vg_delimiter||''''||'||'||
            'glcc.'||vg_bfy_segment||' , glcc.'||vg_acct_segment ;

Line: 477

   FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' SELECT STATMENT WHEN PROCESS RUNS FOR TAS ' || VG_SELECT );

Line: 481

            '(SELECT FUND_VALUE FROM FV_FUND_PARAMETERS
            WHERE TREASURY_SYMBOL_ID = '||vp_treasury_symbol_id||
            ' AND FV_FUND_PARAMETERS.set_of_books_id= '||vp_sob_id||')' ;

Line: 485

  Populate_CCIDs(vg_select,vg_where);

Line: 507

    SELECT  application_column_name
    FROM    Fv_Pya_Fiscalyear_Segment
    WHERE   set_of_books_id = vp_sob_id ;

Line: 542

PROCEDURE Populate_CCIDs(   select_cl VARCHAR2,
                            where_cl  VARCHAR2)
 IS
  l_module_name VARCHAR2(200);

Line: 550

    vl_select_stmnt VARCHAR2(4000);

Line: 570

    SELECT COUNT(1) INTO vl_seed_count
    FROM  Fv_Funds_Avail_Rep_Def
    WHERE set_of_books_id = vp_sob_id
    AND Report_Id = vp_report_id ;

Line: 584

    SELECT COUNT(1) INTO vl_Acct_count
    FROM    Fv_Funds_Avail_Rep_Def  fvd ,
            Fv_Funds_Avail_Acct_Ranges fvr
    WHERE   fvr.column_id=fvd.column_id
    AND     fvr.set_of_books_id = vp_sob_id
    AND     Report_Id = vp_report_id ;

Line: 599

    SELECT period_year,
           period_num
      INTO l_period_year,
           l_period_num
      FROM gl_period_statuses
     WHERE application_id = 101
       AND set_of_books_id = vp_sob_id
       AND period_name = vp_period_name;

Line: 631

vl_select_stmnt :=
                  'SELECT  '||select_cl||
                  ' , fvd.report_id,  '||
                  ' fvr.column_id , '||
                    vg_amount ||
                  ' FROM  Fv_Funds_Avail_Rep_Def  fvd ,
                  Fv_Funds_Avail_Acct_Ranges fvr,
                  Gl_Code_Combinations glcc , Gl_Balances  glb
                  WHERE glcc.code_combination_id =
                  glb.code_combination_id  '||
                  '  AND  fvr.column_id=fvd.column_id '||
                  '  AND  fvr.set_of_books_id = :b_vp_sob_id ' ||
                  '  AND  fvd.set_of_books_id = :b_vp_sob_id ' ||
                  '  AND  glcc.template_id IS NULL ' ||
	          '  AND ( glcc.'||vg_acct_segment ||
                  '  BETWEEN  '|| ' fvr.account_from  ' ||
                  ' AND  '|| ' fvr.account_to  OR EXISTS '||
                  ' (SELECT 1 FROM fnd_flex_value_hierarchies h '||
                  ' WHERE  glcc.'||vg_acct_segment ||'  BETWEEN'  ||
                  ' child_flex_value_low AND child_flex_value_high '||
                  ' AND  h.flex_value_set_id = :b_vg_flex_value_id' ||
                  ' AND  h.PARENT_FLEX_VALUE BETWEEN  fvr.account_from '||
                  '  AND fvr.account_to )) '||
                  '  AND glcc.chart_of_accounts_id = :b_vp_coa_id'||
                  '  AND glb.ledger_id  = :b_vp_sob_id ' ||
                  '  AND glb.currency_code = :b_vp_currency_code '||
                  '  AND glb.period_name  = :b_vp_period_name'||
                  '  AND glb.actual_flag = '||''''||'A'||'''' ||
                  '  AND glcc.enabled_flag ='||''''||'Y'||'''' ||
                  '  AND  fvd.report_id  = :b_vp_report_id'   ||
                  '   AND  '||
                   where_cl || '   GROUP BY '||
                   select_cl ||
                   ' , fvd.report_id,  '||
                   ' fvr.column_id  '      ;

Line: 669

   FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SELECT STATEMENT TO GET DATA FROM GL BALANCES TABLE   ' ||VL_SELECT_STMNT);

Line: 674

OPEN vl_bal_retcur FOR vl_select_stmnt USING vp_sob_id,vp_sob_id,vg_flex_value_id,
vp_coa_id,vp_sob_id,vp_currency_code,vp_period_name,vp_report_id;

Line: 700

   FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' INSERTING INTO TEMP TABLE FROM GL GL_BALANCES  '|| I);

Line: 719

vl_select_stmnt := ' ' ;

Line: 741

vl_select_stmnt :=
				'SELECT  '||select_cl||
                ' , fvd.report_id,  '||
                ' fvr.column_id , '||
                vg_amount ||
                ' FROM  Fv_Funds_Avail_Rep_Def  fvd ,
                Fv_Funds_Avail_Acct_Ranges fvr,
                Gl_Code_Combinations glcc , Gl_Bc_Packets glbc
                WHERE glcc.code_combination_id =
                glbc.code_combination_id  '||
                '  AND  fvr.column_id=fvd.column_id '||
                '  AND  fvr.set_of_books_id = :b_vp_sob_id ' ||
                '  AND  fvd.set_of_books_id = :b_vp_sob_id ' ||
	        '  AND ( glcc.'||vg_acct_segment ||
                  '  BETWEEN  '|| ' fvr.account_from  ' ||
                  ' AND  '|| ' fvr.account_to  OR EXISTS '||
                  ' (SELECT 1 FROM fnd_flex_value_hierarchies h '||
                  ' WHERE  glcc.'||vg_acct_segment ||'  BETWEEN'  ||
                  ' child_flex_value_low AND child_flex_value_high '||
                  ' AND  h.flex_value_set_id = :b_vg_flex_value_id' ||
                  ' AND  h.PARENT_FLEX_VALUE BETWEEN  fvr.account_from '||
                  '  AND fvr.account_to )) '||
                '  AND glcc.chart_of_accounts_id = :b_vp_coa_id'||
                '  AND glbc.ledger_id = :b_vp_sob_id ' ||
                '  AND glbc.currency_code = :b_vp_currency_code '||
                '  AND glbc.period_year  <=  :b_vp_period_year'||
                '  AND glbc.period_num  <=  :b_vp_period_num'||
                '  AND glbc.actual_flag  =  '||''''||'A'||'''' ||
                '  AND glcc.enabled_flag ='||''''||'Y'||'''' ||
                '  AND glbc.status_code = '||''''||'A'||'''' ||
                '  AND glbc.template_id  IS NULL  '||
                '  AND  fvd.report_id  = :b_vp_report_id'  ||
                '   AND  '||
                where_cl || '   GROUP BY '||
                select_cl ||
                ' , fvd.report_id,  '||
                ' fvr.column_id  '      ;

Line: 781

   FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SELECT STATEMENT TO GET DATA FROM GL BC PACKETS TABLE   ' ||VL_SELECT_STMNT);

Line: 784

OPEN vl_bal_retcur FOR vl_select_stmnt USING vp_sob_id,vp_sob_id,vg_flex_value_id,
vp_coa_id,vp_sob_id,vp_currency_code,l_period_year, l_period_num, vp_report_id;

Line: 840

   SELECT treasury_symbol
   FROM fv_treasury_symbols
   WHERE treasury_symbol_id = vp_treasury_symbol_id ;

Line: 851

  SELECT COUNT(*) INTO vl_count FROM
  Fv_Funds_Avail_Temp WHERE
  report_id =vp_report_id ;

Line: 874

  SELECT COUNT(*) INTO vl_count FROM
  Fv_Funds_Avail_Temp WHERE
  report_id = vp_report_id AND
  amount <> 0;

Line: 937

     INSERT INTO Fv_Funds_Avail_temp (CONCAT_SEGMENTS,
                                     FUND_VALUE ,
                                     REPORT_ID  ,
                                     COLUMN_ID,
                                     AMOUNT ,
                                     SET_OF_BOOKS_ID)
        VALUES  (
                    CONCAT_SEGMENTS ,
                    FUND_VALUE ,
                    REPORT_ID   ,
                    COLUMN_ID   ,
                    AMOUNT  ,
                    SET_OF_BOOKS_ID );