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 88: from per_all_assignments_f

84: l_job_id_temp NUMBER;
85:
86: CURSOR c_get_start_date(c_job_id IN NUMBER, c_person_id IN NUMBER, c_assignment_id NUMBER, c_assignment_type VARCHAR2) IS
87: select job_id, effective_start_date
88: from per_all_assignments_f
89: where person_id = c_person_id
90: -- and assignment_type = 'E'
91: and assignment_type = c_assignment_type
92: and primary_flag = 'Y'

Line 131: from per_all_assignments_f

127: l_job_id_temp NUMBER;
128:
129: CURSOR c_get_start_date(c_job_id IN NUMBER, c_person_id IN NUMBER, c_assignment_id NUMBER, c_assignment_type VARCHAR2) IS
130: select job_id, effective_start_date
131: from per_all_assignments_f
132: where person_id = c_person_id
133: -- and assignment_type = 'E'
134: and assignment_type = c_assignment_type
135: and primary_flag = 'Y'

Line 172: from per_all_assignments_f

168: l_asg_end_date DATE;
169:
170: CURSOR c_get_end_date(c_job_id IN NUMBER, c_person_id IN NUMBER, c_assignment_id NUMBER, c_assignment_type VARCHAR2) IS
171: select effective_end_date
172: from per_all_assignments_f
173: where person_id = c_person_id
174: -- and assignment_type = 'E'
175: and assignment_type = c_assignment_type
176: and primary_flag = 'Y'

Line 308: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

304: l_msg_data VARCHAR2(2000);
305: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
306: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
307: l_source_number jtf_rs_resource_extns.source_number%TYPE;
308: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
309: -- l_msg_index_out number;
310: -- l_msg_data1 varchar2(5000);
311:
312: -- Variables and Cursors added for Enh/Bug 2828368

Line 406: , per_all_assignments_f asg

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

Line 471: , per_all_assignments_f asg

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

Line 491: from per_all_assignments_f asg1

487: and asg.primary_flag = 'Y'
488: and (asg.assignment_type = 'E' OR asg.assignment_type = 'C')
489: -- and trunc(sysdate ) <= asg.effective_end_date -- (not required as start_date >= sysdate is already checked)
490: and asg.effective_start_date = (select min(asg1.effective_start_date)
491: from per_all_assignments_f asg1
492: where ppl.person_id = asg1.person_id
493: and asg1.effective_start_date >= trunc(sysdate)
494: and asg.primary_flag = 'Y')
495: and asg.job_id = job.job_id(+)

Line 1311: per_all_assignments_f asg,

1307: and rsc.category = 'EMPLOYEE')*/
1308: /*
1309: AND not exists (select ppl.person_id
1310: from per_all_people_f ppl,
1311: per_all_assignments_f asg,
1312: per_periods_of_service ser
1313: where ppl.person_id = rsc.source_id
1314: -- and rsc.category = 'EMPLOYEE'
1315: and trunc(sysdate) between ppl.effective_start_date and ppl.effective_end_date

Line 1583: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

1579: current_npw_flag = 'Y');
1580:
1581: l_ppf_rec c_ppf%ROWTYPE;
1582: l_source_number jtf_rs_resource_extns.source_number%TYPE;
1583: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1584:
1585: CURSOR c_org(p_org_id IN NUMBER) IS
1586: SELECT name
1587: FROM hr_all_organization_units

Line 1595: FROM per_all_assignments_f

1591: SELECT supervisor_id,
1592: location_id,
1593: job_id,
1594: assignment_id
1595: FROM per_all_assignments_f
1596: WHERE person_id = p_person_id
1597: AND primary_flag = 'Y'
1598: -- AND assignment_type = 'E'
1599: AND assignment_type in ('E','C')

Line 1934: FROM PER_ALL_ASSIGNMENTS_F

1930: WHERE role_id = l_role_id;
1931:
1932: CURSOR c_get_assignment_id(p_job_id IN NUMBER, p_person_id IN NUMBER) IS
1933: SELECT assignment_id
1934: FROM PER_ALL_ASSIGNMENTS_F
1935: WHERE job_id = p_job_id
1936: AND primary_flag = 'Y'
1937: -- AND assignment_type = 'E'
1938: AND assignment_type = p_assignment_type

Line 3381: per_all_assignments_f asg

3377: FROM JTF_RS_RESOURCE_EXTNS RES
3378: WHERE res.category = 'EMPLOYEE'
3379: AND not exists (select ppl.person_id
3380: from per_all_people_f ppl,
3381: per_all_assignments_f asg
3382: where ppl.person_id = res.source_id
3383: and res.category = 'EMPLOYEE'
3384: and trunc(sysdate) between ppl.effective_start_date and ppl.effective_end_date
3385: and ppl.employee_number is not null

Line 3507: --, per_all_assignments_f asg

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

Line 3523: from per_all_assignments_f

3519: --and ppl.person_id = asg.person_id
3520: --and asg.primary_flag = 'Y'
3521: --and asg.assignment_type = 'E'
3522: /*and asg.effective_start_date = (select max(effective_start_date)
3523: from per_all_assignments_f
3524: where person_id = ppl.person_id
3525: and primary_flag = 'Y'
3526: and assignment_type = 'E'
3527: ) */