APPS.PA_RATE_PVT_PKG dependencies on PER_JOBS

Line 381: FROM per_jobs

377: END IF;
378:
379: SELECT job_group_id
380: INTO l_forecast_job_group_id
381: FROM per_jobs
382: WHERE job_id = l_forecast_job_id;
383:
384: IF g1_debug_mode = 'Y' THEN
385: PA_DEBUG.g_err_stage := 'RTS13 : After Asgn job grp id par';

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