[Home] [Help]
613:
614: --in risk association table, if type = 'PROCESS_FINCERT', pk1=certification_id, pk2=organization_id, pk3=process_id, pk4=opinion_log_id
615: CURSOR last_evaluation(l_risk_id number, l_organization_id number, l_process_id number) IS
616: select distinct ao.opinion_log_id
617: from AMW_OPINIONS_LOG ao,
618: AMW_OBJECT_OPINION_TYPES aoot,
619: AMW_OPINION_TYPES_B aot,
620: FND_OBJECTS fo
621: where ao.OBJECT_OPINION_TYPE_ID = aoot.OBJECT_OPINION_TYPE_ID
823: --in control association table, if type = 'RISK_FINCERT', pk1=certification_id, pk2=organization_id, pk3=process_id, pk4=risk_id, pk5=opinion_log_id
824: CURSOR last_evaluation(l_organization_id number, l_control_id number) IS
825: select distinct ao.opinion_log_id
826: from
827: AMW_OPINIONS_LOG ao,
828: AMW_OBJECT_OPINION_TYPES aoot,
829: AMW_OPINION_TYPES_B aot,
830: FND_OBJECTS fo
831: where ao.OBJECT_OPINION_TYPE_ID = aoot.OBJECT_OPINION_TYPE_ID
1331: l_stmt := 'select count(1) from (
1332: select distinct fin.risk_id ,fin.organization_id, fin.Process_ID
1333: FROM
1334: amw_opinion_m_v aov,
1335: amw_opinions_log aol,
1336: amw_fin_item_acc_risk fin
1337: WHERE
1338: aov.OPINION_TYPE_CODE = ''EVALUATION''
1339: and aov.object_name = ''AMW_ORG_PROCESS_RISK''
1397: l_stmt := 'select count(1) from(
1398: select distinct fin.control_id, fin.organization_id
1399: FROM
1400: amw_opinion_m_v aov,
1401: amw_opinions_log aol,
1402: amw_fin_item_acc_ctrl fin
1403: WHERE aov.OPINION_TYPE_CODE = ''EVALUATION''
1404: and aov.object_name = ''AMW_ORG_CONTROL''
1405: and aov.opinion_component_code = ''OVERALL''