APPS.QP_MODIFIERS_UTIL dependencies on QP_LIST_HEADERS_B

Line 2427: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b

2423: /* Accumulation Start */
2424: BEGIN
2425: SELECT ACTIVE_FLAG
2426: INTO l_active_flag
2427: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b
2428: WHERE b.list_line_id=p_MODIFIERS_rec.list_line_id
2429: AND b.LIST_HEADER_ID = a.list_header_id;
2430: EXCEPTION
2431: WHEN NO_DATA_FOUND THEN

Line 2633: FROM QP_LIST_HEADERS_B

2629: /* Accumulation Start */
2630: BEGIN
2631: SELECT ACTIVE_FLAG
2632: INTO l_active_flag
2633: FROM QP_LIST_HEADERS_B
2634: WHERE list_header_id=p_MODIFIERS_rec.list_header_id;
2635: EXCEPTION
2636: WHEN NO_DATA_FOUND THEN
2637: NULL;

Line 2822: from qp_list_headers_b

2818: );
2819: /*
2820: select gsa_indicator
2821: into l_gsa_indicator
2822: from qp_list_headers_b
2823: where list_header_id = p_MODIFIERS_rec.LIST_HEADER_ID;
2824:
2825: IF l_gsa_indicator = 'Y'
2826: THEN

Line 4738: select active_flag into l_active_flag from qp_list_headers_b

4734: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4735: x_return_status => l_return_status);
4736: end if;
4737: if p_MODIFIERS_rec.automatic_flag <> p_old_MODIFIERS_rec.automatic_flag then
4738: select active_flag into l_active_flag from qp_list_headers_b
4739: where list_header_id =p_MODIFIERS_rec.list_header_id;
4740: if l_active_flag ='Y' then
4741: begin
4742: select count(*) into l_count from qp_list_lines qll