APPS.PA_DRAFT_REVENUES_PKG dependencies on PA_EVENT_TYPES

Line 142: AND EXISTS (SELECT 1 FROM pa_event_types et

138: where dii.project_id=X_project_id
139: and dii.event_num is not null
140: AND e.event_num = dii.event_num
141: and nvl(e.task_id,-99) = nvl(dii.event_task_id,-99)
142: AND EXISTS (SELECT 1 FROM pa_event_types et
143: WHERE e.event_type = et.event_type
144: and et.event_type_classification = 'AUTOMATIC')
145: and exists
146: (select 1