DBA Data[Home] [Help]

APPS.FA_TAX_ACCT_CARD_PKG SQL Statements

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

Line: 45

	    SELECT   FSC.company_name
  	    INTO 	 lc_company_name
 	    FROM 	 fa_system_controls FSC;
Line: 60

        SELECT  GL.currency_code
 	    INTO    lc_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: 160

		   	SELECT 		FDFCU.application_column_name
		    INTO        p_dff_appln_colname
		    FROM   		fnd_descr_flex_column_usages FDFCU
		    WHERE  		FDFCU.application_id                       = p_appln_id
		    AND    		UPPER(FDFCU.descriptive_flexfield_name)    = UPPER(p_dff_name)
			AND         UPPER(FDFCU.descriptive_flex_context_code) = 'GLOBAL DATA ELEMENTS'
		    AND    		UPPER(FDFCU.end_user_column_name)          = UPPER(p_segment_name);