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_RES_SSWA_PUB dependencies on PER_ALL_PEOPLE_F

Line 52: l_business_group_id per_all_people_f.business_group_id%type;

48: l_source_office jtf_rs_resource_extns.source_office%type := p_source_office;
49: l_source_location jtf_rs_resource_extns.source_location%type := p_source_location;
50: l_source_email jtf_rs_resource_extns.source_email%type := p_source_email;
51: l_source_phone jtf_rs_resource_extns.source_phone%type := p_source_phone;
52: l_business_group_id per_all_people_f.business_group_id%type;
53: l_user_name fnd_user.user_name%type := upper(p_user_name);
54: l_user_password fnd_user.encrypted_user_password%type := p_user_password;
55: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
56: /* Out Parameters for Create Employee*/

Line 125: from per_all_people_f

121:
122: /* cursor mgr_details(p_source_mgr_id number)
123: is
124: select full_name, person_id
125: from per_all_people_f
126: where trunc(sysdate ) between effective_start_date and effective_end_date
127: and person_id = (select source_id from jtf_rs_resource_extns
128: and resource_id = p_source_mgr_id);
129: */

Line 737: from per_all_people_f

733: select person_id,
734: employee_number,
735: last_update_date,
736: object_version_number
737: from per_all_people_f
738: where person_id = l_person_id
739: and effective_start_date = (select max(effective_start_date)
740: from per_all_people_f
741: where person_id = l_person_id

Line 740: from per_all_people_f

736: object_version_number
737: from per_all_people_f
738: where person_id = l_person_id
739: and effective_start_date = (select max(effective_start_date)
740: from per_all_people_f
741: where person_id = l_person_id
742: and employee_number is not null )
743: and effective_end_date = (select max(effective_end_date)
744: from per_all_people_f

Line 744: from per_all_people_f

740: from per_all_people_f
741: where person_id = l_person_id
742: and employee_number is not null )
743: and effective_end_date = (select max(effective_end_date)
744: from per_all_people_f
745: where person_id = l_person_id
746: and employee_number is not null )
747: and employee_number is not null;
748:

Line 836: where parent_table = 'PER_ALL_PEOPLE_F'

832: is
833: select phone_id,
834: object_version_number
835: from per_phones p1
836: where parent_table = 'PER_ALL_PEOPLE_F'
837: and parent_id = l_person_id
838: and phone_type = 'W1'
839: and date_from = (select max(date_from)
840: from per_phones p2

Line 841: where parent_table = 'PER_ALL_PEOPLE_F'

837: and parent_id = l_person_id
838: and phone_type = 'W1'
839: and date_from = (select max(date_from)
840: from per_phones p2
841: where parent_table = 'PER_ALL_PEOPLE_F'
842: and parent_id = l_person_id
843: and phone_type = 'W1' );
844:
845: phone_rec phone_cur%rowtype;

Line 855: where parent_table = 'PER_ALL_PEOPLE_F'

851: is
852: select phone_id,
853: object_version_number
854: from per_phones p1
855: where parent_table = 'PER_ALL_PEOPLE_F'
856: and parent_id = l_person_id
857: and phone_type = 'M'
858: and date_from = (select max(date_from)
859: from per_phones p2

Line 860: where parent_table = 'PER_ALL_PEOPLE_F'

856: and parent_id = l_person_id
857: and phone_type = 'M'
858: and date_from = (select max(date_from)
859: from per_phones p2
860: where parent_table = 'PER_ALL_PEOPLE_F'
861: and parent_id = l_person_id
862: and phone_type = 'M' );
863:
864: mobile_phone_rec mobile_phone_cur%rowtype;

Line 874: where parent_table = 'PER_ALL_PEOPLE_F'

870: is
871: select phone_id,
872: object_version_number
873: from per_phones p1
874: where parent_table = 'PER_ALL_PEOPLE_F'
875: and parent_id = l_person_id
876: and phone_type = 'P'
877: and date_from = (select max(date_from)
878: from per_phones p2

Line 879: where parent_table = 'PER_ALL_PEOPLE_F'

875: and parent_id = l_person_id
876: and phone_type = 'P'
877: and date_from = (select max(date_from)
878: from per_phones p2
879: where parent_table = 'PER_ALL_PEOPLE_F'
880: and parent_id = l_person_id
881: and phone_type = 'P' );
882:
883: pager_rec pager_cur%rowtype;

Line 1622: --update per_all_people_f

1618: nvl(old_rec.source_email, fnd_api.g_miss_char) )
1619: OR (nvl(ok_source_office, fnd_api.g_miss_char) <>
1620: nvl(old_rec.source_office, fnd_api.g_miss_char)))
1621: then
1622: --update per_all_people_f
1623: open per_cur(old_rec.source_id);
1624: fetch per_cur into per_rec;
1625: if(per_cur%found)
1626: then

Line 1690: p_parent_table => 'PER_ALL_PEOPLE_F',

1686: (p_date_from => sysdate,
1687: p_phone_type => 'W1',
1688: p_phone_number => ok_source_phone,
1689: p_parent_id => old_rec.source_id,
1690: p_parent_table => 'PER_ALL_PEOPLE_F',
1691: p_effective_date => sysdate,
1692: p_object_version_number => l_object_version_number_phone,
1693: p_phone_id => l_phone_id);
1694:

Line 1730: p_parent_table => 'PER_ALL_PEOPLE_F',

1726: (p_date_from => sysdate,
1727: p_phone_type => 'M',
1728: p_phone_number => ok_source_mobile_phone,
1729: p_parent_id => old_rec.source_id,
1730: p_parent_table => 'PER_ALL_PEOPLE_F',
1731: p_effective_date => sysdate,
1732: p_object_version_number => l_object_ver_num_mobile_ph,
1733: p_phone_id => l_mobile_phone_id);
1734:

Line 1769: p_parent_table => 'PER_ALL_PEOPLE_F',

1765: (p_date_from => sysdate,
1766: p_phone_type => 'P',
1767: p_phone_number => ok_source_pager,
1768: p_parent_id => old_rec.source_id,
1769: p_parent_table => 'PER_ALL_PEOPLE_F',
1770: p_effective_date => sysdate,
1771: p_object_version_number => l_object_version_number_pager,
1772: p_phone_id => l_pager_id);
1773: