104:
105: Cursor l_org_csr (p_org_id NUMBER) Is
106: SELECT OI2.ORG_INFORMATION3 set_of_books_id
107: FROM
108: HR_ORGANIZATION_INFORMATION OI2,
109: HR_ORGANIZATION_INFORMATION OI1,
110: HR_ALL_ORGANIZATION_UNITS OU
111: WHERE oi1.organization_id = ou.organization_id
112: AND oi2.organization_id = ou.organization_id
105: Cursor l_org_csr (p_org_id NUMBER) Is
106: SELECT OI2.ORG_INFORMATION3 set_of_books_id
107: FROM
108: HR_ORGANIZATION_INFORMATION OI2,
109: HR_ORGANIZATION_INFORMATION OI1,
110: HR_ALL_ORGANIZATION_UNITS OU
111: WHERE oi1.organization_id = ou.organization_id
112: AND oi2.organization_id = ou.organization_id
113: AND oi1.org_information_context = 'CLASS'