DBA Data[Home] [Help]

APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on ENG_SUBJECTS_B

Line 652: FROM eng_subject_entities ese, eng_subjects_b esb

648: AND LANGS.installed_flag IN ('B','I'));
649:
650: SELECT subject_level, entity_name, parent_entity_name
651: BULK COLLECT INTO l_sub_desc_array
652: FROM eng_subject_entities ese, eng_subjects_b esb
653: WHERE ese.subject_id=esb.subject_id
654: AND esb.subject_internal_name='EGO_NEW_ITEM'
655: ORDER BY subject_level ;
656: