APPS.POS_VENDOR_REG_PKG dependencies on HZ_PARTIES

Line 99: FROM hz_parties

95: l_party_rec hz_party_v2pub.party_rec_type;
96:
97: CURSOR l_cur IS
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);

Line 1485: l_party_id hz_parties.party_id%TYPE := -1;

1481: , x_vendor_id OUT NOCOPY NUMBER
1482: )
1483: IS
1484:
1485: l_party_id hz_parties.party_id%TYPE := -1;
1486:
1487: CURSOR supp_reg_cur IS
1488: SELECT -1
1489: FROM pos_supplier_registrations psr

Line 1496: FROM hz_parties

1492: AND psr.registration_status = 'PENDING_APPROVAL';
1493:
1494: CURSOR hz_cur IS
1495: SELECT party_id
1496: FROM hz_parties
1497: WHERE duns_number_c = p_duns_num
1498: AND party_type = 'ORGANIZATION';
1499:
1500: CURSOR po_vendors_cur ( p_party_id hz_parties.party_id%TYPE ) IS

Line 1500: CURSOR po_vendors_cur ( p_party_id hz_parties.party_id%TYPE ) IS

1496: FROM hz_parties
1497: WHERE duns_number_c = p_duns_num
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: