DBA Data[Home] [Help]

APPS.POS_SPM_WF_PKG1 dependencies on FND_LOOKUP_VALUES

Line 504: FROM fnd_lookup_values flv, pos_bus_class_reqs pbcr

500: FUNCTION get_bus_class_name_in_req (p_bus_class_request_id IN NUMBER) RETURN VARCHAR2
501: IS
502: CURSOR l_cur IS
503: SELECT flv.meaning
504: FROM fnd_lookup_values flv, pos_bus_class_reqs pbcr
505: WHERE flv.lookup_type = pbcr.lookup_type
506: AND flv.lookup_code = pbcr.lookup_code
507: AND flv.language = userenv('LANG')
508: AND flv.lookup_type = 'POS_BUSINESS_CLASSIFICATIONS'

Line 542: l_bus_class_name fnd_lookup_values.meaning%TYPE;

538: l_receiver wf_roles.name%TYPE;
539: l_cur g_refcur;
540: l_count NUMBER;
541: l_step NUMBER;
542: l_bus_class_name fnd_lookup_values.meaning%TYPE;
543: BEGIN
544: l_step := 0;
545: get_supplier_name(p_vendor_id, l_supplier_name);
546: