DBA Data[Home] [Help]

APPS.PA_BUDGET_ACCOUNT_PKG dependencies on PER_ALL_PEOPLE_F

Line 759: P_Person_ID IN PER_All_People_F.Person_ID%TYPE,

755: P_Resource_Group_ID IN PA_Resource_Types.Resource_Type_ID%TYPE,
756: P_Resource_Assign_ID IN PA_Budget_Lines.Resource_Assignment_Id%TYPE,
757: P_Start_Date IN PA_Budget_Lines.Start_Date%TYPE,
758:
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,

Line 798: l_Employee_number per_All_people_F.employee_number%TYPE;

794:
795: l_low_task_Id pa_tasks.task_Id%TYPE;
796: l_low_task_number pa_tasks.task_number%TYPE;
797:
798: l_Employee_number per_All_people_F.employee_number%TYPE;
799:
800: -- Added in FP_M for CWK changes
801: l_Person_Type PA_Employees.Person_Type%TYPE;
802:

Line 1653: p_person_Id IN per_All_people_F.person_Id%TYPE,

1649: P_Procedure_Name => 'Insert_Into_Budget_Lines');
1650: END Insert_Into_Budget_Lines ; /* End API Insert_Into_Budget_Lines */
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,

Line 1657: x_Employee_number OUT NOCOPY per_All_people_F.employee_number%TYPE,

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,
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,

Line 1697: PER_All_People_F

1693: INTO
1694: X_Employee_Number,
1695: X_Person_Type -- FP_M changes
1696: FROM
1697: PER_All_People_F
1698: WHERE
1699: Person_ID = P_Person_ID
1700: AND (Current_Employee_Flag = 'Y' OR Current_NPW_Flag = 'Y'); -- FP_M changes
1701: END;