APPS.HZ_USER_PARTY_UTILS dependencies on HZ_CONTACT_POINTS

Line 107: | address given as parameter. HZ_CONTACT_POINTS table |

103: WHERE ROWNUM = 1;
104:
105: /*-----------------------------------------------------+
106: | Cursor for finding a person party with email |
107: | address given as parameter. HZ_CONTACT_POINTS table |
108: | has function based index on upper(email_address) |
109: | so performance of the query is acceptable. |
110: +-----------------------------------------------------*/
111: CURSOR person_cur(l_email_address

Line 112: hz_contact_points.email_address%TYPE) IS

108: | has function based index on upper(email_address) |
109: | so performance of the query is acceptable. |
110: +-----------------------------------------------------*/
111: CURSOR person_cur(l_email_address
112: hz_contact_points.email_address%TYPE) IS
113: SELECT party.party_id,
114: party.party_type,
115: party.status
116: FROM hz_contact_points cp,

Line 116: FROM hz_contact_points cp,

112: hz_contact_points.email_address%TYPE) IS
113: SELECT party.party_id,
114: party.party_type,
115: party.status
116: FROM hz_contact_points cp,
117: hz_parties party
118: WHERE upper(cp.email_address) = UPPER(l_email_address)
119: AND cp.owner_table_name = 'HZ_PARTIES'
120: AND party.party_id = cp.owner_table_id

Line 129: hz_contact_points.email_address%TYPE) IS

125: | This cursor is used to find the person party |
126: | from an email assigned to a contact. |
127: +-----------------------------------------------------*/
128: CURSOR contact_cur(l_email_address
129: hz_contact_points.email_address%TYPE) IS
130: SELECT per.party_id,
131: per.party_type,
132: per.status
133: FROM hz_contact_points cp,

Line 133: FROM hz_contact_points cp,

129: hz_contact_points.email_address%TYPE) IS
130: SELECT per.party_id,
131: per.party_type,
132: per.status
133: FROM hz_contact_points cp,
134: hz_relationships rel,
135: hz_parties per
136: WHERE upper(cp.email_address) = UPPER(l_email_address)
137: AND rel.party_id = cp.owner_table_id

Line 158: ln_contact_point_id hz_contact_points.contact_point_id%TYPE;

154: email_rec hz_contact_point_v2pub.email_rec_type;
155:
156: lv_subject_party_number hz_parties.party_number%TYPE;
157: ln_subject_party_id hz_parties.party_id%TYPE;
158: ln_contact_point_id hz_contact_points.contact_point_id%TYPE;
159:
160: ln_profile_id NUMBER;
161: ln_party_id NUMBER;
162: ln_per_person_id NUMBER;