APPS.POS_SUPP_CUSTOM SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

        select  count(*)
        from    PO_VENDORS
        where   upper(vendor_name) like upper(p_supplier)||'%';

Line: 38

	select	vendor_id
	into	l_vendor_id
	from	PO_VENDORS
	where	upper(vendor_name) like upper(p_supplier)||'%';

Line: 115

        select  count(*)
        from    PO_VENDOR_CONTACTS
        where   upper(last_name) = upper(p_last_name);

Line: 120

        select  count(*)
        from    PO_VENDOR_CONTACTS b,
		PO_VENDOR_SITES_all a
        where   a.VENDOR_ID = p_supplier_id
	and	a.VENDOR_SITE_ID = b.VENDOR_SITE_ID
	and	upper(last_name) = upper(p_last_name);

Line: 137

        select  vendor_contact_id
        into    l_contact_id
        from    PO_VENDOR_CONTACTS
        where   upper(last_name) = upper(p_last_name);

Line: 156

        select  vendor_contact_id
        into    l_contact_id
        from    PO_VENDOR_CONTACTS b,
		PO_VENDOR_SITES_all a
        where   a.VENDOR_ID = p_supplier_id
	and	a.VENDOR_SITE_ID = b.VENDOR_SITE_ID
	and	upper(last_name) = upper(p_last_name);

Line: 164

        select  vendor_contact_id
        into    l_contact_id
        from    PO_VENDOR_CONTACTS
        where   upper(last_name) = upper(p_last_name);

Line: 209

procedure GetContactSelector (p_supplier_id     IN NUMBER,
			      p_approver_id     IN OUT NUMBER,
                              p_approver_name   IN OUT VARCHAR2) is

begin


     -- Default to SYSADMIN
     p_approver_id := 0;