DBA Data[Home] [Help]

APPS.POS_SPM_WF_PKG1 dependencies on FND_LOOKUP_VALUES

Line 556: FROM fnd_lookup_values flv, pos_bus_class_reqs pbcr

552: FUNCTION get_bus_class_name_in_req (p_bus_class_request_id IN NUMBER) RETURN VARCHAR2
553: IS
554: CURSOR l_cur IS
555: SELECT flv.meaning
556: FROM fnd_lookup_values flv, pos_bus_class_reqs pbcr
557: WHERE flv.lookup_type = pbcr.lookup_type
558: AND flv.lookup_code = pbcr.lookup_code
559: AND flv.language = userenv('LANG')
560: AND flv.lookup_type = 'POS_BUSINESS_CLASSIFICATIONS'

Line 594: l_bus_class_name fnd_lookup_values.meaning%TYPE;

590: l_receiver wf_roles.name%TYPE;
591: l_cur g_refcur;
592: l_count NUMBER;
593: l_step NUMBER;
594: l_bus_class_name fnd_lookup_values.meaning%TYPE;
595: BEGIN
596: l_step := 0;
597: get_supplier_name(p_vendor_id, l_supplier_name);
598: