671: v_today DATE; -- := trunc(SYSDATE); --Ramananda for File.Sql.35
672: v_modifier_adhoc_amount NUMBER := 0;
673: v_modifier_percentage NUMBER := 0;
674:
675: lv_list_line_type_code_dis oe_price_adjustments.list_line_type_code%type ;
676: lv_list_line_type_code_sur oe_price_adjustments.list_line_type_code%type ;
677:
678: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
679: CURSOR c_adjustment_details(p_price_adjustment_id IN NUMBER) IS
672: v_modifier_adhoc_amount NUMBER := 0;
673: v_modifier_percentage NUMBER := 0;
674:
675: lv_list_line_type_code_dis oe_price_adjustments.list_line_type_code%type ;
676: lv_list_line_type_code_sur oe_price_adjustments.list_line_type_code%type ;
677:
678: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
679: CURSOR c_adjustment_details(p_price_adjustment_id IN NUMBER) IS
680: SELECT nvl( decode(list_line_type_code, lv_list_line_type_code_dis, operand, lv_list_line_type_code_sur, -operand), 0) operand, arithmetic_operator
678: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
679: CURSOR c_adjustment_details(p_price_adjustment_id IN NUMBER) IS
680: SELECT nvl( decode(list_line_type_code, lv_list_line_type_code_dis, operand, lv_list_line_type_code_sur, -operand), 0) operand, arithmetic_operator
681: --nvl( decode(list_line_type_code, 'DIS', operand, 'SUR', -operand), 0) operand, arithmetic_operator
682: FROM oe_price_adjustments a -- , qp_modifier_summary_v b
683: WHERE list_line_type_code IN ('DIS', 'SUR')
684: AND modifier_level_code = 'LINE'
685: AND price_adjustment_id = p_price_adjustment_id;
686: