eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_CONC_RES_PUB dependencies on PER_ALL_ASSIGNMENTS_F

Line 30: from per_all_assignments_f

26: l_job_id_temp NUMBER;
27:
28: CURSOR c_get_start_date(c_job_id IN NUMBER, c_person_id IN NUMBER, c_assignment_id NUMBER, c_assignment_type VARCHAR2) IS
29: select job_id, effective_start_date
30: from per_all_assignments_f
31: where person_id = c_person_id
32: -- and assignment_type = 'E'
33: and assignment_type = c_assignment_type
34: and primary_flag = 'Y'

Line 73: from per_all_assignments_f

69: l_job_id_temp NUMBER;
70:
71: CURSOR c_get_start_date(c_job_id IN NUMBER, c_person_id IN NUMBER, c_assignment_id NUMBER, c_assignment_type VARCHAR2) IS
72: select job_id, effective_start_date
73: from per_all_assignments_f
74: where person_id = c_person_id
75: -- and assignment_type = 'E'
76: and assignment_type = c_assignment_type
77: and primary_flag = 'Y'

Line 114: from per_all_assignments_f

110: l_asg_end_date DATE;
111:
112: CURSOR c_get_end_date(c_job_id IN NUMBER, c_person_id IN NUMBER, c_assignment_id NUMBER, c_assignment_type VARCHAR2) IS
113: select effective_end_date
114: from per_all_assignments_f
115: where person_id = c_person_id
116: -- and assignment_type = 'E'
117: and assignment_type = c_assignment_type
118: and primary_flag = 'Y'

Line 250: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

246: l_msg_data VARCHAR2(2000);
247: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
248: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
249: l_source_number jtf_rs_resource_extns.source_number%TYPE;
250: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
251: -- l_msg_index_out number;
252: -- l_msg_data1 varchar2(5000);
253:
254: -- Variables and Cursors added for Enh/Bug 2828368

Line 348: , per_all_assignments_f asg

344: , asg.assignment_id assignment_id
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

Line 413: , per_all_assignments_f asg

409: , asg.assignment_id assignment_id
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

Line 433: from per_all_assignments_f asg1

429: and asg.primary_flag = 'Y'
430: and (asg.assignment_type = 'E' OR asg.assignment_type = 'C')
431: -- and trunc(sysdate ) <= asg.effective_end_date -- (not required as start_date >= sysdate is already checked)
432: and asg.effective_start_date = (select min(asg1.effective_start_date)
433: from per_all_assignments_f asg1
434: where ppl.person_id = asg1.person_id
435: and asg1.effective_start_date >= trunc(sysdate)
436: and asg.primary_flag = 'Y')
437: and asg.job_id = job.job_id(+)

Line 1253: per_all_assignments_f asg,

1249: and rsc.category = 'EMPLOYEE')*/
1250: /*
1251: AND not exists (select ppl.person_id
1252: from per_all_people_f ppl,
1253: per_all_assignments_f asg,
1254: per_periods_of_service ser
1255: where ppl.person_id = rsc.source_id
1256: -- and rsc.category = 'EMPLOYEE'
1257: and trunc(sysdate) between ppl.effective_start_date and ppl.effective_end_date

Line 1515: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

1511: and g_run_date between effective_start_date and effective_end_date;
1512:
1513: l_ppf_rec c_ppf%ROWTYPE;
1514: l_source_number jtf_rs_resource_extns.source_number%TYPE;
1515: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1516:
1517: CURSOR c_org(p_org_id IN NUMBER) IS
1518: SELECT name
1519: FROM hr_all_organization_units

Line 1527: FROM per_all_assignments_f

1523: SELECT supervisor_id,
1524: location_id,
1525: job_id,
1526: assignment_id
1527: FROM per_all_assignments_f
1528: WHERE person_id = p_person_id
1529: AND primary_flag = 'Y'
1530: -- AND assignment_type = 'E'
1531: AND assignment_type in ('E','C')

Line 1818: FROM PER_ALL_ASSIGNMENTS_F

1814: WHERE role_id = l_role_id;
1815:
1816: CURSOR c_get_assignment_id(p_job_id IN NUMBER, p_person_id IN NUMBER) IS
1817: SELECT assignment_id
1818: FROM PER_ALL_ASSIGNMENTS_F
1819: WHERE job_id = p_job_id
1820: AND primary_flag = 'Y'
1821: -- AND assignment_type = 'E'
1822: AND assignment_type = p_assignment_type

Line 2930: per_all_assignments_f asg

2926: FROM JTF_RS_RESOURCE_EXTNS RES
2927: WHERE res.category = 'EMPLOYEE'
2928: AND not exists (select ppl.person_id
2929: from per_all_people_f ppl,
2930: per_all_assignments_f asg
2931: where ppl.person_id = res.source_id
2932: and res.category = 'EMPLOYEE'
2933: and trunc(sysdate) between ppl.effective_start_date and ppl.effective_end_date
2934: and ppl.employee_number is not null

Line 3056: --, per_all_assignments_f asg

3052: , ppl.party_id
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

Line 3072: from per_all_assignments_f

3068: --and ppl.person_id = asg.person_id
3069: --and asg.primary_flag = 'Y'
3070: --and asg.assignment_type = 'E'
3071: /*and asg.effective_start_date = (select max(effective_start_date)
3072: from per_all_assignments_f
3073: where person_id = ppl.person_id
3074: and primary_flag = 'Y'
3075: and assignment_type = 'E'
3076: ) */