APPS.PER_HRTCA_MERGE dependencies on HZ_CONTACT_POINTS

Line 622: FROM hz_contact_points hcp

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

Line 682: from hz_contact_points hcp

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

Line 801: -- Requerying last_update_date from hz_contact_points

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

Line 808: from hz_contact_points

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

Line 5922: from hz_contact_points

5918: and mod(ppf.person_id,p_number_of_workers) = p_current_worker-1
5919: and ppf.effective_end_date = hr_api.g_eot
5920: and ppf.party_id is not null
5921: and not exists(select null
5922: from hz_contact_points
5923: where owner_table_name = 'HZ_PARTIES'
5924: and owner_table_id = ppf.party_id
5925: and email_address = nvl(ppf.email_address,'NULL'));
5926: --

Line 6298: from hz_contact_points

6294: and ppf.ROWID between p_start_rowid and p_end_rowid
6295: and ppf.effective_end_date = hr_api.g_eot
6296: and ppf.party_id is not null
6297: and not exists(select /*+ no_unnest */ null
6298: from hz_contact_points
6299: where owner_table_name = 'HZ_PARTIES'
6300: and owner_table_id = ppf.party_id
6301: and upper(email_address) = ppf.email_address); -- fix for bug 12933615
6302: --