DBA Data[Home] [Help]

APPS.ENG_ECO_UTIL dependencies on ENG_CHANGE_ORDER_TYPES_VL

Line 4246: eng_change_order_types_vl ect ,eng_subject_entities ese

4242:
4243: cursor Getsubject (p_change_type_id in NUMBER) is
4244:
4245: select ect.type_name ,ect.subject_id ,ese.entity_name ,ese.parent_entity_name from
4246: eng_change_order_types_vl ect ,eng_subject_entities ese
4247: where ect.subject_id =ese.subject_id
4248: and change_order_type_id =p_change_type_id
4249: and subject_level=1 ;
4250: