APPS.AMW_PROCCERT_REMINDER_PKG dependencies on AMW_EXECUTION_SCOPE

Line 55: from amw_execution_scope

51: and granted_menu.menu_name = 'AMW_ORG_PROC_OWNER_ROLE';
52:
53: CURSOR C_Parent_Proc IS
54: select parent_process_id
55: from amw_execution_scope
56: where entity_type = 'BUSIPROC_CERTIFICATION'
57: and entity_id = p_certification_id
58: and organization_id = p_organization_id
59: and process_id = p_process_id;

Line 154: FROM amw_execution_scope

150: AND granted_menu.menu_name = 'AMW_ORG_PROC_OWNER_ROLE';
151:
152: CURSOR c_parent_proc IS
153: SELECT parent_process_id
154: FROM amw_execution_scope
155: WHERE entity_type = 'BUSIPROC_CERTIFICATION'
156: AND entity_id = p_certification_id
157: AND organization_id = p_organization_id
158: AND process_id = p_process_id;

Line 220: from amw_execution_scope exscope

216: and CERTIFICATION_STATUS = 'ACTIVE';
217:
218: cursor Get_Org_To_Notify(c_cert_id NUMBER) is
219: select distinct organization_id
220: from amw_execution_scope exscope
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'

Line 235: from amw_execution_scope exscope

231:
232:
233: cursor Get_Org_Proc_To_Notify(c_cert_id NUMBER, c_org_id NUMBER) is
234: select distinct process_id
235: from amw_execution_scope exscope
236: where exscope.ENTITY_TYPE = 'BUSIPROC_CERTIFICATION'
237: and exscope.ENTITY_ID = c_cert_id
238: and exscope.organization_id = c_org_id
239: and exscope.level_id > 3

Line 488: FROM amw_execution_scope scp

484: x_return_status OUT NOCOPY VARCHAR2)
485: is
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

Line 510: from amw_execution_scope exscope,

506: cursor Get_Proc_Owner_To_Notify is
507: select distinct
508: TO_NUMBER(REPLACE(grants.grantee_key,'HZ_PARTY:',''))
509: process_owner_id
510: from amw_execution_scope exscope,
511: fnd_grants grants,
512: fnd_objects obj,
513: fnd_menus granted_menu
514: where exscope.ENTITY_TYPE = 'BUSIPROC_CERTIFICATION'

Line 535: from amw_execution_scope exscopeB

531: and opinion.object_name = 'AMW_ORG_PROCESS'
532: and opinion.OPINION_TYPE_CODE = 'CERTIFICATION')
533: and (exscope.organization_id, exscope.PROCESS_ID) in
534: (select exscopeB.organization_id, exscopeB.PROCESS_ID
535: from amw_execution_scope exscopeB
536: start with exscopeB.ENTITY_ID=p_entity_id
537: and exscopeB.ENTITY_TYPE='BUSIPROC_CERTIFICATION'
538: and exscopeB.PROCESS_ID=p_process_id
539: and exscopeB.ORGANIZATION_ID=p_organization_id