APPS.PAY_SA_GOSI_REPORTS dependencies on PER_JOBS

Line 394: from per_jobs pj, per_all_assignments_f paf

390: /*****end of new code*******/
391: --cursor to get job name for the newly hired employees
392: cursor get_job(p_assignment_id number,p_date date) is
393: select name
394: from per_jobs pj, per_all_assignments_f paf
395: where pj.job_id = paf.job_id
396: and paf.assignment_id = p_assignment_id
397: and trunc(p_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date;
398: --cursor to get the passport number of the newly hired employees

Line 2764: from per_jobs pj,

2760: --and l_effective_date between peo.effective_start_date and peo.effective_end_date;
2761: /*Cursor to pick up Employee's Job Name*/
2762: cursor get_job (l_assignment_id NUMBER, l_effective_date Date) is
2763: select name
2764: from per_jobs pj,
2765: per_all_assignments_f paa
2766: where pj.job_id = paa.job_id
2767: and paa.business_group_id = pj.business_group_id
2768: and paa.assignment_id = l_assignment_id;