[Home] [Help]
1860:
1861:
1862: UPDATE AMW_AP_ASSOCIATIONS apa
1863: SET apa.audit_procedure_rev_id = (SELECT audit_procedure_rev_id
1864: FROM amw_audit_procedures_b aapb1
1865: WHERE aapb1.audit_procedure_id = apa.audit_procedure_id
1866: AND aapb1.curr_approved_flag = 'Y')
1867: WHERE apa.object_type = 'PROJECT'
1868: AND apa.pk1 = p_audit_project_id
1903: apa.pk1 organization_id,
1904: apa.pk3 control_id,
1905: pt2.task_id
1906: FROM amw_ap_associations apa,
1907: amw_audit_procedures_b aapb,
1908: amw_ap_tasks apt,
1909: amw_control_associations aca,
1910: amw_audit_projects_v pp,
1911: amw_audit_tasks_v pt1,
1976: apa.pk1 organization_id,
1977: apa.pk3 control_id,
1978: pt2.task_id
1979: FROM amw_ap_associations apa,
1980: amw_audit_procedures_b aapb,
1981: amw_ap_tasks apt,
1982: amw_control_associations aca,
1983: amw_audit_projects_v pp,
1984: amw_template_tasks_v pt1,
2047: aapb.audit_procedure_rev_Id,
2048: apa.pk1 organization_id,
2049: apa.pk3 control_id
2050: FROM amw_ap_associations apa,
2051: amw_audit_procedures_b aapb,
2052: amw_control_associations aca
2053: WHERE apa.object_type = 'CTRL_ORG'
2054: AND aca.object_type='PROJECT'
2055: AND aca.pk1 = p_audit_project_id
2257:
2258:
2259: UPDATE AMW_AP_ASSOCIATIONS apa
2260: SET apa.audit_procedure_rev_id = (SELECT audit_procedure_rev_id
2261: FROM amw_audit_procedures_b aapb1
2262: WHERE aapb1.audit_procedure_id = apa.audit_procedure_id
2263: AND aapb1.curr_approved_flag = 'Y')
2264: WHERE apa.object_type = 'PROJECT'
2265: AND apa.pk1 = p_audit_project_id
2300: apa.pk1 organization_id,
2301: apa.pk2 control_id,
2302: pt2.task_id
2303: FROM amw_ap_associations apa,
2304: amw_audit_procedures_b aapb,
2305: amw_ap_tasks apt,
2306: amw_control_associations aca,
2307: amw_audit_projects_v pp,
2308: amw_audit_tasks_v pt1,
2371: apa.pk1 organization_id,
2372: apa.pk2 control_id,
2373: pt2.task_id
2374: FROM amw_ap_associations apa,
2375: amw_audit_procedures_b aapb,
2376: amw_ap_tasks apt,
2377: amw_control_associations aca,
2378: amw_audit_projects_v pp,
2379: amw_template_tasks_v pt1,
2440: aapb.audit_procedure_rev_Id,
2441: apa.pk1 organization_id,
2442: apa.pk2 control_id
2443: FROM amw_ap_associations apa,
2444: amw_audit_procedures_b aapb,
2445: amw_control_associations aca
2446: WHERE apa.object_type = 'ENTITY_AP'
2447: AND aca.object_type='PROJECT'
2448: AND aca.pk1 = p_audit_project_id
2858: );
2859:
2860: UPDATE amw_ap_associations apa
2861: SET apa.audit_procedure_rev_id = (SELECT audit_procedure_rev_id
2862: FROM amw_audit_procedures_b aapb1
2863: WHERE aapb1.audit_procedure_id = apa.audit_procedure_id
2864: AND aapb1.curr_approved_flag = 'Y')
2865: WHERE apa.object_type = p_entity_type
2866: AND apa.pk1 = p_entity_id
2898: aapb.audit_procedure_id,
2899: aapb.audit_procedure_rev_id,
2900: apa.pk1 organization_id,
2901: aca.control_id
2902: FROM amw_ap_associations apa,amw_audit_procedures_b aapb,amw_control_associations aca
2903: WHERE apa.object_type = 'CTRL_ORG'
2904: AND apa.pk1 = each_rec.organization_id
2905: AND apa.pk2 = each_rec.process_id
2906: AND apa.pk3 = aca.control_id
3047:
3048: UPDATE AMW_AP_ASSOCIATIONS apa
3049: SET apa.audit_procedure_rev_id =
3050: (SELECT audit_procedure_rev_id
3051: FROM amw_audit_procedures_b aapb1
3052: WHERE aapb1.audit_procedure_id = apa.audit_procedure_id
3053: AND aapb1.curr_approved_flag = 'Y')
3054: WHERE apa.object_type = p_entity_type
3055: AND apa.pk1 = p_entity_id
3088: aapb.audit_procedure_id,
3089: aapb.audit_procedure_rev_id,
3090: apa.pk1 organization_id,
3091: aca.control_id
3092: FROM amw_ap_associations apa,amw_audit_procedures_b aapb,
3093: amw_control_associations aca
3094: WHERE apa.object_type = 'ENTITY_AP'
3095: AND aca.object_type = p_entity_type
3096: AND aca.pk1 = p_entity_id