APPS.POS_SUPP_CUSTOM dependencies on PO_VENDOR_CONTACTS

Line 116: from PO_VENDOR_CONTACTS

112: l_contact_id number;
113:
114: cursor existing_contact is
115: select count(*)
116: from PO_VENDOR_CONTACTS
117: where upper(last_name) = upper(p_last_name);
118:
119: cursor existing_contact_by_vendor is
120: select count(*)

Line 121: from PO_VENDOR_CONTACTS b,

117: where upper(last_name) = upper(p_last_name);
118:
119: cursor existing_contact_by_vendor is
120: select count(*)
121: from PO_VENDOR_CONTACTS b,
122: PO_VENDOR_SITES_all a
123: where a.VENDOR_ID = p_supplier_id
124: and a.VENDOR_SITE_ID = b.VENDOR_SITE_ID
125: and upper(last_name) = upper(p_last_name);

Line 139: from PO_VENDOR_CONTACTS

135: if l_existing_contact = 1
136: then
137: select vendor_contact_id
138: into l_contact_id
139: from PO_VENDOR_CONTACTS
140: where upper(last_name) = upper(p_last_name);
141:
142: return l_contact_id;
143: else

Line 158: from PO_VENDOR_CONTACTS b,

154: then
155:
156: select vendor_contact_id
157: into l_contact_id
158: from PO_VENDOR_CONTACTS b,
159: PO_VENDOR_SITES_all a
160: where a.VENDOR_ID = p_supplier_id
161: and a.VENDOR_SITE_ID = b.VENDOR_SITE_ID
162: and upper(last_name) = upper(p_last_name);

Line 166: from PO_VENDOR_CONTACTS

162: and upper(last_name) = upper(p_last_name);
163: /*
164: select vendor_contact_id
165: into l_contact_id
166: from PO_VENDOR_CONTACTS
167: where upper(last_name) = upper(p_last_name);
168: */
169:
170: return l_contact_id;