APPS.JAI_AR_SUP_TRX_PKG dependencies on OE_PRICE_ADJUSTMENTS

Line 747: lv_list_line_type_code_dis oe_price_adjustments.list_line_type_code%type ;

743: v_today DATE; -- := trunc(SYSDATE); --Ramananda for File.Sql.35
744: v_modifier_adhoc_amount NUMBER := 0;
745: v_modifier_percentage NUMBER := 0;
746:
747: lv_list_line_type_code_dis oe_price_adjustments.list_line_type_code%type ;
748: lv_list_line_type_code_sur oe_price_adjustments.list_line_type_code%type ;
749:
750: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
751: CURSOR c_adjustment_details(p_price_adjustment_id IN NUMBER) IS

Line 748: lv_list_line_type_code_sur oe_price_adjustments.list_line_type_code%type ;

744: v_modifier_adhoc_amount NUMBER := 0;
745: v_modifier_percentage NUMBER := 0;
746:
747: lv_list_line_type_code_dis oe_price_adjustments.list_line_type_code%type ;
748: lv_list_line_type_code_sur oe_price_adjustments.list_line_type_code%type ;
749:
750: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
751: CURSOR c_adjustment_details(p_price_adjustment_id IN NUMBER) IS
752: 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

Line 754: FROM oe_price_adjustments a -- , qp_modifier_summary_v b

750: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
751: CURSOR c_adjustment_details(p_price_adjustment_id IN NUMBER) IS
752: 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
753: --nvl( decode(list_line_type_code, 'DIS', operand, 'SUR', -operand), 0) operand, arithmetic_operator
754: FROM oe_price_adjustments a -- , qp_modifier_summary_v b
755: WHERE list_line_type_code IN ('DIS', 'SUR')
756: AND modifier_level_code = 'LINE'
757: AND price_adjustment_id = p_price_adjustment_id;
758: