APPS.ENG_CHANGE_LINE_UTIL dependencies on ENG_SUBJECT_ENTITIES

Line 716: eng_change_order_types_vl ect ,eng_subject_entities ese

712: IS
713:
714: cursor Getsubject (p_change_type_id in NUMBER) is
715: select ect.type_name ,ect.subject_id ,ese.entity_name,ese.parent_entity_name from
716: eng_change_order_types_vl ect ,eng_subject_entities ese
717: where ect.subject_id =ese.subject_id
718: and change_order_type_id =p_change_type_id
719: and subject_level=1 ;
720:

Line 1112: FROM eng_subject_entities_v esev, eng_change_subjects subs

1108: , esev.query_column1_name, esev.query_column2_name, esev.query_column3_name
1109: , esev.query_column4_name, esev.query_column5_name
1110: , subs.entity_name, subs.subject_level, subs.pk1_value
1111: , subs.pk2_value, subs.pk3_value, subs.pk4_value, subs.pk5_value
1112: FROM eng_subject_entities_v esev, eng_change_subjects subs
1113: WHERE esev.subject_id = p_subject_id
1114: AND esev.subject_level = subs.subject_level
1115: AND esev.entity_name = subs.entity_name
1116: AND subs.change_id = p_change_id