APPS.ICX_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) = upper(p_supplier);

Line: 38

	select	vendor_id
	into	l_vendor_id
	from	PO_VENDORS
	where	upper(vendor_name) = upper(p_supplier);

Line: 115

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

Line: 121

        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     b.INACTIVE_DATE is null
	and	upper(b.last_name)  = upper(p_last_name)
	and	upper(b.first_name) = upper(p_first_name);

Line: 140

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

Line: 159

        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     b.INACTIVE_DATE is null
        and     upper(b.last_name)  = upper(p_last_name)
        and     upper(b.first_name) = upper(p_first_name);

Line: 208

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;