10610:
10611: IF l_distribution_set_id IS NOT NULL
10612: THEN
10613: BEGIN
10614: l_debug_info := 'Querying for ccid from ap_distribution_set_lines' ;
10615: SELECT dist_code_combination_id
10616: INTO l_default_ccid
10617: FROM ap_distribution_set_lines ADSL
10618: WHERE ADSL.distribution_set_id = l_distribution_set_id
10613: BEGIN
10614: l_debug_info := 'Querying for ccid from ap_distribution_set_lines' ;
10615: SELECT dist_code_combination_id
10616: INTO l_default_ccid
10617: FROM ap_distribution_set_lines ADSL
10618: WHERE ADSL.distribution_set_id = l_distribution_set_id
10619: AND rownum = 1 ;
10620: EXCEPTION
10621: WHEN NO_DATA_FOUND THEN