APPS.AMW_SCOPE_PVT dependencies on AMW_ORG_CERT_EVAL_SUM

Line 2575: INSERT INTO amw_org_cert_eval_sum(certification_id,

2571:
2572: IF p_mode = 'ADD'
2573: THEN
2574:
2575: INSERT INTO amw_org_cert_eval_sum(certification_id,
2576: organization_id,
2577: created_by,
2578: creation_date,
2579: last_updated_by,

Line 2591: FROM amw_org_cert_eval_sum ocert

2587: SYSDATE,
2588: fnd_global.user_id
2589: FROM amw_execution_scope exec
2590: WHERE NOT EXISTS (SELECT 'Y'
2591: FROM amw_org_cert_eval_sum ocert
2592: WHERE ocert.certification_id = exec.entity_id
2593: AND ocert.organization_id = exec.organization_id
2594: )
2595: AND entity_id = p_entity_id

Line 3732: DELETE FROM AMW_ORG_CERT_EVAL_SUM

3728: DELETE FROM AMW_PROC_CERT_EVAL_SUM
3729: WHERE organization_id = p_object_id
3730: AND certification_id = p_entity_id;
3731:
3732: DELETE FROM AMW_ORG_CERT_EVAL_SUM
3733: WHERE organization_id = p_object_id
3734: AND certification_id = p_entity_id;
3735: ELSIF p_entity_type = 'PROJECT' THEN
3736: DELETE FROM amw_audit_scope_processes

Line 3773: DELETE FROM AMW_ORG_CERT_EVAL_SUM

3769: DELETE FROM AMW_PROC_CERT_EVAL_SUM
3770: WHERE organization_id = l_object_tbl(each_rec).org_id
3771: AND certification_id = p_entity_id;
3772:
3773: DELETE FROM AMW_ORG_CERT_EVAL_SUM
3774: WHERE organization_id = l_object_tbl(each_rec).org_id
3775: AND certification_id = p_entity_id;
3776: END IF;
3777: