DBA Data[Home] [Help]

APPS.RCI_ORG_CERT_ETL_PKG dependencies on AMW_EXECUTION_SCOPE

Line 606: from amw_execution_scope aes

602: ,G_USER_ID
603: ,sysdate
604: ,G_USER_ID
605: ,G_LOGIN_ID
606: from amw_execution_scope aes
607: ,amw_certification_vl acv
608: ,amw_process ap
609: ,amw_process_names_tl apnt
610: ,amw_process_organization aop

Line 626: and (aes.level_id = (select max(level_id) from amw_execution_scope where entity_type='BUSIPROC_CERTIFICATION' and entity_id=aes.entity_id and organization_id=aes.organization_id) or aes.level_id > 3)

622: /** 10.20.2005 npanandi end ***/
623: where entity_type='BUSIPROC_CERTIFICATION'
624: and acv.object_type='PROCESS'
625: and acv.certification_id=aes.entity_id
626: and (aes.level_id = (select max(level_id) from amw_execution_scope where entity_type='BUSIPROC_CERTIFICATION' and entity_id=aes.entity_id and organization_id=aes.organization_id) or aes.level_id > 3)
627: and haou.organization_id=haout.organization_id
628: and haout.language=userenv('LANG')
629: and haou.organization_id=hoi.organization_id
630: and hoi.org_information_context='CLASS'

Line 1123: from amw_execution_scope aes

1119: ,G_USER_ID
1120: ,sysdate
1121: ,G_USER_ID
1122: ,G_LOGIN_ID
1123: from amw_execution_scope aes
1124: ,amw_certification_vl acv
1125: ,amw_process ap
1126: ,amw_process_names_tl apnt
1127: ,amw_process_organization aop