APPS.AMW_FINSTMT_CERT_MIG_PKG dependencies on AMW_OPINIONS

Line 617: from AMW_OPINIONS_LOG ao,

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

Line 630: from AMW_OPINIONS aov2

626: and ao.pk3_value = l_organization_id
627: and ao.pk4_value = l_process_id
628: and ao.pk1_value = l_risk_id
629: and ao.authored_date = (select max(aov2.authored_date)
630: from AMW_OPINIONS aov2
631: where aov2.object_opinion_type_id = ao.object_opinion_type_id
632: and aov2.pk3_value = ao.pk3_value
633: and aov2.pk1_value = ao.pk1_value
634: and aov2.pk4_value = ao.pk4_value);

Line 827: AMW_OPINIONS_LOG ao,

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

Line 839: from AMW_OPINIONS aov2

835: and aot.opinion_type_code = 'EVALUATION'
836: and ao.pk3_value = l_organization_id
837: and ao.pk1_value = l_control_id
838: and ao.authored_date = (select max(aov2.authored_date)
839: from AMW_OPINIONS aov2
840: where aov2.object_opinion_type_id = ao.object_opinion_type_id
841: and aov2.pk3_value = ao.pk3_value
842: and aov2.pk1_value = ao.pk1_value);
843:

Line 1041: from AMW_OPINIONS aov2

1037: AND aov.pk3_value = l_organization_id
1038: AND aov.pk4_value = l_audit_procedure_id
1039: AND aov.pk1_value = l_control_id
1040: AND aov.authored_date = (select max(aov2.authored_date)
1041: from AMW_OPINIONS aov2
1042: where aov2.object_opinion_type_id = aov.object_opinion_type_id
1043: and aov2.pk3_value = aov.pk3_value
1044: and aov2.pk1_value = aov.pk1_value
1045: and aov2.pk4_value = aov.pk4_value);

Line 1335: amw_opinions_log aol,

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''

Line 1401: amw_opinions_log aol,

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''