DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on HR_ORGANIZATION_INFORMATION

Line 814: FROM hr_organization_information hoi,

810: BEGIN
811: --Bug# 10019284
812: SELECT gl.chart_of_accounts_id
813: INTO l_chart
814: FROM hr_organization_information hoi,
815: hr_all_organization_units hou,
816: gl_sets_of_books gl
817: WHERE hoi.organization_id = hou.organization_id
818: AND hoi.org_information1 = TO_CHAR (gl.set_of_books_id)

Line 8635: FROM hr_organization_information src, hr_organization_information dest

8631: -- We need to get OU, so now using org_information3.
8632: --
8633: SELECT TO_NUMBER(src.org_information3) src_ou, TO_NUMBER(dest.org_information3) dest_ou
8634: INTO l_from_ou, l_to_ou
8635: FROM hr_organization_information src, hr_organization_information dest
8636: WHERE src.organization_id = l_orgid
8637: AND src.org_information_context = 'Accounting Information'
8638: AND dest.organization_id = l_xorgid
8639: AND dest.org_information_context = 'Accounting Information'