DBA Data[Home] [Help]

APPS.RCV_TRANSACTION_PROCESSOR dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 82: , financials_system_params_all fsp

78: SELECT COUNT(*)
79: INTO g_accounting_info(p_org_id)
80: FROM hr_organization_information hoi
81: , gl_sets_of_books gsob
82: , financials_system_params_all fsp
83: WHERE hoi.organization_id = p_org_id
84: AND hoi.org_information_context||'' = 'Accounting Information'
85: AND (fsp.org_id IS NULL OR hoi.org_information3 = TO_CHAR(fsp.org_id))
86: AND fsp.set_of_books_id = gsob.set_of_books_id;

Line 410: financials_system_params_all fsp,

406: added the following sql to get the currency_code */
407: select gsob.currency_code into
408: l_rt_row.currency_code
409: from hr_organization_information hoi,
410: financials_system_params_all fsp,
411: gl_sets_of_books gsob
412: where hoi.organization_id = l_rti_row.to_organization_id
413: and hoi.org_information_context||'' = 'Accounting Information'
414: and (fsp.org_id is null OR hoi.org_information3 = to_char(fsp.org_id))