DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on HR_ORGANIZATION_UNITS

Line 1928: FROM HR_ORGANIZATION_UNITS HOU

1924:
1925: /* Need the Organization Id to fetch the records */
1926: SELECT MP.organization_id
1927: INTO l_org_hierarchy_level_id
1928: FROM HR_ORGANIZATION_UNITS HOU
1929: , HR_ORGANIZATION_INFORMATION HOI1
1930: , MTL_PARAMETERS MP
1931: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
1932: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID

Line 5840: FROM HR_ORGANIZATION_UNITS HOU

5836: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
5837:
5838: CURSOR c_organization_details IS
5839: SELECT MP.organization_id
5840: FROM HR_ORGANIZATION_UNITS HOU
5841: , HR_ORGANIZATION_INFORMATION HOI1
5842: , MTL_PARAMETERS MP
5843: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
5844: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID