APPS.QP_MODIFIERS_UTIL dependencies on QP_LIST_HEADERS

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

Line 4811: select active_flag into l_active_flag from qp_list_headers

4807: l_return_status varchar2(30);
4808: l_call_from NUMBER :=2;
4809: BEGIN
4810:
4811: select active_flag into l_active_flag from qp_list_headers
4812: where list_header_id = p_MODIFIERS_rec.list_header_id;
4813: if (l_active_flag = 'Y') then
4814: select manual_modifier_flag into l_manual_modifier_flag
4815: from qp_pricing_phases