1445: AND hz.party_id = p_segment_id;
1446:
1447: CURSOR c_segment_cust (p_segment_id IN NUMBER) IS
1448: SELECT 1 1449: FROM qp_customers_v 1450: WHERE customer_id = p_segment_id;
1451:
1452: CURSOR c_segment_billto (p_segment_id IN NUMBER) IS
1453: SELECT 1