APPS.AMW_SCOPE_PVT dependencies on AMW_PROC_CERT_EVAL_SUM

Line 2532: DELETE FROM amw_proc_cert_eval_sum pcert

2528: IS
2529:
2530: BEGIN
2531:
2532: DELETE FROM amw_proc_cert_eval_sum pcert
2533: WHERE certification_id = p_entity_id
2534: AND NOT EXISTS (SELECT 'Y'
2535: FROM amw_execution_scope exec
2536: WHERE exec.entity_id = pcert.certification_id

Line 2542: INSERT INTO amw_proc_cert_eval_sum(certification_id,

2538: AND exec.process_id = pcert.process_id
2539: AND exec.organization_id = pcert.organization_id
2540: );
2541:
2542: INSERT INTO amw_proc_cert_eval_sum(certification_id,
2543: process_id,
2544: organization_id,
2545: process_org_rev_id,
2546: created_by,

Line 2563: FROM amw_proc_cert_eval_sum pcert

2559: SYSDATE,
2560: fnd_global.user_id
2561: FROM amw_execution_scope exec
2562: WHERE NOT EXISTS (SELECT 'Y'
2563: FROM amw_proc_cert_eval_sum pcert
2564: WHERE pcert.certification_id = exec.entity_id
2565: AND pcert.organization_id = exec.organization_id
2566: AND pcert.process_id = exec.process_id)
2567: AND entity_id = p_entity_id

Line 3728: DELETE FROM AMW_PROC_CERT_EVAL_SUM

3724:
3725: --Step 2: Remove the node from denormalized tables
3726: IF p_entity_type = 'BUSIPROC_CERTIFICATION'
3727: THEN
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

Line 3769: DELETE FROM AMW_PROC_CERT_EVAL_SUM

3765: AND entity_type = p_entity_type;
3766:
3767: IF p_entity_type = 'BUSIPROC_CERTIFICATION'
3768: THEN
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