DBA Data[Home] [Help]

APPS.INVCIINT dependencies on HR_ORGANIZATION_UNITS

Line 3712: FROM HR_ORGANIZATION_UNITS HROU,

3708: SELECT MP.Organization_Id,
3709: HROU.Date_From, HROU.Date_To
3710: INTO Temp_Master_Organization_Id,
3711: Temp_Date_From, Temp_Date_To
3712: FROM HR_ORGANIZATION_UNITS HROU,
3713: MTL_PARAMETERS MP
3714: WHERE MP.Organization_Id =
3715: P_Master_Organization_Id
3716: AND HROU.Organization_Id =

Line 3745: HR_ORGANIZATION_UNITS HROU

3741: HROU.Date_To
3742: INTO Temp_Master_Organization_Id, Temp_Date_From,
3743: Temp_Date_To
3744: FROM MTL_PARAMETERS MP,
3745: HR_ORGANIZATION_UNITS HROU
3746: WHERE MP.Organization_Code = P_Master_Organization_Code
3747: AND HROU.Organization_Id = MP.Organization_id;
3748:
3749: IF ((SQL%FOUND) AND

Line 3777: HR_ORGANIZATION_UNITS HROU

3773: INTO Temp_Master_Organization_Id, Temp_Date_From,
3774: Temp_Date_To
3775: FROM MTL_PARAMETERS MP,
3776: HR_ORGANIZATION_INFORMATION HROI,
3777: HR_ORGANIZATION_UNITS HROU
3778: WHERE HROU.Name = P_Master_Organization_Name
3779: AND MP.Organization_Id = HROU.Organization_Id
3780: AND HROI.Organization_Id = MP.Organization_Id
3781: AND HROI.Org_Information_Context = 'CLASS'