APPS.JAI_CMN_MTAX_PKG dependencies on QP_PRICING_ATTRIBUTES

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

522:
523: CURSOR c_get_assessable_value(p_customer_id NUMBER, p_address_id NUMBER,
524: p_inventory_item_id VARCHAR2, p_uom_code VARCHAR2, p_ordered_date DATE )IS
525: SELECT b.operand list_price
526: FROM JAI_CMN_CUS_ADDRESSES a, qp_list_lines b, qp_pricing_attributes c
527: WHERE a.customer_id = p_customer_id
528: AND a.address_id = p_address_id
529: AND a.price_list_id = b.list_header_id
530: AND c.list_line_id = b.list_line_id

Line 563: , qp_pricing_attributes c

559: --, c.product_uom_code list_price_uom_code
560: FROM
561: jai_cmn_cus_addresses a
562: , qp_list_lines b
563: , qp_pricing_attributes c
564: WHERE a.customer_id = pn_party_id
565: AND a.address_id = pn_address_id
566: AND a.price_list_id = b.list_header_id
567: AND c.list_line_id = b.list_line_id

Line 1017: , qp_pricing_attributes c

1013: SELECT
1014: b.operand list_price
1015: FROM
1016: qp_list_lines b
1017: , qp_pricing_attributes c
1018: WHERE b.list_header_id = pn_price_list_id
1019: AND c.list_line_id = b.list_line_id
1020: AND c.product_uom_code = pv_uom_code
1021: AND NVL( start_date_active, SYSDATE- 1 ) <= SYSDATE