APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on QP_LIST_HEADERS_TL

Line 66: oe_debug_pub.add( 'OEXVIMSB->BEFORE SELECT QP_LIST_HEADERS_TL FOR DIS' ) ;

62: p_list_line_type_code = 'SUR') and
63: p_list_line_no is NOT NULL) THEN
64:
65: IF l_debug_level > 0 THEN
66: oe_debug_pub.add( 'OEXVIMSB->BEFORE SELECT QP_LIST_HEADERS_TL FOR DIS' ) ;
67: END IF;
68: SELECT LIST_HEADER_ID
69: INTO l_list_header_id
70: FROM qp_list_headers_tl

Line 70: FROM qp_list_headers_tl

66: oe_debug_pub.add( 'OEXVIMSB->BEFORE SELECT QP_LIST_HEADERS_TL FOR DIS' ) ;
67: END IF;
68: SELECT LIST_HEADER_ID
69: INTO l_list_header_id
70: FROM qp_list_headers_tl
71: WHERE NAME = p_modifier_name
72: AND LANGUAGE = userenv('LANG')
73: AND nvl(VERSION_NO, FND_API.G_MISS_CHAR)= nvl(p_version_no, FND_API.G_MISS_CHAR);
74:

Line 97: FROM qp_list_headers_tl

93: oe_debug_pub.add( 'OEXVIMSB->BEFORE SELECT QP_LIST_HEADER_TL FOR PROMOLINE' ) ;
94: END IF;
95: SELECT LIST_HEADER_ID
96: INTO l_list_header_id
97: FROM qp_list_headers_tl
98: WHERE NAME = p_modifier_name
99: AND LANGUAGE = userenv('LANG')
100: AND nvl(VERSION_NO,FND_API.G_MISS_CHAR) = nvl(p_version_no,FND_API.G_MISS_CHAR);
101: