APPS.POS_VENDOR_REG_PKG dependencies on AP_SUPPLIERS

Line 102: FROM ap_suppliers

98: SELECT party_id, object_version_number
99: FROM hz_parties
100: WHERE party_id =
101: (SELECT party_id
102: FROM ap_suppliers
103: WHERE vendor_id = p_vendor_id);
104:
105: l_rec l_cur%ROWTYPE;
106: l_profile_id NUMBER;

Line 155: FROM ap_suppliers

151: l_found VARCHAR2(1);
152: l_ext_attr_1 pos_bus_class_reqs.ext_attr_1%TYPE;
153: CURSOR l_vendor_cur IS
154: SELECT vendor_id
155: FROM ap_suppliers
156: WHERE vendor_id = x_vendor_id;
157: l_number NUMBER;
158: /* Added for bug 7366321 */
159: l_hzprofile_value varchar2(20);

Line 1294: -- Code Added for Business Classification Re-Certification ER to update ap_suppliers table

1290: x_user_name => l_user_name,
1291: x_user_id => l_user_id
1292: );
1293:
1294: -- Code Added for Business Classification Re-Certification ER to update ap_suppliers table
1295: -- with the last certification date and last certified by values at the time of supplier approval.
1296:
1297: update ap_suppliers
1298: set bus_class_last_certified_by = l_user_id,

Line 1297: update ap_suppliers

1293:
1294: -- Code Added for Business Classification Re-Certification ER to update ap_suppliers table
1295: -- with the last certification date and last certified by values at the time of supplier approval.
1296:
1297: update ap_suppliers
1298: set bus_class_last_certified_by = l_user_id,
1299: bus_class_last_certified_date = (select creation_date
1300: from pos_supplier_registrations
1301: where supplier_reg_id = p_supplier_reg_id ),

Line 1670: FROM ap_suppliers

1666: RETURN 'N';
1667: END LOOP;
1668:
1669: FOR x IN (SELECT segment1
1670: FROM ap_suppliers
1671: WHERE segment1 = p_supp_number
1672: AND ROWNUM < 2
1673: )
1674: LOOP

Line 1704: FROM ap_suppliers pv

1700: AND psr.registration_status = 'PENDING_APPROVAL';
1701:
1702: CURSOR po_vendors_cur IS
1703: SELECT pv.vendor_id
1704: FROM ap_suppliers pv
1705: WHERE pv.num_1099 = p_taxpayer_id;
1706:
1707: BEGIN
1708:

Line 1767: FROM ap_suppliers

1763: AND party_type = 'ORGANIZATION';
1764:
1765: CURSOR po_vendors_cur ( p_party_id hz_parties.party_id%TYPE ) IS
1766: SELECT vendor_id
1767: FROM ap_suppliers
1768: WHERE party_id = p_party_id;
1769:
1770: /*Begin Supplier Data Hub - Supplier Management*/
1771:

Line 1856: FROM ap_suppliers pv, zx_party_tax_profile zxpr

1852: AND psr.registration_status = 'PENDING_APPROVAL';
1853:
1854: CURSOR po_vendors_cur IS
1855: SELECT pv.vendor_id
1856: FROM ap_suppliers pv, zx_party_tax_profile zxpr
1857: WHERE zxpr.party_id = pv.party_id
1858: AND zxpr.rep_registration_number = p_taxreg_num
1859: AND ((zxpr.country_code is not null and p_country is not null and zxpr.country_code = p_country) OR
1860: (p_country is null));