APPS.JTF_RS_RES_SSWA_PUB dependencies on PER_PHONES

Line 835: from per_phones p1

831: cursor phone_cur(l_person_id number)
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)

Line 840: from per_phones p2

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
841: where parent_table = 'PER_ALL_PEOPLE_F'
842: and parent_id = l_person_id
843: and phone_type = 'W1' );
844:

Line 854: from per_phones p1

850: cursor mobile_phone_cur(l_person_id number)
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)

Line 859: from per_phones p2

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
860: where parent_table = 'PER_ALL_PEOPLE_F'
861: and parent_id = l_person_id
862: and phone_type = 'M' );
863:

Line 873: from per_phones p1

869: cursor pager_cur(l_person_id number)
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)

Line 878: from per_phones p2

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
879: where parent_table = 'PER_ALL_PEOPLE_F'
880: and parent_id = l_person_id
881: and phone_type = 'P' );
882:

Line 1664: --update per_phones

1660: --call phone api
1661: if(nvl(ok_source_phone, fnd_api.g_miss_char) <>
1662: nvl(old_rec.source_phone, fnd_api.g_miss_char))
1663: then
1664: --update per_phones
1665: open phone_cur(old_rec.source_id);
1666: fetch phone_cur into phone_rec;
1667: if(phone_cur%found)
1668: then

Line 1704: --update per_phones

1700: --call mobile phone api
1701: if(nvl(ok_source_mobile_phone, fnd_api.g_miss_char) <>
1702: nvl(old_rec.source_mobile_phone, fnd_api.g_miss_char))
1703: then
1704: --update per_phones
1705: open mobile_phone_cur(old_rec.source_id);
1706: fetch mobile_phone_cur into mobile_phone_rec;
1707: if(mobile_phone_cur%found)
1708: then

Line 1743: --update per_phones

1739: --call pager api
1740: if(nvl(ok_source_pager, fnd_api.g_miss_char) <>
1741: nvl(old_rec.source_pager, fnd_api.g_miss_char))
1742: then
1743: --update per_phones
1744: open pager_cur(old_rec.source_id);
1745: fetch pager_cur into pager_rec;
1746: if(pager_cur%found)
1747: then