APPS.AMW_PROCCERT_EVENT_PVT dependencies on AMW_CERTIFICATION_B

Line 114: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period

110: AND organization_id = c_org_id;
111:
112: CURSOR c_start_date(c_cert_id NUMBER) IS
113: SELECT period.start_date
114: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
115: WHERE cert.certification_period_name = period.period_name
116: AND cert.certification_period_set_name = period.period_set_name
117: AND cert.certification_id = c_cert_id;
118:

Line 240: FROM amw_certification_b cert, amw_proc_cert_eval_sum psum,

236: WHERE opinion_log_id = c_opinion_log_id;
237:
238: CURSOR c_cert_with_proc (c_proc_id NUMBER, c_org_id NUMBER) IS
239: SELECT cert.certification_id, opin.audit_result_code old_eval
240: FROM amw_certification_b cert, amw_proc_cert_eval_sum psum,
241: amw_opinions_log_v opin
242: WHERE cert.certification_status in ('ACTIVE','DRAFT')
243: AND cert.certification_id = psum.certification_id
244: AND psum.organization_id = c_org_id

Line 250: FROM amw_certification_b cert, amw_risk_associations assoc,

246: AND psum.evaluation_opinion_log_id = opin.opinion_log_id(+);
247:
248: CURSOR c_cert_with_risk (c_risk_id NUMBER, c_proc_id NUMBER, c_org_id NUMBER) IS
249: SELECT cert.certification_id, opin.audit_result_code old_eval
250: FROM amw_certification_b cert, amw_risk_associations assoc,
251: amw_opinions_log_v opin
252: WHERE cert.certification_status in ('ACTIVE','DRAFT')
253: AND cert.certification_id = assoc.pk1
254: AND assoc.object_type = 'BUSIPROC_CERTIFICATION'

Line 262: FROM amw_certification_b cert, amw_control_associations assoc,

258: AND assoc.pk4 = opin.opinion_log_id(+);
259:
260: CURSOR c_cert_with_ctrl (c_ctrl_id NUMBER, c_org_id NUMBER) IS
261: SELECT cert.certification_id, opin.audit_result_code old_eval
262: FROM amw_certification_b cert, amw_control_associations assoc,
263: amw_opinions_log_v opin
264: WHERE cert.certification_status in ('ACTIVE','DRAFT')
265: AND cert.certification_id = assoc.pk1
266: AND assoc.object_type = 'BUSIPROC_CERTIFICATION'

Line 308: FROM amw_certification_b cert

304: FROM amw_org_cert_eval_sum
305: WHERE organization_id = l_org_id
306: AND certification_id IN (
307: SELECT cert.certification_id
308: FROM amw_certification_b cert
309: WHERE cert.certification_status in ('ACTIVE','DRAFT')
310: AND cert.object_type = 'PROCESS');
311:
312: CURSOR c_fch_vs_id IS

Line 393: FROM amw_certification_b cert, amw_execution_scope scope

389: evaluation_opinion_log_id = l_opin_log_id
390: WHERE organization_id = l_pk1
391: AND certification_id IN (
392: SELECT cert.certification_id
393: FROM amw_certification_b cert, amw_execution_scope scope
394: WHERE cert.certification_status in ('ACTIVE','DRAFT')
395: AND cert.object_type = 'PROCESS'
396: AND scope.entity_type = 'BUSIPROC_CERTIFICATION'
397: AND scope.entity_id = cert.certification_id

Line 572: FROM amw_certification_b cert, amw_proc_cert_eval_sum psum

568: WHERE process_id = l_pk1
569: AND organization_id = l_pk3
570: AND certification_id in (
571: SELECT cert.certification_id
572: FROM amw_certification_b cert, amw_proc_cert_eval_sum psum
573: WHERE cert.certification_status in ('ACTIVE','DRAFT')
574: AND cert.certification_id = psum.certification_id
575: AND psum.organization_id = l_pk3
576: AND psum.process_id = l_pk1);

Line 838: FROM amw_certification_b cert, amw_risk_associations assoc

834: AND pk2 = l_pk3 -- organization_id
835: AND NVL(pk3,-1) = NVL(l_pk4,-1) -- process_id
836: AND pk1 IN (
837: SELECT assoc.pk1
838: FROM amw_certification_b cert, amw_risk_associations assoc
839: WHERE cert.certification_status in ('ACTIVE','DRAFT')
840: AND cert.certification_id = assoc.pk1
841: AND assoc.object_type = 'BUSIPROC_CERTIFICATION'
842: AND assoc.risk_id = l_pk1

Line 1135: FROM amw_certification_b cert, amw_control_associations assoc

1131: AND control_id = l_pk1
1132: AND pk2 = l_pk3 -- organization_id
1133: AND pk1 IN (
1134: SELECT assoc.pk1
1135: FROM amw_certification_b cert, amw_control_associations assoc
1136: WHERE cert.certification_status in ('ACTIVE','DRAFT')
1137: AND cert.certification_id = assoc.pk1
1138: AND assoc.object_type = 'BUSIPROC_CERTIFICATION'
1139: AND assoc.control_id = l_pk1

Line 1154: FROM amw_certification_b cert, amw_ap_associations assoc

1150: AND pk2 = l_pk3 -- organization_id
1151: AND pk3 = l_pk4 -- control_id
1152: AND pk1 IN (
1153: SELECT assoc.pk1
1154: FROM amw_certification_b cert, amw_ap_associations assoc
1155: WHERE cert.certification_status in ('ACTIVE','DRAFT')
1156: AND cert.certification_id = assoc.pk1
1157: AND assoc.object_type = 'BUSIPROC_CERTIFICATION'
1158: AND assoc.audit_procedure_id = l_pk1