APPS.IBE_PARTY_V2PVT dependencies on HZ_CONTACT_PREFERENCES

Line 1689: From hz_contact_preferences

1685: --begin set/create contact preferences
1686: BEGIN
1687: SELECT contact_preference_id, object_version_number
1688: INTO l_id , l_object_version_number
1689: From hz_contact_preferences
1690: WHERE contact_level_table='HZ_PARTIES'
1691: AND contact_level_table_id=p_party_id;
1692:
1693: --update reason_code if record found

Line 2292: from hz_contact_preferences

2288: rec_custAcct_role c_getCustAcctRole%rowtype;
2289:
2290: cursor c_getContactPref(l_party_id number) IS
2291: select contact_preference_id,object_version_number
2292: from hz_contact_preferences
2293: where contact_level_table_id = l_party_id;
2294: rec_cntct_pref c_getContactPref%rowtype;
2295:
2296: BEGIN

Line 2758: SELECT contact_preference_id,object_version_number FROM hz_contact_preferences

2754: WHERE subject_id = c_subject_id and subject_type = 'PERSON'
2755: and object_id = c_object_id and object_type = 'ORGANIZATION';
2756:
2757: cursor c_get_contact_preference (c_party_id NUMBER,c_table_name VARCHAR2) is
2758: SELECT contact_preference_id,object_version_number FROM hz_contact_preferences
2759: WHERE contact_level_table_id = c_party_id and contact_level_table = c_table_name
2760: and contact_type = 'ALL';
2761:
2762: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;