DBA Data[Home] [Help]

APPS.INV_MGD_PRD_CONTROL_MEDIATOR dependencies on HR_ORGANIZATION_INFORMATION

Line 1246: , HR_ORGANIZATION_INFORMATION HOI

1242: , l_org_from_date
1243: FROM
1244: MTL_PARAMETERS MP
1245: , hr_organization_units HOU
1246: , HR_ORGANIZATION_INFORMATION HOI
1247: , gl_sets_of_books glstb
1248: WHERE HOU.ORGANIZATION_ID = p_org_hierarchy_origin
1249: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
1250: AND HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID

Line 2022: FROM hr_organization_information HOI

2018:
2019: IF l_allow_close = '1' THEN
2020: SELECT TO_NUMBER(HOI.org_information2)
2021: INTO l_legal_entity
2022: FROM hr_organization_information HOI
2023: WHERE HOI.org_information_context = 'Accounting Information'
2024: AND HOI.organization_id = l_orgid;
2025:
2026: l_le_sysdate := INV_LE_TIMEZONE_PUB.GET_LE_SYSDATE_FOR_OU(