APPS.QP_COUPON_PVT dependencies on QP_LIST_HEADERS_B

Line 36: INDX,QP_COUPON_PVT.Get_denormalized_qual_cols.l_list_hdr_dtls_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1

32: where list_header_id=p_header_id
33: and list_line_id= -1;
34:
35: /*
36: INDX,QP_COUPON_PVT.Get_denormalized_qual_cols.l_list_hdr_dtls_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
37: */
38: CURSOR l_list_hdr_dtls_cur(p_header_id NUMBER) IS
39: select active_flag
40: , list_type_code

Line 41: from qp_list_headers_b

37: */
38: CURSOR l_list_hdr_dtls_cur(p_header_id NUMBER) IS
39: select active_flag
40: , list_type_code
41: from qp_list_headers_b
42: where list_header_id=p_header_id;
43:
44:
45:

Line 280: l_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;

276: l_list_line_id NUMBER;
277: l_qualification_ind NUMBER;
278: l_qual_attr_value_from_number NUMBER := FND_API.G_MISS_NUM;
279: l_qual_attr_value_to_number NUMBER := FND_API.G_MISS_NUM;
280: l_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;
281: l_active_flag VARCHAR2(1);
282: l_header_qual_exists_flag VARCHAR2(1);
283: l_return_status VARCHAR2(1);
284: l_return_text VARCHAR2(100);

Line 403: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_list_header_id)

399: 1
400: --ENH Upgrade BOAPI for orig_sys...ref RAVI
401: ,to_char(QP_QUALIFIERS_S.currval)
402: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_list_line_id)
403: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_list_header_id)
404: );
405:
406: update_qual_ind(l_list_header_id,
407: l_list_line_id,