APPS.FV_UTILITY SQL Statements

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

Line: 155

    SELECT to_char(SYSDATE, 'MM/DD/YYYY HH:MM:SS')
    INTO l_time
    FROM dual;

Line: 185

               select chart_of_accounts_id,currency_code into p_coa_id , p_currency
               from gl_ledgers_public_v
               where ledger_id = p_ledger_id;

Line: 291

	SELECT fcr.concurrent_program_id,
               fcr.parent_request_id,
               fr.responsibility_name,
               fa.description,
               fcr.requested_start_date,
               TO_CHAR(fcr.RESUBMIT_INTERVAL)||' '||fcr.RESUBMIT_INTERVAL_UNIT_CODE,
               fcr.actual_start_date,
               fcr.printer,
               fcr.number_of_copies,
               fcr.save_output_flag
        FROM   FND_CONCURRENT_REQUESTS FCR,
               FND_APPLICATION_VL FA,
               FND_RESPONSIBILITY_VL FR
	WHERE  fcr.responsibility_id = fr.responsibility_id
          AND  fcr.program_application_id = fa.application_id
          and  fcr.request_id = p_request_id;

Line: 309

		SELECT	parent_request_id,
                        request_type, description
		FROM	fnd_concurrent_requests
		WHERE	request_id = cp_parent_id;

Line: 408

     select substr(legal_entity_name,1,60)
     into v_organization_name
     from GL_LEDGER_LE_V
     where ledger_id =  v_set_of_books_id
     and rownum = 1
     order by  legal_entity_name;

Line: 438

    SELECT  a.period_name
    INTO    tfirst_period
    FROM    gl_period_statuses a, gl_period_statuses b
    WHERE   a.application_id = 101
    AND     b.application_id = 101
    AND     a.ledger_id = tset_of_books_id
    AND     b.ledger_id = tset_of_books_id
    AND     a.period_type = b.period_type
    AND     a.period_year = b.period_year
    AND     b.period_name = tperiod_name
    AND     a.period_num =
           (SELECT min(c.period_num)
              FROM gl_period_statuses c
             WHERE c.application_id = 101
               AND c.ledger_id = tset_of_books_id
               AND c.period_year = a.period_year
               AND c.period_type = a.period_type
          GROUP BY c.period_year);

Line: 548

SELECT flex_value, summary_flag, flex_value_set_id, parent_flex_value
    FROM fnd_flex_value_children_v
   WHERE (flex_value_set_id = p_flex_value_set_id) AND (parent_flex_value = p_parent_flex_value)
ORDER BY flex_value;

Line: 593

SELECT flexvalue.flex_value, flexvalue.summary_flag, fndidflex.flex_value_set_id
  FROM fnd_segment_attribute_values fndseg,
       fnd_id_flex_segments_vl fndidflex,
       fnd_flex_values_vl flexvalue
 WHERE fndseg.id_flex_num = p_coa_id
   AND fndseg.segment_attribute_type = 'GL_ACCOUNT'
   AND fndseg.id_flex_code = 'GL#'
   AND fndseg.attribute_value = 'Y'
   AND fndseg.application_column_name = fndidflex.application_column_name
   AND fndidflex.id_flex_num = p_coa_id
   AND fndidflex.id_flex_code = 'GL#'
   AND fndidflex.flex_value_set_id = flexvalue.flex_value_set_id
   AND flexvalue.enabled_flag = 'Y'
   and flexvalue.flex_value = p_flex_value;

Line: 654

	SELECT 	period_set_name
	INTO	vl_period_set_name
	FROM 	Gl_Sets_Of_Books
	WHERE	set_of_books_id	= sob_id;

Line: 676

	SELECT 	period_year
	INTO	period_year
	FROM 	Gl_Periods
	WHERE	period_set_name = vl_period_set_name
	AND	period_name	= period_from;

Line: 701

	SELECT start_date
	INTO	period_start_date
	FROM	Gl_Period_Statuses
	WHERE	ledger_id = sob_id
	AND	application_id = 101
	AND	period_year = period_year
	AND	period_name = period_from
	AND     adjustment_period_flag = 'N';

Line: 728

        SELECT end_date
        INTO    period_end_date
        FROM    Gl_Period_Statuses
        WHERE   ledger_id = sob_id
        AND     application_id = 101
        AND     period_year = period_year
        AND     period_name = period_to
	AND     adjustment_period_flag = 'N';

Line: 782

        SELECT papf.national_identifier
          INTO l_tin
          FROM per_all_people_f papf
         WHERE person_id = p_employee_id
           AND ROWNUM < 2;