APPS.QP_MODIFIERS_UTIL dependencies on QP_LIST_HEADERS

Line 2498: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b

2494: /* Accumulation Start */
2495: BEGIN
2496: SELECT ACTIVE_FLAG
2497: INTO l_active_flag
2498: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b
2499: WHERE b.list_line_id=p_MODIFIERS_rec.list_line_id
2500: AND b.LIST_HEADER_ID = a.list_header_id;
2501: EXCEPTION
2502: WHEN NO_DATA_FOUND THEN

Line 2706: FROM QP_LIST_HEADERS_B

2702: /* Accumulation Start */
2703: BEGIN
2704: SELECT ACTIVE_FLAG
2705: INTO l_active_flag
2706: FROM QP_LIST_HEADERS_B
2707: WHERE list_header_id=p_MODIFIERS_rec.list_header_id;
2708: EXCEPTION
2709: WHEN NO_DATA_FOUND THEN
2710: NULL;

Line 2899: from qp_list_headers_b

2895: );
2896: /*
2897: select gsa_indicator
2898: into l_gsa_indicator
2899: from qp_list_headers_b
2900: where list_header_id = p_MODIFIERS_rec.LIST_HEADER_ID;
2901:
2902: IF l_gsa_indicator = 'Y'
2903: THEN

Line 4933: select active_flag into l_active_flag from qp_list_headers_b

4929: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4930: x_return_status => l_return_status);
4931: end if;
4932: if p_MODIFIERS_rec.automatic_flag <> p_old_MODIFIERS_rec.automatic_flag then
4933: select active_flag into l_active_flag from qp_list_headers_b
4934: where list_header_id =p_MODIFIERS_rec.list_header_id;
4935: if l_active_flag ='Y' then
4936: begin
4937: select count(*) into l_count from qp_list_lines qll

Line 5006: select active_flag into l_active_flag from qp_list_headers

5002: l_return_status varchar2(30);
5003: l_call_from NUMBER :=2;
5004: BEGIN
5005:
5006: select active_flag into l_active_flag from qp_list_headers
5007: where list_header_id = p_MODIFIERS_rec.list_header_id;
5008: if (l_active_flag = 'Y') then
5009: select manual_modifier_flag into l_manual_modifier_flag
5010: from qp_pricing_phases