DBA Data[Home] [Help]

APPS.RCV_TRANSACTION_PROCESSOR dependencies on HR_ORGANIZATION_INFORMATION

Line 80: FROM hr_organization_information hoi

76: BEGIN
77: IF NOT g_accounting_info.EXISTS(p_org_id) THEN
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'

Line 409: from hr_organization_information hoi,

405: rcv_table_functions.get_sob_row_from_id() to get the currency_code value and
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'