DBA Data[Home] [Help]

APPS.ENG_ECO_UTIL dependencies on ENG_CHANGE_ORDER_TYPES_VL

Line 3817: eng_change_order_types_vl ect ,eng_subject_entities ese

3813:
3814: cursor Getsubject (p_change_type_id in NUMBER) is
3815:
3816: select ect.type_name ,ect.subject_id ,ese.entity_name ,ese.parent_entity_name from
3817: eng_change_order_types_vl ect ,eng_subject_entities ese
3818: where ect.subject_id =ese.subject_id
3819: and change_order_type_id =p_change_type_id
3820: and subject_level=1 ;
3821: