DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on HR_ORGANIZATION_UNITS

Line 1947: FROM HR_ORGANIZATION_UNITS HOU

1943:
1944: /* Need the Organization Id to fetch the records */
1945: SELECT MP.organization_id
1946: INTO l_org_hierarchy_level_id
1947: FROM HR_ORGANIZATION_UNITS HOU
1948: , HR_ORGANIZATION_INFORMATION HOI1
1949: , MTL_PARAMETERS MP
1950: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
1951: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID

Line 6313: FROM HR_ORGANIZATION_UNITS HOU

6309: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
6310:
6311: CURSOR c_organization_details IS
6312: SELECT MP.organization_id
6313: FROM HR_ORGANIZATION_UNITS HOU
6314: , HR_ORGANIZATION_INFORMATION HOI1
6315: , MTL_PARAMETERS MP
6316: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
6317: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID