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 349: financials_system_params_all fsp,

345: added the following sql to get the currency_code */
346: select gsob.currency_code into
347: l_rt_row.currency_code
348: from hr_organization_information hoi,
349: financials_system_params_all fsp,
350: gl_sets_of_books gsob
351: where hoi.organization_id = l_rti_row.to_organization_id
352: and hoi.org_information_context||'' = 'Accounting Information'
353: and (fsp.org_id is null OR hoi.org_information3 = to_char(fsp.org_id))