76: oe_debug_pub.add( 'OEXVIMSB->BEFORE SELECT QP_LIST_LINE FOR DIS' ) ;
77: END IF;
78: SELECT LIST_LINE_ID
79: INTO l_list_line_id
80: FROM qp_list_lines
81: WHERE LIST_HEADER_ID = l_list_header_id
82: AND LIST_LINE_NO = p_list_line_no
83: AND LIST_LINE_TYPE_CODE = p_list_line_type_code ;
84:
103: oe_debug_pub.add( 'OEXVIMSB->BEFORE SELECT QP_LIST_LINE FOR PROMOLINE' ) ;
104: END IF;
105: SELECT LIST_LINE_ID
106: INTO l_list_line_id
107: FROM qp_list_lines
108: WHERE LIST_HEADER_ID = l_list_header_id
109: AND LIST_LINE_NO = p_list_line_no
110: AND LIST_LINE_TYPE_CODE ='PROMOLINE';
111: