APPS.POS_VENDOR_REG_PKG dependencies on POS_BUS_CLASS_REQS

Line 63: FROM pos_bus_class_reqs pbcr

59: )
60: IS
61: CURSOR l_cur IS
62: SELECT ext_attr_1
63: FROM pos_bus_class_reqs pbcr
64: , pos_supplier_mappings psm
65: , pos_supplier_registrations psr
66: WHERE psm.supplier_reg_id = psr.supplier_reg_id
67: AND psr.supplier_reg_id = p_supplier_reg_id

Line 152: l_ext_attr_1 pos_bus_class_reqs.ext_attr_1%TYPE;

148: l_step VARCHAR2(100);
149: l_method VARCHAR2(100);
150: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
151: l_found VARCHAR2(1);
152: l_ext_attr_1 pos_bus_class_reqs.ext_attr_1%TYPE;
153: CURSOR l_vendor_cur IS
154: SELECT vendor_id
155: FROM ap_suppliers
156: WHERE vendor_id = x_vendor_id;

Line 677: FROM pos_bus_class_reqs pbcr

673: )
674: IS
675: CURSOR l_cur IS
676: SELECT pbcr.bus_class_request_id
677: FROM pos_bus_class_reqs pbcr
678: , pos_supplier_mappings psm
679: WHERE pbcr.request_type = 'ADD'
680: AND pbcr.request_status = 'PENDING'
681: AND pbcr.mapping_id = psm.mapping_id

Line 1957: FROM pos_bus_class_reqs

1953: WHERE supplier_reg_id = p_supp_reg_id;
1954:
1955: CURSOR c_bus_class(p_mapping_id IN NUMBER) IS
1956: SELECT 'BC:' || lookup_code AS code
1957: FROM pos_bus_class_reqs
1958: WHERE mapping_id = p_mapping_id;
1959:
1960: CURSOR c_product_service(p_mapping_id IN NUMBER) IS
1961: SELECT *