DBA Data[Home] [Help]

APPS.PA_RATE_PVT_PKG dependencies on PER_JOBS_V

Line 822: from per_jobs_v

818: if p_person_id is not null then
819:
820: select name
821: into pa_pay_util.g_job_name
822: from per_jobs_v
823: where job_id = pa_utils.getempjobid(X_person_id => p_person_id, X_date => p_rate_calc_date);
824: select location_code
825: into pa_pay_util.g_location_code
826: from hr_locations a, per_all_assignments_f b

Line 2544: from per_jobs_v

2540: if p_person_id is not null then
2541: if p_forecast_job_id is null then
2542: select name
2543: into pa_pay_util.g_job_name
2544: from per_jobs_v
2545: where job_id = pa_utils.getempjobid(X_person_id => p_person_id, X_date => p_asgn_start_date);
2546: end if;
2547:
2548: select location_code

Line 2559: from per_jobs_v

2555:
2556: elsif p_forecast_job_id is not null then
2557: select name
2558: into pa_pay_util.g_job_name
2559: from per_jobs_v
2560: where job_id = p_forecast_job_id;
2561: end if;
2562:
2563: -- get the project number and task number details