DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 437: FROM JAI_CMN_CUS_ADDRESSES a, qp_list_lines b, qp_pricing_attributes c

433:
434: CURSOR c_get_assessable_value(p_customer_id NUMBER, p_address_id NUMBER,
435: p_inventory_item_id VARCHAR2, p_uom_code VARCHAR2, p_ordered_date DATE )IS
436: SELECT b.operand list_price
437: FROM JAI_CMN_CUS_ADDRESSES a, qp_list_lines b, qp_pricing_attributes c
438: WHERE a.customer_id = p_customer_id
439: AND a.address_id = p_address_id
440: AND a.price_list_id = b.list_header_id
441: AND c.list_line_id = b.list_line_id