1415: AND hz.party_id = p_segment_id;
1416:
1417: CURSOR c_segment_cust (p_segment_id IN NUMBER) IS
1418: SELECT 1 1419: FROM qp_customers_v 1420: WHERE customer_id = p_segment_id;
1421:
1422: CURSOR c_segment_billto (p_segment_id IN NUMBER) IS
1423: SELECT 1