APPS.OTA_GENERAL dependencies on PO_VENDORS

Line 751: from po_vendors

747: --******************************************************************************
748: --
749: cursor csr_vendor is
750: select vendor_name
751: from po_vendors
752: where vendor_id = p_vendor_id;
753: --
754: l_vendor_name po_vendors.vendor_name%type := null;
755: --

Line 754: l_vendor_name po_vendors.vendor_name%type := null;

750: select vendor_name
751: from po_vendors
752: where vendor_id = p_vendor_id;
753: --
754: l_vendor_name po_vendors.vendor_name%type := null;
755: --
756: begin
757: --
758: if p_vendor_id is not null then

Line 780: from po_vendors

776: p_vendor_name varchar2 ) return boolean is
777: --
778: cursor csr_vendor is
779: select 1
780: from po_vendors
781: where vendor_name = p_vendor_name;
782: --
783: l_vendor_OK boolean;
784:

Line 808: from po_vendors

804: p_vendor_id number,p_date date default null) return boolean is
805: --
806: cursor csr_vendor(l_date IN DATE) is
807: select 1
808: from po_vendors
809: where vendor_id = p_vendor_id
810: and nvl(end_date_active,to_date('31-12-4712', 'DD-MM-YYYY')) > l_date;
811: --
812: l_vendor_OK boolean;