DBA Data[Home] [Help]

APPS.PA_BUDGET_ACCOUNT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 279: HR_All_Organization_Units ORG,

275: l_Project_Type,
276: l_Project_Start_Date,
277: l_Project_End_Date
278: FROM
279: HR_All_Organization_Units ORG,
280: PA_Projects PROJ
281: WHERE
282: PROJ.Project_ID = P_Project_ID
283: AND ORG.Organization_ID = PROJ.Carrying_Out_Organization_ID ;

Line 763: P_Organization_ID IN HR_All_Organization_Units.Organization_ID%TYPE,

759: P_Person_ID IN PER_All_People_F.Person_ID%TYPE,
760: P_Expenditure_Category IN PA_Expenditure_Categories.Expenditure_Category%TYPE,
761: P_Expenditure_Type IN PA_Expenditure_Types.Expenditure_Type%TYPE,
762: P_Job_ID IN PER_Jobs.Job_ID%TYPE,
763: P_Organization_ID IN HR_All_Organization_Units.Organization_ID%TYPE,
764: P_Supplier_ID IN PO_Vendors.Vendor_ID%TYPE,
765:
766: X_Return_CCID OUT NOCOPY GL_Code_Combinations.Code_Combination_ID%TYPE,
767: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1655: p_organization_Id IN hr_All_organization_units.organization_Id%TYPE,

1651:
1652: PROCEDURE Derive_Resource_Params (
1653: p_person_Id IN per_All_people_F.person_Id%TYPE,
1654: p_Job_Id IN per_Jobs.job_Id%TYPE,
1655: p_organization_Id IN hr_All_organization_units.organization_Id%TYPE,
1656: p_supplier_Id IN po_vendors.vendor_Id%TYPE,
1657: x_Employee_number OUT NOCOPY per_All_people_F.employee_number%TYPE,
1658: x_Person_Type OUT NOCOPY PA_Employees.Person_Type%TYPE,
1659: x_Job_name OUT NOCOPY per_Jobs.name%TYPE,

Line 1662: x_organization_type OUT NOCOPY hr_All_organization_units.type%TYPE,

1658: x_Person_Type OUT NOCOPY PA_Employees.Person_Type%TYPE,
1659: x_Job_name OUT NOCOPY per_Jobs.name%TYPE,
1660: x_Job_Group_Id OUT NOCOPY per_Jobs.job_Group_Id%TYPE,
1661: x_Job_Group_name OUT NOCOPY per_Job_Groups.internal_name%TYPE,
1662: x_organization_type OUT NOCOPY hr_All_organization_units.type%TYPE,
1663: x_organization_name OUT NOCOPY hr_All_organization_units.name%TYPE,
1664: x_supplier_name OUT NOCOPY po_vendors.vendor_name%TYPE,
1665: X_Return_Status OUT NOCOPY VARCHAR2,
1666: X_Msg_Count OUT NOCOPY NUMBER,

Line 1663: x_organization_name OUT NOCOPY hr_All_organization_units.name%TYPE,

1659: x_Job_name OUT NOCOPY per_Jobs.name%TYPE,
1660: x_Job_Group_Id OUT NOCOPY per_Jobs.job_Group_Id%TYPE,
1661: x_Job_Group_name OUT NOCOPY per_Job_Groups.internal_name%TYPE,
1662: x_organization_type OUT NOCOPY hr_All_organization_units.type%TYPE,
1663: x_organization_name OUT NOCOPY hr_All_organization_units.name%TYPE,
1664: x_supplier_name OUT NOCOPY po_vendors.vendor_name%TYPE,
1665: X_Return_Status OUT NOCOPY VARCHAR2,
1666: X_Msg_Count OUT NOCOPY NUMBER,
1667: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1738: HR_All_organization_units ORG

1734: INTO
1735: x_organization_name,
1736: x_organization_type
1737: FROM
1738: HR_All_organization_units ORG
1739: WHERE
1740: ORG.organization_Id = P_Organization_ID;
1741: END;
1742: END IF;

Line 1819: HR_All_Organization_Units ORG,

1815: X_Task_Organization_ID,
1816: X_Task_Organization_Name,
1817: X_Task_Service_Type
1818: FROM
1819: HR_All_Organization_Units ORG,
1820: PA_Tasks TOP_TASK
1821: WHERE
1822: TOP_TASK.task_Id = p_top_task_Id
1823: AND TOP_TASK.Top_Task_ID = TOP_TASK.Task_ID