APPS.POS_SUPPLIER_NOTIFY_PKG dependencies on HZ_PARTIES

Line 89: l_first_name hz_parties.person_first_name%TYPE;

85: l_contact_csr contact_csr_type;
86:
87: l_contact_sql VARCHAR2(4000);
88:
89: l_first_name hz_parties.person_first_name%TYPE;
90: l_last_name hz_parties.person_last_name%TYPE;
91: l_email_address hz_contact_points.email_address%TYPE;
92: l_user_name fnd_user.user_name%TYPE;
93: l_user_email_address fnd_user.email_address%TYPE;

Line 90: l_last_name hz_parties.person_last_name%TYPE;

86:
87: l_contact_sql VARCHAR2(4000);
88:
89: l_first_name hz_parties.person_first_name%TYPE;
90: l_last_name hz_parties.person_last_name%TYPE;
91: l_email_address hz_contact_points.email_address%TYPE;
92: l_user_name fnd_user.user_name%TYPE;
93: l_user_email_address fnd_user.email_address%TYPE;
94:

Line 121: 'FROM hz_parties hp, ' ||

117: ' hp.person_last_name, ' ||
118: ' hcpe.email_address, ' ||
119: ' fu.user_name, ' ||
120: ' fu.email_address ' ||
121: 'FROM hz_parties hp, ' ||
122: ' hz_relationships hzr, ' ||
123: ' hz_party_usg_assignments hpua, ' ||
124: ' hz_contact_points hcpe, ' ||
125: ' fnd_user fu, ' ||

Line 139: ' AND hcpe.owner_table_name(+) = ''HZ_PARTIES'' ' ||

135: ' AND hpua.party_id = hp.party_id ' ||
136: ' AND hpua.status_flag = ''A'' ' ||
137: ' AND hpua.party_usage_code = ''SUPPLIER_CONTACT'' ' ||
138: ' AND NVL(hpua.effective_end_date, SYSDATE) >= SYSDATE ' ||
139: ' AND hcpe.owner_table_name(+) = ''HZ_PARTIES'' ' ||
140: ' AND hcpe.owner_table_id(+) = hzr.party_id ' ||
141: ' AND hcpe.contact_point_type(+) = ''EMAIL'' ' ||
142: ' AND hcpe.primary_flag(+) = ''Y'' ' ||
143: ' AND NVL(hcpe.status, ''A'') = ''A'' ' ||