APPS.ENGECOBO dependencies on ENG_CHANGE_SUBJECTS

Line 4387: from eng_change_subjects sub1,eng_change_subjects sub2

4383: l_header_subject_exists := 1;
4384:
4385: select sub1.pk1_value, sub1.pk2_value, sub2.pk3_value, sub2.entity_name
4386: INTO l_pk1_value, l_pk2_value, l_pk3_value, l_entity_name
4387: from eng_change_subjects sub1,eng_change_subjects sub2
4388: where sub1.change_id = sub2.change_id
4389: and sub1.change_id = p_change_id
4390: and sub1.change_line_id is null
4391: and sub2.change_line_id is null