APPS.AMW_PROCCERT_REMINDER_PKG dependencies on AMW_OPINIONS_V

Line 225: from amw_opinions_v opinion

221: where exscope.ENTITY_TYPE = 'BUSIPROC_CERTIFICATION'
222: and exscope.ENTITY_ID = c_cert_id
223: and exscope.level_id > 3
224: and not exists (select 'Y'
225: from amw_opinions_v opinion
226: where opinion.PK1_VALUE = exscope.ENTITY_ID
227: and opinion.PK2_VALUE = exscope.ORGANIZATION_ID
228: and opinion.PK3_VALUE = exscope.PROCESS_ID
229: and opinion.object_name = 'AMW_ORG_PROCESS'

Line 241: from amw_opinions_v opinion

237: and exscope.ENTITY_ID = c_cert_id
238: and exscope.organization_id = c_org_id
239: and exscope.level_id > 3
240: and not exists (select 'Y'
241: from amw_opinions_v opinion
242: where opinion.PK1_VALUE = exscope.ENTITY_ID
243: and opinion.PK2_VALUE = exscope.ORGANIZATION_ID
244: and opinion.PK3_VALUE = exscope.PROCESS_ID
245: and opinion.object_name = 'AMW_ORG_PROCESS'

Line 490: from amw_opinions_v opinion

486: CURSOR Get_Pending_Cert_Proc IS
487: SELECT distinct scp.organization_id, scp.PROCESS_ID
488: FROM amw_execution_scope scp
489: where not exists (select 'Y'
490: from amw_opinions_v opinion
491: where opinion.PK1_VALUE = scp.ENTITY_ID
492: and opinion.PK2_VALUE = scp.ORGANIZATION_ID
493: and opinion.PK3_VALUE = scp.PROCESS_ID
494: and opinion.object_name = 'AMW_ORG_PROCESS'

Line 527: from amw_opinions_v opinion

523: AND NVL(grants.end_date, SYSDATE+1) >= TRUNC(SYSDATE)
524: AND grants.menu_id = granted_menu.menu_id
525: and granted_menu.menu_name = 'AMW_ORG_PROC_OWNER_ROLE'
526: and not exists (select 'Y'
527: from amw_opinions_v opinion
528: where opinion.PK1_VALUE = exscope.ENTITY_ID
529: and opinion.PK2_VALUE = exscope.ORGANIZATION_ID
530: and opinion.PK3_VALUE = exscope.PROCESS_ID
531: and opinion.object_name = 'AMW_ORG_PROCESS'