APPS.PMI_SALES_PKG dependencies on OP_CHRG_MST

Line 541: FROM op_ordr_chg a, op_chrg_mst b

537: Extended_amount,
538: Decode(p_mul_div_sign,0,Extended_amount*p_Exchange_Rate,
539: Extended_amount/p_Exchange_Rate)))
540: )
541: FROM op_ordr_chg a, op_chrg_mst b
542: WHERE a.order_id = P_order_id
543: AND a.line_id = P_line_id
544: AND a.charge_id = b.charge_id
545: AND b.charge_type in (20,30);

Line 558: FROM op_ordr_chg a, op_chrg_mst b

554: SELECT sum(abs(DECODE(P_Base_Currency,p_Billing_Currency,
555: Extended_amount,
556: Decode(p_mul_div_sign,0,Extended_amount*p_Exchange_Rate,
557: Extended_amount/p_Exchange_Rate))))
558: FROM op_ordr_chg a, op_chrg_mst b
559: WHERE a.order_id = P_order_id
560: AND a.line_id IS NULL
561: AND a.charge_id = b.charge_id
562: AND b.charge_type in (20,30);