DBA Data[Home] [Help]

APPS.ICX_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: and upper(first_name) = upper(p_first_name);
119:
120: cursor existing_contact_by_vendor is

Line 122: from PO_VENDOR_CONTACTS b,

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

Line 142: from PO_VENDOR_CONTACTS

138: if l_existing_contact = 1
139: then
140: select vendor_contact_id
141: into l_contact_id
142: from PO_VENDOR_CONTACTS
143: where upper(last_name) = upper(p_last_name)
144: and upper(first_name) = upper(p_first_name);
145:
146: return l_contact_id;

Line 161: from PO_VENDOR_CONTACTS b,

157: if l_existing_contact = 1
158: then
159: select vendor_contact_id
160: into l_contact_id
161: from PO_VENDOR_CONTACTS b,
162: PO_VENDOR_SITES_all a
163: where a.VENDOR_ID = p_supplier_id
164: and a.VENDOR_SITE_ID = b.VENDOR_SITE_ID
165: and b.INACTIVE_DATE is null