DBA Data[Home] [Help]

APPS.OKS_ARFEEDER_PUB dependencies on HR_ORGANIZATION_INFORMATION

Line 108: HR_ORGANIZATION_INFORMATION OI2,

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

Line 109: HR_ORGANIZATION_INFORMATION OI1,

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'