APPS.JTF_RS_CONC_RES_PUB dependencies on PER_JOBS

Line 349: , per_jobs job

345: , asg.assignment_type assignment_type
346: FROM per_all_people_f ppl
347: , hr_all_organization_units org
348: , per_all_assignments_f asg
349: , per_jobs job
350: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
351: , hr_locations_all loc
352: --, per_employees_current_x emp
353: , per_all_people_f emp

Line 414: , per_jobs job

410: , asg.assignment_type assignment_type
411: FROM per_all_people_f ppl
412: , hr_all_organization_units org
413: , per_all_assignments_f asg
414: , per_jobs job
415: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
416: , hr_locations_all loc
417: --, per_employees_current_x emp
418: , per_all_people_f emp

Line 1538: FROM per_jobs

1534: l_asg_rec c_asg%ROWTYPE;
1535:
1536: CURSOR c_job(p_job_id IN NUMBER) IS
1537: SELECT name
1538: FROM per_jobs
1539: WHERE job_id = p_job_id;
1540:
1541: CURSOR c_loc(p_loc_id IN NUMBER) IS
1542: SELECT address_line_1,

Line 1723: FROM per_jobs

1719: l_derived_job_id NUMBER;
1720:
1721: CURSOR c_derive_job_id (l_job_name VARCHAR2, l_business_group_id NUMBER) IS
1722: SELECT job_id
1723: FROM per_jobs
1724: WHERE NAME = l_job_name
1725: AND business_group_id = l_business_group_id;
1726:
1727: PROCEDURE update_job_roles

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

1776:
1777: l_salesrep_extsts varchar2(2);
1778: -- l_org_id number;
1779:
1780: -- CURSOR c_job_id (l_job_name IN per_jobs.name%TYPE) IS
1781: -- SELECT job_id
1782: -- FROM per_jobs
1783: -- WHERE name = l_job_name;
1784:

Line 1782: -- FROM per_jobs

1778: -- l_org_id number;
1779:
1780: -- CURSOR c_job_id (l_job_name IN per_jobs.name%TYPE) IS
1781: -- SELECT job_id
1782: -- FROM per_jobs
1783: -- WHERE name = l_job_name;
1784:
1785: CURSOR c_job_role_relations (l_role_id IN NUMBER, l_resource_id IN NUMBER) IS
1786: SELECT rr.role_relate_id, rr.object_version_number

Line 3057: --, per_jobs job

3053: , ppl.mailstop
3054: FROM per_all_people_f ppl
3055: , hr_all_organization_units org
3056: --, per_all_assignments_f asg
3057: --, per_jobs job
3058: --, hr_locations loc
3059: --, per_employees_current_x emp
3060: WHERE res.source_id = ppl.person_id
3061: /* AND NOT EXISTS (SELECT EMPLOYEE_ID