DBA Data[Home] [Help]

APPS.INV_GLOBALS dependencies on HR_ORGANIZATION_INFORMATION

Line 343: FROM hr_organization_information

339: --
340: BEGIN
341: SELECT to_number(org_information1), to_number(org_information3)
342: INTO X_ACCOUNT_INFO1, X_ACCOUNT_INFO3
343: FROM hr_organization_information
344: WHERE organization_id = P_Org_Id
345: AND org_information_context = P_ENTITY_CONTEXT;
346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN

Line 360: hr_organization_information HOI

356: --
357: SELECT to_number(HOI.org_information1), to_number(HOI.org_information3), gsob.chart_of_accounts_id
358: INTO X_ACCOUNT_INFO1, X_ACCOUNT_INFO3, X_COA_ID
359: FROM gl_sets_of_books gsob,
360: hr_organization_information HOI
361: WHERE HOI.organization_id = P_Org_Id
362: AND HOI.org_information_context = P_ENTITY_CONTEXT
363: AND gsob.set_of_books_id = DECODE(P_ENTITY_CONTEXT,
364: 'Operating Unit Information',to_number(HOI.org_information3),