[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