DBA Data[Home] [Help]

APPS.JG_JGZZFALE_XMLP_PKG SQL Statements

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

Line: 164

	select
		nvl(max(lu.meaning), 'No Report Title in FND_LOOKUPS.MEANING for lookup_type JGZZ_JGSTRGRH_TITLE')
	into
		RP_REPORT_NAME
	from
		fnd_lookups lu
	where
		lu.lookup_type = 'JGZZ_JGSTRGRH_TITLE' and
		lu.lookup_code = 'LEDGER';
Line: 181

	SELECT
		SC.COMPANY_NAME,
		BC.SET_OF_BOOKS_ID,
		SOB.NAME SOB_NAME,
		SOB.Currency_Code,
		CUR.Precision,
		SC.ASSET_KEY_FLEX_STRUCTURE,
		BC.Accounting_Flex_Structure
	INTO
		RP_COMPANY_NAME,
		RP_SOB_ID,
		RP_SOB_NAME,
		RP_CURRENCY_CODE,
		RP_PRECISION,
		asset_key_flex_struct,
		acct_flex_structure
	FROM
		FA_SYSTEM_CONTROLS	SC,
		FA_BOOK_CONTROLS 	BC,
		GL_LEDGERS_PUBLIC_V 	SOB,
		FND_CURRENCIES		CUR
	WHERE
		BC.Book_Type_Code = nvl(P_BOOK_TYPE_CODE, bc.book_type_code)
	AND	SOB.Ledger_ID = BC.Set_Of_Books_ID
	AND	CUR.Currency_Code = SOB.Currency_Code
	AND	rownum = 1;