APPS.HZ_USER_PARTY_UTILS dependencies on HZ_CONTACT_POINTS

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

83: AND per.person_id = l_per_person_id;
84:
85: /*-----------------------------------------------------+
86: | Cursor for finding a person party with email |
87: | address given as parameter. HZ_CONTACT_POINTS table |
88: | has function based index on upper(email_address) |
89: | so performance of the query is acceptable. |
90: +-----------------------------------------------------*/
91: CURSOR person_cur(l_email_address

Line 92: hz_contact_points.email_address%TYPE) IS

88: | has function based index on upper(email_address) |
89: | so performance of the query is acceptable. |
90: +-----------------------------------------------------*/
91: CURSOR person_cur(l_email_address
92: hz_contact_points.email_address%TYPE) IS
93: SELECT party.party_id,
94: party.party_type,
95: party.status
96: FROM hz_contact_points cp,

Line 96: FROM hz_contact_points cp,

92: hz_contact_points.email_address%TYPE) IS
93: SELECT party.party_id,
94: party.party_type,
95: party.status
96: FROM hz_contact_points cp,
97: hz_parties party
98: WHERE upper(cp.email_address) = UPPER(l_email_address)
99: AND cp.owner_table_name = 'HZ_PARTIES'
100: AND party.party_id = cp.owner_table_id

Line 109: hz_contact_points.email_address%TYPE) IS

105: | This cursor is used to find the person party |
106: | from an email assigned to a contact. |
107: +-----------------------------------------------------*/
108: CURSOR contact_cur(l_email_address
109: hz_contact_points.email_address%TYPE) IS
110: SELECT per.party_id,
111: per.party_type,
112: per.status
113: FROM hz_contact_points cp,

Line 113: FROM hz_contact_points cp,

109: hz_contact_points.email_address%TYPE) IS
110: SELECT per.party_id,
111: per.party_type,
112: per.status
113: FROM hz_contact_points cp,
114: hz_relationships rel,
115: hz_parties per
116: WHERE upper(cp.email_address) = UPPER(l_email_address)
117: AND rel.party_id = cp.owner_table_id

Line 138: ln_contact_point_id hz_contact_points.contact_point_id%TYPE;

134: email_rec hz_contact_point_v2pub.email_rec_type;
135:
136: lv_subject_party_number hz_parties.party_number%TYPE;
137: ln_subject_party_id hz_parties.party_id%TYPE;
138: ln_contact_point_id hz_contact_points.contact_point_id%TYPE;
139:
140: ln_profile_id NUMBER;
141: ln_party_id NUMBER;
142: ln_per_person_id NUMBER;