DBA Data[Home] [Help]

APPS.RCI_SIG_ACCT_EVAL_SUMM_PKG dependencies on AMW_EXECUTION_SCOPE

Line 292: (select distinct entity_id,creation_date from amw_Execution_scope

288: v_name varchar2(80);
289: BEGIN
290: select project_name into v_name from amw_audit_projects_v where audit_project_id =
291: (select entity_id from
292: (select distinct entity_id,creation_date from amw_Execution_scope
293: where entity_type='PROJECT' and organization_id=p_org_id
294: order by creation_date desc
295: ) where rownum<2
296: );

Line 536: amw_execution_scope amw_exec

532: BEGIN
533: SELECT
534: count(DISTINCT amw_exec.process_id) into v_cnt
535: FROM
536: amw_execution_scope amw_exec
537: WHERE
538: amw_exec.entity_type = 'BUSIPROC_CERTIFICATION'
539: AND amw_exec.entity_id = p_cert_id
540: AND EXISTS (SELECT opinion.opinion_id