DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PER_ALL_PEOPLE_F

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

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

Line 119: G_EMP_PERSON_ID per_all_people_f.person_id%type;

115: G_EMP_RATE_START_DATE date;
116: G_EMP_RATE_END_DATE date;
117:
118: --Globals for the Cache Attributes.
119: G_EMP_PERSON_ID per_all_people_f.person_id%type;
120: G_EMP_JOB_ID per_jobs.job_id%type;
121: G_EMP_ORGANIZATION_ID hr_organization_units.organization_id%type;
122:
123: -- Bug 3785956

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

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

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

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