316: hcp.phone_number,'-'),'--','-')
317: ,hcp.primary_flag
318: INTO lc_cust_phone_number
319: ,lc_primary_flag
320: FROM hz_contact_points hcp
321: WHERE hcp.status = 'A'
322: AND hcp.owner_table_id = p_owner_table_id
323: AND hcp.contact_point_type = 'PHONE'
324: AND hcp.phone_line_type IN ('GEN','PHONE','MOBILE')
330: hcp.phone_number,'-'),'--','-')
331: ,hcp.primary_flag
332: INTO lc_cust_phone_number
333: ,lc_primary_flag
334: FROM hz_contact_points hcp
335: WHERE hcp.contact_point_id = (SELECT MIN(hcp1.contact_point_id)
336: FROM hz_contact_points hcp1
337: WHERE hcp1.status = 'A'
338: AND hcp1.owner_table_id = p_owner_table_id
332: INTO lc_cust_phone_number
333: ,lc_primary_flag
334: FROM hz_contact_points hcp
335: WHERE hcp.contact_point_id = (SELECT MIN(hcp1.contact_point_id)
336: FROM hz_contact_points hcp1
337: WHERE hcp1.status = 'A'
338: AND hcp1.owner_table_id = p_owner_table_id
339: AND hcp1.contact_point_type = 'PHONE'
340: AND hcp1.phone_line_type IN ('GEN','PHONE','MOBILE'));
346: hcp.phone_number,'-'),'--','-')
347: ,hcp.primary_flag
348: INTO lc_cust_phone_number
349: ,lc_primary_flag
350: FROM hz_contact_points hcp
351: WHERE hcp.status = 'A'
352: AND hcp.owner_table_id = p_owner_table_id
353: AND hcp.contact_point_type = 'PHONE'
354: AND hcp.phone_line_type = 'FAX'
360: hcp.phone_number,'-'),'--','-')
361: ,hcp.primary_flag
362: INTO lc_cust_phone_number
363: ,lc_primary_flag
364: FROM hz_contact_points hcp
365: WHERE hcp.contact_point_id = (SELECT MIN(hcp1.contact_point_id)
366: FROM hz_contact_points hcp1
367: WHERE hcp1.status = 'A'
368: AND hcp1.owner_table_id = p_owner_table_id
362: INTO lc_cust_phone_number
363: ,lc_primary_flag
364: FROM hz_contact_points hcp
365: WHERE hcp.contact_point_id = (SELECT MIN(hcp1.contact_point_id)
366: FROM hz_contact_points hcp1
367: WHERE hcp1.status = 'A'
368: AND hcp1.owner_table_id = p_owner_table_id
369: AND hcp1.contact_point_type = 'PHONE'
370: AND hcp1.phone_line_type = 'FAX');