DBA Data[Home] [Help]

APPS.AMW_FINDINGS_PKG dependencies on ENG_ENGINEERING_CHANGES

Line 23: from eng_change_subjects ecs_self, eng_engineering_changes eec

19: begin
20:
21: select count ( ecs_self.change_id )
22: into ofcount
23: from eng_change_subjects ecs_self, eng_engineering_changes eec
24: where ecs_self.change_id = eec.change_id
25: and ecs_self.entity_name = self_entity_name
26: and ecs_self.pk1_value = self_pk1_value
27: and ecs_self.subject_level = 1