APPS.FA_RETMT_TAX_REG_RPT_PKG SQL Statements

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

Line: 42

		SELECT company_name
		  INTO lp_company_name
		  FROM fa_system_controls;

Line: 51

		SELECT gl.currency_code
		  INTO lp_currency_code
		  FROM fa_book_controls fbc, gl_ledgers gl
		 WHERE book_type_code = p_book_name
		   AND fbc.set_of_books_id = gl.ledger_id;

Line: 84

 			SELECT TRUNC (fadp.calendar_period_open_date)
			  INTO period_from
			  FROM fa_deprn_periods fadp
			 WHERE fadp.book_type_code = p_book_name
			   AND fadp.period_name = p_from_period;

Line: 93

			SELECT TRUNC (fadp.calendar_period_close_date)
			  INTO period_to
			  FROM fa_deprn_periods fadp
			 WHERE fadp.book_type_code = p_book_name
			   AND fadp.period_name = p_to_period;

Line: 110

		SELECT fdfcu.application_column_name
		  INTO v_free_charge
		  FROM fnd_descr_flex_column_usages fdfcu
		 WHERE fdfcu.application_id = 140
		   AND UPPER (fdfcu.descriptive_flexfield_name) = 'FA_LOOKUPS'
		   AND UPPER (fdfcu.descriptive_flex_context_code) =
														UPPER ('Global Data Elements')
		   AND UPPER (fdfcu.end_user_column_name) = 'FREE_OF_CHARGE';

Line: 139

		SELECT company_name
		  INTO lp_com_name
		  FROM fa_system_controls;

Line: 156

		SELECT gl.currency_code
		  INTO lp_curr_code
		  FROM fa_book_controls fbc, gl_ledgers gl
		 WHERE book_type_code = p_book_name
		   AND fbc.set_of_books_id = gl.ledger_id;

Line: 174

			SELECT TRUNC (fadp.calendar_period_open_date)
			  INTO lp_from_date
			  FROM fa_deprn_periods fadp
			 WHERE fadp.book_type_code = p_book_name
			   AND fadp.period_name = p_from_period;

Line: 192

			SELECT TRUNC (fadp.calendar_period_close_date)
			  INTO lp_to_date
			  FROM fa_deprn_periods fadp
			 WHERE fadp.book_type_code = p_book_name
			   AND fadp.period_name = p_to_period;