APPS.RCI_SIG_ACCT_EVAL_SUMM_PKG dependencies on AMW_CONTROL_ASSOCIATIONS

Line 282: select count(*) into v_count from amw_control_Associations where pk1=p_org_id and (object_type='RISK_ORG' or object_type='ENTITY_CONTROL');

278: -- used in get_org_details
279: FUNCTION get_control_count(p_org_id number) return number is
280: v_count number;
281: BEGIN
282: select count(*) into v_count from amw_control_Associations where pk1=p_org_id and (object_type='RISK_ORG' or object_type='ENTITY_CONTROL');
283: return v_count;
284: END;
285:
286: -- used in get_org_details

Line 486: FROM amw_control_associations aca,amw_opinions_v aov

482: BEGIN
483: SELECT
484: count(1) into v_cnt
485: FROM (SELECT DISTINCT aca.pk1 cert_id, aca.pk2 org_id, aca.control_id
486: FROM amw_control_associations aca,amw_opinions_v aov
487: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
488: AND aca.pk1 = p_cert_id
489: AND aca.pk2 = p_org_id
490: AND aov.object_name = 'AMW_ORG_CONTROL'

Line 511: FROM amw_control_associations aca,amw_opinions_v aov

507: v_cnt number;
508: BEGIN
509: SELECT count(1) into v_cnt
510: FROM (SELECT DISTINCT aca.pk1 cert_id, aca.pk2 org_id, aca.control_id
511: FROM amw_control_associations aca,amw_opinions_v aov
512: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
513: AND aca.pk1 = p_cert_id
514: AND aca.pk2 = p_org_id
515: AND aov.object_name = 'AMW_ORG_CONTROL'