APPS.AHL_DI_SUBSCRIPTION_PUB dependencies on PO_VENDORS

Line 97: -- Used to retrieve vendor id from po vendors

93: SELECT distinct segment1
94: FROM PO_HEADERS_V
95: WHERE nvl(approved_flag, 'N')='Y' and upper(segment1) = upper(c_ponumber);
96:
97: -- Used to retrieve vendor id from po vendors
98: CURSOR for_vendor_id(c_vendor_name IN VARCHAR2)
99: IS
100: SELECT vendor_id
101: FROM po_vendors

Line 101: FROM po_vendors

97: -- Used to retrieve vendor id from po vendors
98: CURSOR for_vendor_id(c_vendor_name IN VARCHAR2)
99: IS
100: SELECT vendor_id
101: FROM po_vendors
102: WHERE upper(vendor_name) = upper(c_vendor_name);
103:
104: --Used to retrieve the party id from party name
105: CURSOR get_party_name (c_party_name IN VARCHAR2)

Line 732: -- Used to retrieve vendor id from po vendors

728: SELECT distinct segment1
729: FROM PO_HEADERS_V
730: WHERE nvl(approved_flag, 'N')='Y' and upper(segment1) = upper(c_ponumber);
731:
732: -- Used to retrieve vendor id from po vendors
733: CURSOR for_vendor_id(c_vendor_name IN VARCHAR2)
734: IS
735: SELECT vendor_id
736: FROM po_vendors

Line 736: FROM po_vendors

732: -- Used to retrieve vendor id from po vendors
733: CURSOR for_vendor_id(c_vendor_name IN VARCHAR2)
734: IS
735: SELECT vendor_id
736: FROM po_vendors
737: WHERE upper(vendor_name) = upper(c_vendor_name);
738:
739: --Used to retrieve the party id for party name
740: CURSOR get_party_name (c_party_name IN VARCHAR2)