DBA Data[Home] [Help]

APPS.INVCIINT dependencies on MTL_PARAMETERS

Line 3712: MTL_PARAMETERS MP

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 =
3716: MP.Organization_Id;

Line 3743: FROM MTL_PARAMETERS MP,

3739: SELECT MP.Organization_Id, HROU.Date_From,
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:

Line 3774: FROM MTL_PARAMETERS MP,

3770: SELECT MP.Organization_Id, HROU.Date_From,
3771: HROU.Date_To
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