APPS.JAI_GENERAL_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 115: FROM JAI_CMN_VENDOR_SITES

111: ) IS
112:
113: CURSOR c_range_division IS
114: SELECT excise_duty_range, excise_duty_division
115: FROM JAI_CMN_VENDOR_SITES
116: WHERE vendor_id = p_vendor_id
117: AND vendor_site_id = p_vendor_site_id;
118: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.get_range_division';
119: BEGIN

Line 745: JAI_CMN_VENDOR_SITES a,

741: SELECT
742: b.operand list_price,
743: c.product_uom_code list_price_uom_code
744: FROM
745: JAI_CMN_VENDOR_SITES a,
746: qp_list_lines b,
747: qp_pricing_attributes c
748: WHERE
749: a.vendor_id = p_vendor_id AND

Line 774: JAI_CMN_VENDOR_SITES a,

770: SELECT
771: b.operand list_price,
772: c.product_uom_code list_price_uom_code
773: FROM
774: JAI_CMN_VENDOR_SITES a,
775: qp_list_lines b,
776: qp_pricing_attributes c
777: WHERE
778: a.vendor_id = p_vendor_id AND

Line 798: JAI_CMN_VENDOR_SITES a,

794: SELECT
795: b.operand list_price,
796: c.product_uom_code list_price_uom_code
797: FROM
798: JAI_CMN_VENDOR_SITES a,
799: qp_list_lines b,
800: qp_pricing_attributes c
801: WHERE
802: a.vendor_id = p_vendor_id AND