APPS.AP_WEB_DB_COUNTRY_PKG SQL Statements

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

Line: 10

		SELECT	territory_short_name,
			territory_code
		FROM	fnd_territories_vl;

Line: 39

	SELECT NVL(fndcvl.precision,0) precision
	INTO l_curr_precision
    	FROM   fnd_currencies_vl fndcvl
    	WHERE  fndcvl.currency_code = p_reimb_curr_code;

Line: 67

    SELECT fndcvl.currency_code,
	   fndcvl.name,
	   NVL(fndcvl.precision,0) precision,
           fndcvl.minimum_accountable_unit,
	   fndcvl.derive_factor,
	   fndcvl.derive_effective
    FROM   fnd_currencies_vl fndcvl
    WHERE  fndcvl.enabled_flag = 'Y'
    AND    fndcvl.currency_flag = 'Y'
    AND    trunc(nvl(fndcvl.start_date_active, sysdate)) <= trunc(sysdate)
    AND    trunc(nvl(fndcvl.end_date_active, sysdate)) >= trunc(sysdate)
    ORDER BY UPPER(fndcvl.currency_code);

Line: 100

        SELECT name
        INTO   p_curr_name
        FROM   fnd_currencies_vl
        WHERE  currency_code = p_curr_code;

Line: 125

	 SELECT fndcvl.name,
         	NVL(fndcvl.precision,0),
         	fndcvl.minimum_accountable_unit
	 INTO	p_curr_name,
		p_precision,
		p_minimum_acct_unit
         FROM   fnd_currencies_vl fndcvl
	 WHERE	currency_code = p_curr_code;

Line: 156

	SELECT 	fndcvl.name,
         	NVL(fndcvl.precision,0),
         	fndcvl.minimum_accountable_unit
	INTO	p_curr_name,
		p_precision,
		p_minimum_acct_unit
       	FROM   	fnd_currencies_vl fndcvl
	WHERE	currency_code = p_curr_code
      	AND    	fndcvl.enabled_flag = 'Y'
      	AND    	fndcvl.currency_flag = 'Y'
      	AND    	trunc(nvl(fndcvl.start_date_active, sysdate)) <= trunc(sysdate)
      	AND    	trunc(nvl(fndcvl.end_date_active, sysdate)) >= trunc(sysdate);

Line: 190

    	SELECT	fndcvl.currency_code
    	FROM   	fnd_currencies_vl fndcvl
-- chiho:1326239:
	WHERE	enabled_flag = 'Y'
    	ORDER BY UPPER(fndcvl.currency_code);