DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PER_ALL_PEOPLE_F

Line 62: procedure get_labor_rate ( p_person_id IN per_all_people_f.person_id%TYPE

58: -- Expenditure Org Id of the Transaction .
59: -- Version : Current version 1.0
60: -- Initial version 1.0
61: -- End of comments
62: procedure get_labor_rate ( p_person_id IN per_all_people_f.person_id%TYPE
63: ,p_txn_date IN date
64: ,p_calling_module IN varchar2 default 'STAFFED'
65: ,p_org_id IN pa_expenditures_all.org_id%TYPE default NULL /*2879644*/
66: ,x_job_id IN OUT NOCOPY pa_expenditure_items_all.job_id%TYPE

Line 115: G_EMP_PERSON_ID per_all_people_f.person_id%type;

111: G_EMP_RATE_START_DATE date;
112: G_EMP_RATE_END_DATE date;
113:
114: --Globals for the Cache Attributes.
115: G_EMP_PERSON_ID per_all_people_f.person_id%type;
116: G_EMP_JOB_ID per_jobs.job_id%type;
117: G_EMP_ORGANIZATION_ID hr_organization_units.organization_id%type;
118:
119: -- Bug 3785956

Line 145: Function GetEmpCostRate( P_Person_Id IN per_all_people_f.person_id%type

141: -- 03-OCT-02 Vgade -Created
142: --
143: /*----------------------------------------------------------------------------*/
144:
145: Function GetEmpCostRate( P_Person_Id IN per_all_people_f.person_id%type
146: ,P_Job_Id IN pa_expenditure_items_all.job_id%type
147: ,P_Organization_Id IN pa_expenditures_all.incurred_by_organization_id%type
148: ,P_Effective_Date IN date default SYSDATE
149: ,P_Rate_Type IN varchar2

Line 177: Function GetEmpCostRateInfo( P_Person_Id IN per_all_people_f.person_id%type

173: -- 03-OCT-02 Vgade -Created
174: --
175: /*----------------------------------------------------------------------------*/
176:
177: Function GetEmpCostRateInfo( P_Person_Id IN per_all_people_f.person_id%type
178: ,P_Job_Id IN pa_expenditure_items_all.job_id%type
179: ,P_Organization_Id IN pa_expenditures_all.incurred_by_organization_id%type
180: ,P_Effective_Date IN date default SYSDATE
181: ,P_Rate_Attribute IN varchar2