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 348: from hr_organization_information hoi,

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