APPS.AMW_PROCCERT_EVENT_PVT dependencies on AMW_OPINIONS_LOG_V

Line 235: FROM amw_opinions_log_v

231: CURSOR c_opinion_rec (c_opinion_log_id NUMBER) IS
232: SELECT opinion_id, object_name, audit_result_code,
233: pk1_value, pk2_value, pk3_value, pk4_value, pk5_value,
234: pk6_value, pk7_value, pk8_value
235: FROM amw_opinions_log_v
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

Line 241: amw_opinions_log_v opin

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
245: AND psum.process_id = c_proc_id

Line 251: amw_opinions_log_v opin

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'
255: AND assoc.risk_id = c_risk_id

Line 263: amw_opinions_log_v opin

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'
267: AND assoc.control_id = c_ctrl_id

Line 1237: FROM amw_opinions_log_v

1233: CURSOR c_opinion_rec (c_opinion_log_id NUMBER) IS
1234: SELECT opinion_id, object_name, audit_result_code,
1235: pk1_value, pk2_value, pk3_value, pk4_value, pk5_value,
1236: pk6_value, pk7_value, pk8_value
1237: FROM amw_opinions_log_v
1238: WHERE opinion_log_id = c_opinion_log_id;
1239:
1240: CURSOR c_old_opinion (c_opin_log_id NUMBER) IS
1241: SELECT audit_result_code

Line 1242: FROM amw_opinions_log_v

1238: WHERE opinion_log_id = c_opinion_log_id;
1239:
1240: CURSOR c_old_opinion (c_opin_log_id NUMBER) IS
1241: SELECT audit_result_code
1242: FROM amw_opinions_log_v
1243: WHERE opinion_log_id =
1244: (SELECT max(v2.opinion_log_id)
1245: FROM amw_opinions_log_v v1, amw_opinions_log_v v2
1246: WHERE v1.opinion_log_id = c_opin_log_id

Line 1245: FROM amw_opinions_log_v v1, amw_opinions_log_v v2

1241: SELECT audit_result_code
1242: FROM amw_opinions_log_v
1243: WHERE opinion_log_id =
1244: (SELECT max(v2.opinion_log_id)
1245: FROM amw_opinions_log_v v1, amw_opinions_log_v v2
1246: WHERE v1.opinion_log_id = c_opin_log_id
1247: AND v1.opinion_id = v2.opinion_id
1248: AND v2.opinion_log_id < c_opin_log_id);
1249: