APPS.JTF_RS_CONC_RES_PUB dependencies on PER_PHONES

Line 511: from per_phones p1

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

Line 521: from per_phones p1

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

Line 526: from per_phones p2

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
527: where parent_table = 'PER_ALL_PEOPLE_F'
528: and parent_id = l_person_id
529: and phone_type = 'W1');
530:

Line 571: l_phone per_phones.phone_number%type;

567: l_user_name VARCHAR2(2000);
568: i NUMBER;
569: l_value varchar2(2000);
570: l_count number;
571: l_phone per_phones.phone_number%type;
572:
573: l_active_emp_start_date DATE;
574: l_active_emp_end_date DATE;
575: l_asg_start_date date;

Line 1629: FROM per_phones

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

Line 1638: FROM per_phones

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

Line 1646: FROM per_phones

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

Line 3590: from per_phones per

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