APPS.PER_HRTCA_MERGE dependencies on HZ_CONTACT_POINTS

Line 620: FROM hz_contact_points hcp

616: --
617: -- Cursor to select existing email address from hz_parties
618: CURSOR c1 IS
619: SELECT email_address, last_update_date,contact_point_id,status
620: FROM hz_contact_points hcp
621: WHERE hcp.contact_point_type = 'EMAIL'
622: and hcp.owner_table_name = 'HZ_PARTIES'
623: and hcp.owner_table_id = p_rec.party_id
624: order by last_update_date desc,contact_point_id desc;

Line 680: from hz_contact_points hcp

676: --Added for bug 2648797
677: --Get the object version number
678: select max(object_version_number)
679: into l_object_version_number
680: from hz_contact_points hcp
681: where hcp.contact_point_id = l_c1.contact_point_id;
682: --
683: --bug no 5546586 starts here
684: if(l_email_changed) then

Line 799: -- Requerying last_update_date from hz_contact_points

795: l_contact_point_rec.primary_flag := 'N';
796: l_email_rec.email_address := l_c1.email_address;
797: --
798: -- Start of fix for bug 3374509
799: -- Requerying last_update_date from hz_contact_points
800: -- before passing it tto update contact API.
801: -- Due to Validation relaxation by TCA API. All previous records
802: -- are updated by create contact points API.
803: --

Line 806: from hz_contact_points

802: -- are updated by create contact points API.
803: --
804: select last_update_date
805: into l_c1.last_update_date
806: from hz_contact_points
807: where contact_point_id = l_c1.contact_point_id;
808: --Modified for Bug 2648797
809: -- api version and p_last_update_date have been commented as TCA V2 does
810: -- not include them

Line 5903: from hz_contact_points

5899: and mod(ppf.person_id,p_number_of_workers) = p_current_worker-1
5900: and ppf.effective_end_date = hr_api.g_eot
5901: and ppf.party_id is not null
5902: and not exists(select null
5903: from hz_contact_points
5904: where owner_table_name = 'HZ_PARTIES'
5905: and owner_table_id = ppf.party_id
5906: and email_address = nvl(ppf.email_address,'NULL'));
5907: --

Line 6278: from hz_contact_points

6274: and ppf.ROWID between p_start_rowid and p_end_rowid
6275: and ppf.effective_end_date = hr_api.g_eot
6276: and ppf.party_id is not null
6277: and not exists(select /*+ no_unnest */ null
6278: from hz_contact_points
6279: where owner_table_name = 'HZ_PARTIES'
6280: and owner_table_id = ppf.party_id
6281: and email_address = nvl(ppf.email_address,'NULL'));
6282: