APPS.FII_GL_UTIL_PKG SQL Statements

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

Line: 183

   SELECT MIN(start_date) INTO g_min_start_date
   FROM fii_time_ent_period;

Line: 185

   SELECT MIN(start_date) INTO g_min_week_start_date
   FROM fii_time_week;

Line: 193

  	SELECT 1 into l_date_range_check FROM FII_TIME_DAY
  	where g_as_of_date between start_date and end_date;

Line: 206

     SELECT parent_manager_id
     INTO g_cc_owner
     FROM fii_com_cc_mappings
     WHERE company_cost_center_org_id = g_ccc_id;

Line: 217

   SELECT     dbi_enabled_flag INTO l_lob_enabled_flag
   FROM       fii_financial_dimensions
   WHERE      dimension_short_name = 'FII_LOB';

Line: 223

	SELECT  parent_lob_id INTO g_lob_id
	FROM    fii_lob_hierarchies;

Line: 232

        SELECT dbi_hier_top_node_id INTO g_lob_id
	FROM fii_financial_dimensions
	WHERE dimension_short_name = 'FII_LOB';

Line: 263

/* Commented out for bug 3893359 AND replaced with SELECT
  IF (g_as_of_date IS NOT NULL) THEN
    g_ent_pyr_start := fii_time_api.ent_pyr_start(g_as_of_date);

Line: 278

    SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_ent_cyr_end from dual;

Line: 279

	SELECT	NVL(fii_time_api.ent_pyr_start(g_as_of_date),g_min_start_date),
		NVL(fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),
		NVL(fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),
		NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)
	INTO	g_ent_pyr_start,
		g_ent_pyr_end,
		g_ent_cyr_start,
		g_p_period_end
	FROM	dual;

Line: 289

	SELECT	NVL(fii_time_api.ent_sd_lysper_end(g_p_period_end),g_min_start_date)
	INTO	g_p_p_period_end
	FROM	dual;

Line: 364

					SELECT MIN(ent_period_id), MAX(ent_period_id) INTO g_start_id, g_end_id
					FROM fii_time_ent_period
					WHERE ENT_PERIOD_ID =
						(SELECT ENT_PERIOD_ID FROM fii_time_ent_period
						 WHERE g_as_of_date BETWEEN start_date AND end_date);

Line: 371

					SELECT MIN(ent_period_id), MAX(ent_period_id) INTO g_start_id, g_end_id
					FROM fii_time_ent_period
					WHERE ENT_PERIOD_ID =
						(SELECT ENT_PERIOD_ID FROM fii_time_ent_period
						 WHERE g_as_of_date BETWEEN start_date AND end_date);

Line: 378

					SELECT MIN(ent_period_id), MAX(ent_period_id) INTO g_start_id, g_end_id
					FROM fii_time_ent_period
					WHERE ENT_QTR_ID =
						(SELECT ENT_QTR_ID FROM fii_time_ent_period
						 WHERE g_as_of_date BETWEEN start_date AND end_date);

Line: 385

					SELECT MIN(ent_period_id), MAX(ent_period_id) INTO g_start_id, g_end_id
					FROM fii_time_ent_period
					WHERE ENT_YEAR_ID =
						(SELECT ENT_YEAR_ID FROM fii_time_ent_period
						 WHERE g_as_of_date BETWEEN start_date AND end_date);

Line: 510

 SELECT NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date) INTO g_sd_lyr FROM dual;

Line: 517

       SELECT NVL(fii_time_api.cwk_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;

Line: 519

        SELECT	NVL(fii_time_api.cwk_end(g_previous_asof_date),g_min_start_date),
		NVL( fii_time_api.pwk_end(g_as_of_date),g_min_start_date),
		NVL( fii_time_api.sd_lyswk(g_as_of_date),g_min_start_date),
		NVL(DECODE(fii_time_api.cwk_start(g_as_of_date),g_min_week_start_date,g_min_start_date,fii_time_api.cwk_start(g_as_of_date)),g_min_start_date)
	INTO	g_py_sper_end,
		g_cy_period_end,
		g_py_sday,
		g_curr_start
	FROM    dual;

Line: 529

	SELECT	report_date_julian INTO g_curr_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;

Line: 530

	SELECT	report_date_julian INTO g_curr_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;

Line: 534

	SELECT	NVL(DECODE(fii_time_api.cwk_start(g_previous_asof_date),g_min_week_start_date,g_min_start_date,fii_time_api.cwk_start(g_previous_asof_date)),g_min_start_date),
		NVL( fii_time_api.cwk_end(g_previous_asof_date),g_min_start_date),
		NVL( fii_time_api.sd_lyswk(g_as_of_date),g_min_start_date)
	INTO    g_prior_start,
		g_prior_end,
		g_exp_asof_date
	FROM    dual;

Line: 542

	SELECT  NVL(fii_time_api.sd_lyswk(g_exp_asof_date),g_min_start_date)
	INTO    g_exp_start
	FROM    dual;

Line: 548

	SELECT	ent_period_start_date
	INTO	g_top_spend_start
	FROM	fii_time_day
	WHERE	report_date = g_as_of_date;

Line: 553

	SELECT	MAX(end_date) INTO g_top_spend_end
	FROM	fii_time_ent_period
	WHERE	ent_period_id = ( SELECT  ent_period_id
				  FROM	  fii_time_ent_period
			          WHERE   g_as_of_date BETWEEN start_date AND end_date);

Line: 561

	                        SELECT NVL( fii_time_api.cwk_start(g_as_of_date),g_min_start_date)
				INTO   g_prior_start
			        FROM	 dual;

Line: 566

		  	        SELECT NVL(fii_time_api.cwk_end(g_as_of_date),g_min_start_date) INTO g_prior_end FROM DUAL;

Line: 568

	  			SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;

Line: 569

				SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;

Line: 571

				SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_prior_start;

Line: 572

				SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_prior_end;

Line: 575

        SELECT NVL(fii_time_api.sd_lyswk(g_py_sday),g_min_start_date)
	INTO   g_rpt_begin_date
	FROM   dual;

Line: 581

        SELECT	DISTINCT a.sequence INTO g_curr_per_sequence
        FROM	fii_time_week a
        WHERE	g_as_of_date BETWEEN a.START_DATE AND a.END_DATE;

Line: 587

	        SELECT NVL(fii_time_api.ent_sd_lysper_beg(g_as_of_date),g_min_start_date)
		INTO    g_previous_asof_date
	        FROM    dual;

Line: 592

        SELECT NVL( fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),
               NVL(fii_time_api.ent_pper_end(g_as_of_date),g_min_start_date),
               NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date),
               NVL( fii_time_api.ent_sd_lysper_end(g_sd_lyr),g_min_start_date),
               NVL(fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
	       NVL(fii_time_api.ent_cper_start(g_previous_asof_date),g_min_start_date),
               NVL(fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),
               NVL(fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)
       INTO    g_py_sper_end,
               g_cy_period_end,
               g_py_sday,
               g_ppy_sday,
               g_curr_start,
               g_prior_start,
               g_prior_end,
               g_exp_asof_date
       FROM    dual;

Line: 610

       SELECT NVL(fii_time_api.ent_sd_lysper_end(g_exp_asof_date),g_min_start_date)
       INTO   g_exp_start
       FROM dual;

Line: 615

       SELECT NVL(fii_time_api.ent_cper_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;

Line: 617

       SELECT ent_period_id INTO g_curr_start_period_id FROM fii_time_ent_period WHERE start_date = g_curr_start;

Line: 618

       SELECT ent_period_id INTO g_curr_end_period_id FROM fii_time_ent_period WHERE end_date = g_curr_end;

Line: 619

       SELECT report_date_julian INTO g_curr_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;

Line: 620

       SELECT report_date_julian INTO g_curr_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;

Line: 626

       SELECT	 ent_period_start_date
       INTO	g_top_spend_start
       FROM	fii_time_day
       WHERE	report_date = g_as_of_date;

Line: 631

       SELECT	MAX(end_date)
       INTO	g_top_spend_end
       FROM	fii_time_ent_period
       WHERE	ent_period_id = ( SELECT  ent_period_id
			          FROM	  fii_time_ent_period
			          WHERE	  g_as_of_date BETWEEN start_date AND end_date);

Line: 640

			          SELECT NVL( fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date)
		                  INTO	 g_prior_start
	                          FROM	 dual;

Line: 645

				  SELECT NVL(fii_time_api.ent_cper_end(g_as_of_date),g_min_start_date) INTO g_prior_end FROM DUAL;

Line: 647

 				  SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;

Line: 648

			          SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;

Line: 650

				  SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_prior_start;

Line: 651

				  SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_prior_end;

Line: 654

       SELECT NVL( fii_time_api.ent_sd_lysper_end(g_py_sday),g_min_start_date)
       INTO   g_rpt_begin_date
       FROM   dual;

Line: 660

       SELECT	DISTINCT a.sequence INTO g_curr_per_sequence
       FROM	fii_time_ent_period a
       WHERE	g_as_of_date BETWEEN a.START_DATE AND a.END_DATE;

Line: 666

       SELECT NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date),
              NVL( fii_time_api.ent_pqtr_end(g_as_of_date),g_min_start_date),
              NVL( fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date),
              NVL(fii_time_api.ent_cqtr_start(g_as_of_date),g_min_start_date),
	      NVL(fii_time_api.ent_cqtr_start(g_previous_asof_date),g_min_start_date),
              NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date)
        INTO  g_py_sper_end,
              g_cy_period_end,
              g_py_sday,
              g_curr_start,
              g_prior_start,
              g_prior_end
        FROM  dual;

Line: 681

       SELECT NVL(fii_time_api.ent_cqtr_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;

Line: 683

       SELECT ent_period_id INTO g_curr_start_period_id FROM fii_time_ent_period WHERE start_date = g_curr_start;

Line: 684

       SELECT ent_period_id INTO g_curr_end_period_id FROM fii_time_ent_period WHERE end_date = g_curr_end;

Line: 685

       SELECT report_date_julian INTO g_curr_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;

Line: 686

       SELECT report_date_julian INTO g_curr_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;

Line: 690

       SELECT	ent_qtr_start_date
       INTO	g_top_spend_start
       FROM	fii_time_day
       WHERE	report_date = g_as_of_date;

Line: 695

       SELECT	MAX(end_date)
       INTO	g_top_spend_end
       FROM	fii_time_ent_period
       WHERE	ent_qtr_id =( SELECT	ent_qtr_id
			      FROM	fii_time_ent_period
			      WHERE	g_as_of_date BETWEEN start_date AND end_date);

Line: 702

       SELECT	NVL(fii_time_api.ent_sd_lysqtr_end(g_py_sday),g_min_start_date)
       INTO	g_rpt_begin_date
       FROM	dual;

Line: 708

		SELECT NVL(fii_time_api.ent_sd_lysqtr_end(g_rpt_begin_date),g_min_start_date)
		INTO   g_begin_date
		FROM   dual;

Line: 712

		SELECT DISTINCT a.ent_qtr_id INTO g_curr_per_sequence
		FROM   fii_time_ent_qtr a
		WHERE  g_as_of_date BETWEEN a.START_DATE AND a.END_DATE;

Line: 716

		SELECT  NVL(fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date)
		INTO    g_exp_asof_date
		FROM    dual;

Line: 720

		SELECT  NVL(fii_time_api.ent_sd_lysqtr_end(fii_time_api.ent_sd_lysqtr_end(g_exp_asof_date)),g_min_start_date)
		INTO    g_exp_begin_date
		FROM    dual;

Line: 726

		SELECT DISTINCT a.sequence INTO g_curr_per_sequence
		FROM   fii_time_ent_qtr a
		WHERE  g_as_of_date BETWEEN a.START_DATE AND a.END_DATE;

Line: 730

		SELECT  NVL(fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date)
                INTO	g_exp_asof_date
                FROM	dual;

Line: 738

       SELECT	NVL(fii_time_api.ent_sd_lysqtr_end(g_exp_asof_date),g_min_start_date)
       INTO	g_exp_start
       FROM	dual;

Line: 744

				SELECT NVL( fii_time_api.ent_cqtr_start(g_as_of_date),g_min_start_date)
				INTO   g_prior_start
				FROM   dual;

Line: 749

				SELECT NVL(fii_time_api.ent_cqtr_end(g_as_of_date),g_min_start_date) INTO g_prior_end from dual;

Line: 751

				SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;

Line: 752

				SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;

Line: 754

				SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_prior_start;

Line: 755

				SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_prior_end;

Line: 763

       SELECT NVL( fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),
              NVL( fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),
              NVL( fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
              NVL( fii_time_api.ent_cyr_start(g_previous_asof_date),g_min_start_date),
              NVL( fii_time_api.ent_cyr_end(g_previous_asof_date),g_min_start_date)
       INTO   g_py_sper_end,
              g_curr_start,
              g_temp,
              g_prior_start,
              g_prior_end
       FROM   dual;

Line: 776

       SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;

Line: 778

       SELECT ent_period_id INTO g_curr_start_period_id FROM fii_time_ent_period WHERE start_date = g_curr_start;

Line: 779

       SELECT ent_period_id INTO g_curr_end_period_id FROM fii_time_ent_period WHERE end_date = g_curr_end;

Line: 780

       SELECT report_date_julian INTO g_curr_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;

Line: 781

       SELECT report_date_julian INTO g_curr_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;

Line: 786

       SELECT	ent_year_start_date
       INTO	g_top_spend_start
       FROM	fii_time_day
       WHERE	report_date = g_as_of_date;

Line: 791

       SELECT	MAX(end_date)
       INTO	g_top_spend_end
       FROM	fii_time_ent_period
       WHERE	ent_year_id = (  SELECT ent_year_id
			      FROM fii_time_ent_period
			      WHERE g_as_of_date BETWEEN start_date AND end_date);

Line: 800

			  SELECT NVL( fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date)
                          INTO   g_prior_start
                          FROM   dual;

Line: 805

		          SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_prior_end from dual;

Line: 807

			  SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;

Line: 808

		          SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;

Line: 811

			  SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_prior_start;

Line: 812

			  SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_prior_end;

Line: 822

	SELECT start_date, end_date
	INTO g_detail_start, g_detail_end
	FROM fii_time_ent_period
	WHERE ent_period_id = g_month_id;

Line: 828

SELECT NVL(to_char(MIN(ent_period_id)),g_month_id)
INTO l_time_parameter
FROM fii_time_ent_period
WHERE g_as_of_date BETWEEN start_date AND end_date;

Line: 837

	SELECT end_date
	INTO g_new_date
	FROM fii_time_ent_period
	WHERE ent_period_id = g_month_id;

Line: 842

	SELECT NVL(fii_time_api.ent_sd_lysper_end(g_new_date),g_min_start_date)
        INTO   g_new_date2
        FROM   dual;

Line: 850

	SELECT NVL(fii_time_api.ent_sd_lyr_end(g_as_of_date),g_min_start_date)
        INTO   g_new_date2
        FROM   dual;

Line: 1067

        SELECT a.fin_category_id fin_category_id, b.PARENT_FIN_CAT_ID parent_fin_cat_id
        FROM fii_fin_cat_type_assgns a, fii_fin_item_hierarchies b
        WHERE a.FIN_CAT_TYPE_CODE IN (type1, type2, type3)
        AND a.TOP_NODE_FLAG = 'Y'
        AND a.fin_category_id = b.CHILD_FIN_CAT_ID
        AND a.fin_category_id <> b.PARENT_FIN_CAT_ID;

Line: 1202

        SELECT a.fin_category_id fin_category_id, b.PARENT_FIN_CAT_ID parent_fin_cat_id
        FROM fii_fin_cat_type_assgns a, fii_fin_item_hierarchies b
        WHERE a.FIN_CAT_TYPE_CODE = type1
        AND a.TOP_NODE_FLAG = 'Y'
        AND a.fin_category_id = b.CHILD_FIN_CAT_ID;

Line: 1760

   SELECT mgr_level INTO l_mgr_level
   FROM fii_cc_mgr_hierarchies
   WHERE EMP_ID = g_mgr_id
   AND DIRECT_ID = g_mgr_id
   AND MGR_ID = g_mgr_id;

Line: 1767

        SELECT distinct MGR_ID INTO l_mgr_mgr_id
        FROM fii_cc_mgr_hierarchies
        WHERE DIRECT_ID = g_mgr_id
        AND EMP_ID = g_mgr_id
        AND (DIRECT_LEVEL = 1 OR MGR_ID <> DIRECT_ID);

Line: 1775

    SELECT IS_LEAF_FLAG INTO g_mgr_is_leaf
    FROM fii_cc_mgr_hierarchies
    WHERE  EMP_ID = g_mgr_id
    AND MGR_ID = g_mgr_id;

Line: 1794

     SELECT IS_LEAF_FLAG INTO g_lob_is_leaf
     FROM   fii_lob_hierarchies
     WHERE  CHILD_LOB_ID = g_lob_id
            AND PARENT_LOB_ID = g_lob_id;

Line: 1821

		SELECT  1
		INTO    is_within_lob
		FROM	fii_com_cc_mappings mapp,
			fii_lob_hierarchies x
		WHERE   mapp.COMPANY_COST_CENTER_ORG_ID = g_ccc_id
			AND x.parent_lob_id = g_lob_id
			AND x.child_lob_id = mapp.parent_lob_id
			AND rownum = 1;

Line: 1851

    SELECT PARENT_FIN_CAT_ID INTO l_p_fin_id
    FROM fii_fin_item_hierarchies
    WHERE NEXT_LEVEL_FIN_CAT_ID = l_fin_id
    AND CHILD_FIN_CAT_ID = l_fin_id
    AND (NEXT_LEVEL = 1 or PARENT_FIN_CAT_ID <> NEXT_LEVEL_FIN_CAT_ID);

Line: 1860

	SELECT NEXT_LEVEL_IS_LEAF INTO g_fincat_is_leaf
	FROM fii_fin_item_hierarchies
	WHERE  CHILD_FIN_CAT_ID = l_fin_id
	AND NEXT_LEVEL_FIN_CAT_ID = l_fin_id
	AND PARENT_FIN_CAT_ID = l_fin_id;