DBA Data[Home] [Help]

APPS.POS_SPM_WF_PKG1 dependencies on POS_BUS_CLASS_REQS

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 692: from pos_bus_class_reqs

688: l_class_id number;
689: BEGIN
690: select classification_id
691: into l_class_id
692: from pos_bus_class_reqs
693: where bus_class_request_id = p_bus_class_request_id;
694:
695: -- The java API makes the call to this method even if the
696: -- classification is changed. This is where we can catch