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 1105: -- Code Added for Business Classification Re-Certification ER to update ap_suppliers table

1101: x_user_name => l_user_name,
1102: x_user_id => l_user_id
1103: );
1104:
1105: -- Code Added for Business Classification Re-Certification ER to update ap_suppliers table
1106: -- with the last certification date and last certified by values at the time of supplier approval.
1107:
1108: update ap_suppliers
1109: set bus_class_last_certified_by = l_user_id,

Line 1108: update ap_suppliers

1104:
1105: -- Code Added for Business Classification Re-Certification ER to update ap_suppliers table
1106: -- with the last certification date and last certified by values at the time of supplier approval.
1107:
1108: update ap_suppliers
1109: set bus_class_last_certified_by = l_user_id,
1110: bus_class_last_certified_date = (select creation_date
1111: from pos_supplier_registrations
1112: where supplier_reg_id = p_supplier_reg_id ),

Line 1409: FROM ap_suppliers

1405: RETURN 'N';
1406: END LOOP;
1407:
1408: FOR x IN (SELECT segment1
1409: FROM ap_suppliers
1410: WHERE segment1 = p_supp_number
1411: AND ROWNUM < 2
1412: )
1413: LOOP

Line 1442: FROM ap_suppliers pv, zx_party_tax_profile zxpr

1438: AND psr.registration_status = 'PENDING_APPROVAL';
1439:
1440: CURSOR po_vendors_cur IS
1441: SELECT pv.vendor_id
1442: FROM ap_suppliers pv, zx_party_tax_profile zxpr
1443: WHERE pv.num_1099 = p_taxpayer_id
1444: AND zxpr.party_id = pv.party_id
1445: AND ((zxpr.country_code is not null and p_country is not null and zxpr.country_code = p_country) OR
1446: (p_country is null));

Line 1502: FROM ap_suppliers

1498: AND party_type = 'ORGANIZATION';
1499:
1500: CURSOR po_vendors_cur ( p_party_id hz_parties.party_id%TYPE ) IS
1501: SELECT vendor_id
1502: FROM ap_suppliers
1503: WHERE party_id = p_party_id;
1504:
1505: BEGIN
1506:

Line 1563: FROM ap_suppliers pv, zx_party_tax_profile zxpr

1559: AND psr.registration_status = 'PENDING_APPROVAL';
1560:
1561: CURSOR po_vendors_cur IS
1562: SELECT pv.vendor_id
1563: FROM ap_suppliers pv, zx_party_tax_profile zxpr
1564: WHERE zxpr.party_id = pv.party_id
1565: AND zxpr.rep_registration_number = p_taxreg_num
1566: AND ((zxpr.country_code is not null and p_country is not null and zxpr.country_code = p_country) OR
1567: (p_country is null));