APPS.ASO_VALIDATE_PVT dependencies on QP_LIST_LINES

Line 4415: FROM qp_list_lines

4411: adj_rec_exists VARCHAR2(1):= 'N';
4412:
4413: Cursor C_get_list_lines(p_list_header_id NUMBER) IS
4414: SELECT list_line_id
4415: FROM qp_list_lines
4416: WHERE list_header_id = p_list_header_id;
4417:
4418: Cursor C_get_list_header(p_list_line_id NUMBER) IS
4419: SELECT list_header_id

Line 4420: FROM qp_list_lines

4416: WHERE list_header_id = p_list_header_id;
4417:
4418: Cursor C_get_list_header(p_list_line_id NUMBER) IS
4419: SELECT list_header_id
4420: FROM qp_list_lines
4421: WHERE list_line_id = p_list_line_id;
4422:
4423: Cursor C_get_attr(p_quote_header_id NUMBER,
4424: p_quote_line_id NUMBER,

Line 4442: FROM qp_list_lines qpe

4438: FROM aso_price_attributes
4439: WHERE quote_header_id = p_quote_header_id
4440: AND nvl(quote_line_id,0) = nvl(decode(p_quote_line_id,FND_API.G_MISS_NUM,null,p_quote_line_id),0)
4441: AND pricing_attribute1 IN ( SELECT to_char(qpe.list_header_id)
4442: FROM qp_list_lines qpe
4443: WHERE qpe.list_line_id = p_list_line_id);
4444:
4445: Cursor C_get_attr2(p_quote_header_id NUMBER,
4446: p_quote_line_id NUMBER,

Line 4459: FROM qp_list_lines qpe

4455: p_pricing_attribute2 IS NOT NULL
4456: )
4457: OR ( p_pricing_attribute2 IS NULL
4458: AND pricing_attribute2 IN ( SELECT to_char(qpe.list_line_id)
4459: FROM qp_list_lines qpe
4460: WHERE qpe.list_header_id = p_list_header_id)
4461: )
4462: );
4463:

Line 4478: FROM qp_list_lines qpe

4474: AND quote_header_id = p_quote_header_id
4475: AND nvl(quote_line_id,0) = nvl(p_quote_line_id,0)
4476: AND pricing_attribute1 IS NULL
4477: AND nvl(pricing_attribute2,'Y') IN ( SELECT qpe.list_line_id
4478: FROM qp_list_lines qpe
4479: WHERE qpe.list_header_id = qp.list_header_id)
4480: )
4481: */
4482: