APPS.AMW_SCOPE_PVT dependencies on AMW_CURR_APP_HIERARCHY_ORG_V

Line 1047: FROM amw_curr_app_hierarchy_org_v org_v,amw_audit_units_v audit_v

1043: audit_v.company_code,
1044: audit_v.subsidiary_valueset,
1045: audit_v.lob_code,
1046: audit_v.lob_valueset
1047: FROM amw_curr_app_hierarchy_org_v org_v,amw_audit_units_v audit_v
1048: WHERE org_v.parent_process_id = -2
1049: AND audit_v.organization_id = org_v.child_organization_id
1050: AND audit_v.organization_id =';
1051:

Line 1499: FROM amw_curr_app_hierarchy_org_v apv

1495: p_entity_id IN NUMBER
1496: ) IS
1497: CURSOR c_process IS
1498: SELECT apv.child_process_id process_id, apv.child_process_org_rev_id process_org_rev_id
1499: FROM amw_curr_app_hierarchy_org_v apv
1500: WHERE apv.parent_process_id = p_parent_process_id
1501: and apv.child_organization_id = p_organization_id;
1502: BEGIN
1503: FOR proc_rec IN c_process LOOP

Line 3154: FROM amw_curr_app_hierarchy_org_v org_v,amw_audit_units_v audit_v

3150:
3151: CURSOR get_all_processes(p_org_id NUMBER)
3152: IS
3153: SELECT DISTINCT org_v.child_process_id as process_id
3154: FROM amw_curr_app_hierarchy_org_v org_v,amw_audit_units_v audit_v
3155: WHERE org_v.parent_process_id = -2
3156: AND audit_v.organization_id = org_v.child_organization_id
3157: AND audit_v.organization_id = p_org_id;
3158:

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'