DBA Data[Home] [Help]

APPS.INVCIINT dependencies on MTL_PARAMETERS

Line 3713: MTL_PARAMETERS MP

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

Line 3744: FROM MTL_PARAMETERS MP,

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

Line 3775: FROM MTL_PARAMETERS MP,

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