DBA Data[Home] [Help]

APPS.INVCIINT dependencies on HR_ORGANIZATION_UNITS

Line 3711: FROM HR_ORGANIZATION_UNITS HROU,

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

Line 3744: HR_ORGANIZATION_UNITS HROU

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

Line 3776: HR_ORGANIZATION_UNITS HROU

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