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_PEOPLE_F

Line 346: FROM per_all_people_f ppl

342: , ppl.mailstop mailstop
343: , asg.location_id address_id
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)

Line 353: , per_all_people_f emp

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
354: -- WHERE NOT EXISTS (select source_id
355: WHERE NOT EXISTS (select 1
356: from jtf_rs_resource_extns rsc
357: where category = 'EMPLOYEE'

Line 411: FROM per_all_people_f ppl

407: , ppl.mailstop mailstop
408: , asg.location_id address_id
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)

Line 418: , per_all_people_f emp

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
419: -- WHERE NOT EXISTS (select source_id
420: WHERE NOT EXISTS (select 1
421: from jtf_rs_resource_extns rsc
422: where category = 'EMPLOYEE'

Line 454: where parent_table = 'PER_ALL_PEOPLE_F'

450: cursor fetch_phone(l_person_id number)
451: is
452: select phone_number
453: from per_phones p1
454: where parent_table = 'PER_ALL_PEOPLE_F'
455: and parent_id = l_person_id
456: and phone_type = 'W1'
457: and trunc(sysdate) between date_from and nvl(date_to, to_date('31/12/4712', 'DD/MM/YYYY'));
458:

Line 464: where parent_table = 'PER_ALL_PEOPLE_F'

460: cursor fetch_future_phone(l_person_id number)
461: is
462: select phone_number
463: from per_phones p1
464: where parent_table = 'PER_ALL_PEOPLE_F'
465: and parent_id = l_person_id
466: and phone_type = 'W1'
467: and date_from = (select max(date_from)
468: from per_phones p2

Line 469: where parent_table = 'PER_ALL_PEOPLE_F'

465: and parent_id = l_person_id
466: and phone_type = 'W1'
467: and date_from = (select max(date_from)
468: from per_phones p2
469: where parent_table = 'PER_ALL_PEOPLE_F'
470: and parent_id = l_person_id
471: and phone_type = 'W1');
472:
473:

Line 1252: from per_all_people_f ppl,

1248: where emp.employee_id = rsc.source_id
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'

Line 1267: from per_all_people_f ppl

1263: and asg.period_of_service_id = ser.period_of_service_id
1264: and (ser.actual_termination_date >= trunc(sysdate) or ser.actual_termination_date is NULL))
1265: */
1266: AND not exists (select ppl.person_id
1267: from per_all_people_f ppl
1268: where ppl.person_id = rsc.source_id
1269: --Enh 3947611 2-dec-2004: changed the date check so that future dated employees are not terminated
1270: --and ( trunc(sysdate) between trunc(ppl.effective_start_date) and trunc(ppl.effective_end_date)
1271: and trunc(sysdate) <= trunc(ppl.effective_end_date )

Line 1482: from per_all_people_f ppl

1478: AND rsc.source_id = p_person_id
1479: AND l_sysdate not between trunc(rsc.start_date_active) and trunc(nvl(rsc.end_date_active,sysdate))
1480: -- AND exists ( select cur.employee_id from PER_EMPLOYEES_CURRENT_X cur where cur.employee_id = rsc.source_id);
1481: AND exists ( select ppl.person_id
1482: from per_all_people_f ppl
1483: where ppl.person_id = p_person_id
1484: and trunc(sysdate) between ppl.effective_start_date and ppl.effective_end_date
1485: and (ppl.current_employee_flag = 'Y' OR ppl.current_npw_flag = 'Y'));
1486:

Line 1509: FROM per_all_people_f

1505: mailstop,
1506: npw_number,
1507: party_id,
1508: current_employee_flag
1509: FROM per_all_people_f
1510: WHERE person_id = p_person_id
1511: and g_run_date between effective_start_date and effective_end_date;
1512:
1513: l_ppf_rec c_ppf%ROWTYPE;

Line 1555: FROM per_all_people_f

1551: l_loc_rec c_loc%ROWTYPE;
1552:
1553: CURSOR c_mgr(p_person_id IN NUMBER) IS
1554: SELECT full_name
1555: FROM per_all_people_f
1556: WHERE person_id = p_person_id
1557: and g_run_date between effective_start_date and effective_end_date;
1558:
1559: CURSOR c_phone(p_person_id IN NUMBER) IS

Line 1562: WHERE parent_table = 'PER_ALL_PEOPLE_F'

1558:
1559: CURSOR c_phone(p_person_id IN NUMBER) IS
1560: SELECT phone_number
1561: FROM per_phones
1562: WHERE parent_table = 'PER_ALL_PEOPLE_F'
1563: AND parent_id = p_person_id
1564: AND phone_type = 'W1'
1565: AND g_run_date between date_from and nvl(date_to, to_date('31/12/4712', 'DD/MM/YYYY'));
1566:

Line 1571: WHERE parent_table = 'PER_ALL_PEOPLE_F'

1567:
1568: CURSOR c_mobile_phone(p_person_id IN NUMBER) IS
1569: SELECT phone_number
1570: FROM per_phones
1571: WHERE parent_table = 'PER_ALL_PEOPLE_F'
1572: AND parent_id = p_person_id
1573: AND phone_type = 'M'
1574: AND g_run_date between date_from and nvl(date_to, to_date('31/12/4712', 'DD/MM/YYYY'));
1575:

Line 1579: WHERE parent_table = 'PER_ALL_PEOPLE_F'

1575:
1576: CURSOR c_pager(p_person_id IN NUMBER) IS
1577: SELECT phone_number
1578: FROM per_phones
1579: WHERE parent_table = 'PER_ALL_PEOPLE_F'
1580: AND parent_id = p_person_id
1581: AND phone_type = 'P'
1582: AND g_run_date between date_from and nvl(date_to, to_date('31/12/4712', 'DD/MM/YYYY'));
1583:

Line 2929: from per_all_people_f ppl,

2925: SELECT RESOURCE_ID, SOURCE_ID
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

Line 2974: , per_all_people_f ppl

2970: , ppl.internal_location location
2971: , ppl.mailstop mailstop
2972: , ppl.party_id party_id
2973: FROM jtf_rs_resource_extns res
2974: , per_all_people_f ppl
2975: , hr_all_organization_units org
2976: WHERE res.resource_id = l_resource_id
2977: AND res.source_id = ppl.person_id
2978: and ppl.effective_start_date = (select max(effective_start_date)

Line 2979: from per_all_people_f where person_id = ppl.person_id)

2975: , hr_all_organization_units org
2976: WHERE res.resource_id = l_resource_id
2977: AND res.source_id = ppl.person_id
2978: and ppl.effective_start_date = (select max(effective_start_date)
2979: from per_all_people_f where person_id = ppl.person_id)
2980: and ppl.effective_end_date = (select max(effective_end_date)
2981: from per_all_people_f where person_id = ppl.person_id)
2982: and ppl.business_group_id = org.organization_id;
2983:

Line 2981: from per_all_people_f where person_id = ppl.person_id)

2977: AND res.source_id = ppl.person_id
2978: and ppl.effective_start_date = (select max(effective_start_date)
2979: from per_all_people_f where person_id = ppl.person_id)
2980: and ppl.effective_end_date = (select max(effective_end_date)
2981: from per_all_people_f where person_id = ppl.person_id)
2982: and ppl.business_group_id = org.organization_id;
2983:
2984: emp_rec fetch_emp_cur%rowtype;
2985:

Line 3054: FROM per_all_people_f ppl

3050: , ppl.office_number
3051: , ppl.internal_location
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

Line 3065: from per_all_people_f

3061: /* AND NOT EXISTS (SELECT EMPLOYEE_ID
3062: FROM PER_EMPLOYEES_CURRENT_X
3063: WHERE EMPLOYEE_ID = RES.SOURCE_ID) */
3064: AND ppl.effective_start_date = (select max(effective_start_date)
3065: from per_all_people_f
3066: where person_id = ppl.person_id)
3067: and ppl.business_group_id = org.organization_id
3068: --and ppl.person_id = asg.person_id
3069: --and asg.primary_flag = 'Y'

Line 3140: where parent_table = 'PER_ALL_PEOPLE_F'

3136: RES.LAST_UPDATED_BY = fnd_global.user_id,
3137: RES.SOURCE_PHONE
3138: = (select per.phone_number
3139: from per_phones per
3140: where parent_table = 'PER_ALL_PEOPLE_F'
3141: and parent_id = res.source_id
3142: and phone_type = 'W1'
3143: AND trunc(sysdate) between date_from and nvl(date_to, to_date('31/12/4712', 'DD/MM/YYYY')))
3144: WHERE RES.CATEGORY = 'EMPLOYEE';