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 404: FROM per_all_people_f ppl

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

Line 411: , per_all_people_f emp

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
412: -- WHERE NOT EXISTS (select source_id
413: WHERE NOT EXISTS (select 1
414: from jtf_rs_resource_extns rsc
415: where category = 'EMPLOYEE'

Line 469: FROM per_all_people_f ppl

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

Line 476: , per_all_people_f emp

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
477: -- WHERE NOT EXISTS (select source_id
478: WHERE NOT EXISTS (select 1
479: from jtf_rs_resource_extns rsc
480: where category = 'EMPLOYEE'

Line 512: where parent_table = 'PER_ALL_PEOPLE_F'

508: cursor fetch_phone(l_person_id number)
509: is
510: select phone_number
511: from per_phones p1
512: where parent_table = 'PER_ALL_PEOPLE_F'
513: and parent_id = l_person_id
514: and phone_type = 'W1'
515: and trunc(sysdate) between date_from and nvl(date_to, to_date('31/12/4712', 'DD/MM/YYYY'));
516:

Line 522: where parent_table = 'PER_ALL_PEOPLE_F'

518: cursor fetch_future_phone(l_person_id number)
519: is
520: select phone_number
521: from per_phones p1
522: where parent_table = 'PER_ALL_PEOPLE_F'
523: and parent_id = l_person_id
524: and phone_type = 'W1'
525: and date_from = (select max(date_from)
526: from per_phones p2

Line 527: where parent_table = 'PER_ALL_PEOPLE_F'

523: and parent_id = l_person_id
524: and phone_type = 'W1'
525: and date_from = (select max(date_from)
526: from per_phones p2
527: where parent_table = 'PER_ALL_PEOPLE_F'
528: and parent_id = l_person_id
529: and phone_type = 'W1');
530:
531:

Line 1310: from per_all_people_f ppl,

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

Line 1325: from per_all_people_f ppl

1321: and asg.period_of_service_id = ser.period_of_service_id
1322: and (ser.actual_termination_date >= trunc(sysdate) or ser.actual_termination_date is NULL))
1323: */
1324: AND not exists (select ppl.person_id
1325: from per_all_people_f ppl
1326: where ppl.person_id = rsc.source_id
1327: --Enh 3947611 2-dec-2004: changed the date check so that future dated employees are not terminated
1328: --and ( trunc(sysdate) between trunc(ppl.effective_start_date) and trunc(ppl.effective_end_date)
1329: and trunc(sysdate) <= trunc(ppl.effective_end_date )

Line 1540: from per_all_people_f ppl

1536: AND rsc.source_id = p_person_id
1537: AND l_sysdate not between trunc(rsc.start_date_active) and trunc(nvl(rsc.end_date_active,sysdate))
1538: -- AND exists ( select cur.employee_id from PER_EMPLOYEES_CURRENT_X cur where cur.employee_id = rsc.source_id);
1539: AND exists ( select ppl.person_id
1540: from per_all_people_f ppl
1541: where ppl.person_id = p_person_id
1542: and trunc(sysdate) between ppl.effective_start_date and ppl.effective_end_date
1543: and (ppl.current_employee_flag = 'Y' OR ppl.current_npw_flag = 'Y'));
1544:

Line 1574: FROM per_all_people_f

1570: npw_number,
1571: party_id,
1572: current_employee_flag,
1573: current_npw_flag
1574: FROM per_all_people_f
1575: WHERE person_id = p_person_id
1576: --and g_run_date between effective_start_date and effective_end_date;
1577: AND g_run_date <= effective_end_date
1578: AND (current_employee_flag = 'Y' OR

Line 1623: FROM per_all_people_f

1619: l_loc_rec c_loc%ROWTYPE;
1620:
1621: CURSOR c_mgr(p_person_id IN NUMBER) IS
1622: SELECT full_name
1623: FROM per_all_people_f
1624: WHERE person_id = p_person_id
1625: and g_run_date between effective_start_date and effective_end_date;
1626:
1627: CURSOR c_phone(p_person_id IN NUMBER) IS

Line 1630: WHERE parent_table = 'PER_ALL_PEOPLE_F'

1626:
1627: CURSOR c_phone(p_person_id IN NUMBER) IS
1628: SELECT phone_number
1629: FROM per_phones
1630: WHERE parent_table = 'PER_ALL_PEOPLE_F'
1631: AND parent_id = p_person_id
1632: AND phone_type = 'W1'
1633: AND g_run_date between date_from and nvl(date_to, to_date('31/12/4712', 'DD/MM/YYYY'));
1634:

Line 1639: WHERE parent_table = 'PER_ALL_PEOPLE_F'

1635:
1636: CURSOR c_mobile_phone(p_person_id IN NUMBER) IS
1637: SELECT phone_number
1638: FROM per_phones
1639: WHERE parent_table = 'PER_ALL_PEOPLE_F'
1640: AND parent_id = p_person_id
1641: AND phone_type = 'M'
1642: AND g_run_date between date_from and nvl(date_to, to_date('31/12/4712', 'DD/MM/YYYY'));
1643:

Line 1647: WHERE parent_table = 'PER_ALL_PEOPLE_F'

1643:
1644: CURSOR c_pager(p_person_id IN NUMBER) IS
1645: SELECT phone_number
1646: FROM per_phones
1647: WHERE parent_table = 'PER_ALL_PEOPLE_F'
1648: AND parent_id = p_person_id
1649: AND phone_type = 'P'
1650: AND g_run_date between date_from and nvl(date_to, to_date('31/12/4712', 'DD/MM/YYYY'));
1651:

Line 3380: from per_all_people_f ppl,

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

Line 3425: , per_all_people_f ppl

3421: , ppl.internal_location location
3422: , ppl.mailstop mailstop
3423: , ppl.party_id party_id
3424: FROM jtf_rs_resource_extns res
3425: , per_all_people_f ppl
3426: , hr_all_organization_units org
3427: WHERE res.resource_id = l_resource_id
3428: AND res.source_id = ppl.person_id
3429: and ppl.effective_start_date = (select max(effective_start_date)

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

3426: , hr_all_organization_units org
3427: WHERE res.resource_id = l_resource_id
3428: AND res.source_id = ppl.person_id
3429: and ppl.effective_start_date = (select max(effective_start_date)
3430: from per_all_people_f where person_id = ppl.person_id)
3431: and ppl.effective_end_date = (select max(effective_end_date)
3432: from per_all_people_f where person_id = ppl.person_id)
3433: and ppl.business_group_id = org.organization_id;
3434:

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

3428: AND res.source_id = ppl.person_id
3429: and ppl.effective_start_date = (select max(effective_start_date)
3430: from per_all_people_f where person_id = ppl.person_id)
3431: and ppl.effective_end_date = (select max(effective_end_date)
3432: from per_all_people_f where person_id = ppl.person_id)
3433: and ppl.business_group_id = org.organization_id;
3434:
3435: emp_rec fetch_emp_cur%rowtype;
3436:

Line 3505: FROM per_all_people_f ppl

3501: , ppl.office_number
3502: , ppl.internal_location
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

Line 3516: from per_all_people_f

3512: /* AND NOT EXISTS (SELECT EMPLOYEE_ID
3513: FROM PER_EMPLOYEES_CURRENT_X
3514: WHERE EMPLOYEE_ID = RES.SOURCE_ID) */
3515: AND ppl.effective_start_date = (select max(effective_start_date)
3516: from per_all_people_f
3517: where person_id = ppl.person_id)
3518: and ppl.business_group_id = org.organization_id
3519: --and ppl.person_id = asg.person_id
3520: --and asg.primary_flag = 'Y'

Line 3591: where parent_table = 'PER_ALL_PEOPLE_F'

3587: RES.LAST_UPDATED_BY = fnd_global.user_id,
3588: RES.SOURCE_PHONE
3589: = (select per.phone_number
3590: from per_phones per
3591: where parent_table = 'PER_ALL_PEOPLE_F'
3592: and parent_id = res.source_id
3593: and phone_type = 'W1'
3594: AND trunc(sysdate) between date_from and nvl(date_to, to_date('31/12/4712', 'DD/MM/YYYY')))
3595: WHERE RES.CATEGORY = 'EMPLOYEE';