DBA Data[Home] [Help]

APPS.AMW_SCOPE_PVT dependencies on AMW_LOOKUPS

Line 3271: FROM amw_curr_app_hierarchy_org_v aorv,amw_execution_scope aes,amw_lookups lk

3267: FOR UPDATE NOWAIT;
3268:
3269: CURSOR get_proc_org_rev_id(p_process_id NUMBER) IS
3270: SELECT aorv.child_process_org_rev_id
3271: FROM amw_curr_app_hierarchy_org_v aorv,amw_execution_scope aes,amw_lookups lk
3272: WHERE aorv.child_organization_id = aes.organization_id(+)
3273: AND aorv.child_process_id = aes.process_id(+)
3274: AND aorv.child_process_id <> -2
3275: AND lk.lookup_type = 'AMW_SCOPE_ENTITY_TYPE'