APPS.QP_PLL_PRICING_ATTR_UTIL dependencies on QP_LIST_HEADERS_B

Line 1141: FROM QP_LIST_HEADERS_B

1137: BEGIN
1138:
1139: SELECT ACTIVE_FLAG
1140: INTO l_active_flag
1141: FROM QP_LIST_HEADERS_B
1142: WHERE LIST_HEADER_ID = p_PRICING_ATTR_rec.list_header_id;
1143:
1144: oe_debug_pub.add('BEGIN Update_Row in QPXUPRAB');
1145:

Line 1290: FROM QP_LIST_HEADERS_B

1286:
1287: oe_debug_pub.add('BEGIN Update_Row in QPXUPRAB');
1288: SELECT ACTIVE_FLAG
1289: INTO l_active_flag
1290: FROM QP_LIST_HEADERS_B
1291: WHERE LIST_HEADER_ID = p_PRICING_ATTR_rec.list_header_id;
1292:
1293:
1294: BEGIN

Line 1419: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICING_ATTR_rec.list_header_id)

1415: , p_PRICING_ATTR_rec.qualification_ind --euro bug 2138996
1416: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1417: ,to_char(p_PRICING_ATTR_rec.pricing_attribute_id)
1418: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_PRICING_ATTR_rec.list_line_id)
1419: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICING_ATTR_rec.list_header_id)
1420: );
1421:
1422: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1423: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN