APPS.JTF_RS_CONC_RES_PUB dependencies on PER_JOBS

Line 407: , per_jobs job

403: , asg.assignment_type assignment_type
404: FROM per_all_people_f ppl
405: , hr_all_organization_units org
406: , per_all_assignments_f asg
407: , per_jobs job
408: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
409: , hr_locations_all loc
410: --, per_employees_current_x emp
411: , per_all_people_f emp

Line 472: , per_jobs job

468: , asg.assignment_type assignment_type
469: FROM per_all_people_f ppl
470: , hr_all_organization_units org
471: , per_all_assignments_f asg
472: , per_jobs job
473: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
474: , hr_locations_all loc
475: --, per_employees_current_x emp
476: , per_all_people_f emp

Line 1606: FROM per_jobs

1602: l_asg_rec c_asg%ROWTYPE;
1603:
1604: CURSOR c_job(p_job_id IN NUMBER) IS
1605: SELECT name
1606: FROM per_jobs
1607: WHERE job_id = p_job_id;
1608:
1609: CURSOR c_loc(p_loc_id IN NUMBER) IS
1610: SELECT address_line_1,

Line 1793: FROM per_jobs

1789: l_derived_job_id NUMBER;
1790:
1791: CURSOR c_derive_job_id (l_job_name VARCHAR2, l_business_group_id NUMBER) IS
1792: SELECT job_id
1793: FROM per_jobs
1794: WHERE NAME = l_job_name
1795: AND business_group_id = l_business_group_id;
1796: /*
1797: Bug13682589

Line 1878: -- CURSOR c_job_id (l_job_name IN per_jobs.name%TYPE) IS

1874:
1875: l_salesrep_extsts varchar2(2);
1876: -- l_org_id number;
1877:
1878: -- CURSOR c_job_id (l_job_name IN per_jobs.name%TYPE) IS
1879: -- SELECT job_id
1880: -- FROM per_jobs
1881: -- WHERE name = l_job_name;
1882:

Line 1880: -- FROM per_jobs

1876: -- l_org_id number;
1877:
1878: -- CURSOR c_job_id (l_job_name IN per_jobs.name%TYPE) IS
1879: -- SELECT job_id
1880: -- FROM per_jobs
1881: -- WHERE name = l_job_name;
1882:
1883: CURSOR c_job_role_relations (l_role_id IN NUMBER, l_resource_id IN NUMBER) IS
1884: SELECT rr.role_relate_id, rr.object_version_number,start_date_active

Line 3508: --, per_jobs job

3504: , ppl.mailstop
3505: FROM per_all_people_f ppl
3506: , hr_all_organization_units org
3507: --, per_all_assignments_f asg
3508: --, per_jobs job
3509: --, hr_locations loc
3510: --, per_employees_current_x emp
3511: WHERE res.source_id = ppl.person_id
3512: /* AND NOT EXISTS (SELECT EMPLOYEE_ID