APPS.JTF_RS_CONC_RES_PUB dependencies on PER_PHONES

Line 453: from per_phones p1

449:
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'));

Line 463: from per_phones p1

459: -- Enh 3947611 2-dec-2004:for future dated emp phone
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)

Line 468: from per_phones p2

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
469: where parent_table = 'PER_ALL_PEOPLE_F'
470: and parent_id = l_person_id
471: and phone_type = 'W1');
472:

Line 513: l_phone per_phones.phone_number%type;

509: l_user_name VARCHAR2(2000);
510: i NUMBER;
511: l_value varchar2(2000);
512: l_count number;
513: l_phone per_phones.phone_number%type;
514:
515: l_active_emp_start_date DATE;
516: l_active_emp_end_date DATE;
517: l_asg_start_date date;

Line 1561: FROM per_phones

1557: and g_run_date between effective_start_date and effective_end_date;
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'));

Line 1570: FROM per_phones

1566:
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'));

Line 1578: FROM per_phones

1574: AND g_run_date between date_from and nvl(date_to, to_date('31/12/4712', 'DD/MM/YYYY'));
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'));

Line 3139: from per_phones per

3135: SET RES.LAST_UPDATE_DATE = sysdate,
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')))