APPS.FII_PSI_BUD_ENC_DETAIL_PKG SQL Statements

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

Line: 229

SELECT dbi_hier_top_node_id INTO l_child_cc_id
FROM fii_financial_dimensions
WHERE DIMENSION_SHORT_NAME = 'HRI_CL_ORGCC';

Line: 237

SELECT dbi_hier_top_node_id INTO l_child_company_id
FROM fii_financial_dimensions
WHERE DIMENSION_SHORT_NAME = 'FII_COMPANIES';

Line: 327

  SELECT to_char(end_date, 'DD/MM/YYYY') INTO l_as_of_date_2
  FROM fii_time_ent_period
  WHERE TRUNC(l_as_of_date) BETWEEN start_date AND end_date;

Line: 392

         	    SELECT  SEQUENCE INTO  l_months
           	    FROM fii_time_ent_period WHERE l_as_of_date  BETWEEN start_date AND end_date;

Line: 445

	    SELECT ENT_YEAR_ID, SEQUENCE INTO l_year_id, l_sequence
	    FROM fii_time_ent_qtr WHERE l_as_of_date  BETWEEN start_date AND end_date;

Line: 493

        SELECT  SEQUENCE INTO  l_months
        FROM fii_time_ent_period WHERE l_as_of_date  BETWEEN start_date AND end_date;

Line: 539

     SELECT ent_year_id, sequence INTO l_year_id, l_sequence
     FROM fii_time_ent_period WHERE l_as_of_date  BETWEEN start_date AND end_date;

Line: 585

      SELECT  sequence, ent_year_id  INTO  l_months, l_year_id
      FROM fii_time_ent_period WHERE l_as_of_date  BETWEEN start_date AND end_date;

Line: 653

        SELECT
               f.company_id                            FII_PSI_COL_COMPANY_ID,
               f.cost_center_id                        FII_PSI_COL_COST_CENTER_ID,
               f.fin_category_id                       FII_PSI_COL_FIN_CAT_ID,
               TO_NUMBER(NULL)                         FII_PSI_XTD,';

Line: 713

         SELECT
	        FII_PSI_COL_COMPANY,
	        FII_PSI_COL_COMPANY_ID,
	        FII_PSI_COL_COST_CENTER,
	        FII_PSI_COL_COST_CENTER_ID,
                FII_PSI_COL_FIN_CAT,
                FII_PSI_COL_FIN_CAT_ID,
                FII_PSI_COL_FIN_CAT_DESP,
     	        FII_PSI_XTD,';

Line: 746

          SELECT
	        com_flex.FLEX_VALUE_MEANING            FII_PSI_COL_COMPANY,
                                	               FII_PSI_COL_COMPANY_ID,
	        cc_flex.FLEX_VALUE_MEANING             FII_PSI_COL_COST_CENTER,
	                                               FII_PSI_COL_COST_CENTER_ID,
                fin_flex.FLEX_VALUE_MEANING            FII_PSI_COL_FIN_CAT,
                                                       FII_PSI_COL_FIN_CAT_ID,
    	        com_flex.DESCRIPTION||''.''||cc_flex.DESCRIPTION||''.''||fin_flex.DESCRIPTION
                                                       FII_PSI_COL_FIN_CAT_DESP,
                            sum(FII_PSI_XTD)                     FII_PSI_XTD,';

Line: 776

         (SELECT
	       f.company_id                            FII_PSI_COL_COMPANY_ID,
	       f.cost_center_id                        FII_PSI_COL_COST_CENTER_ID,
               f.fin_category_id                       FII_PSI_COL_FIN_CAT_ID,   ' || l_amt_columns || '
 	FROM
	       fii_gl_local_snap_f'||l_curr_view||'  f
               '||l_company_id_from||l_fin_category_id_from||'
	WHERE f.year_id = :YEAR_ID
	AND f.fin_cat_type_code = '''||p_fin_cat||'''
        '||l_amt_where||'
        '||l_company_id_where||l_fin_category_id_where||l_fud1_where||l_fud2_where||'
	'||l_ledger_where||'
	GROUP BY f.company_id,
                 f.cost_center_id,
                 f.fin_category_id';