DBA Data[Home] [Help]

APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_AUDIT_UNITS_V

Line 303: amw_audit_units_v orgtable,

299: (
300: select distinct count(*)
301: from amw_risk_associations assoctable,
302: amw_risks_all_vl risktable,
303: amw_audit_units_v orgtable,
304: amw_wf_org_hierarchy_main_v processtable,
305: fnd_objects fo,
306: amw_opinion_types_tl optypes,
307: AMW_OBJECT_OPINION_TYPES objoptypes,

Line 383: amw_audit_units_v orgtable,

379: from amw_control_associations ctrlassoc,
380: amw_risk_associations riskassoc,
381: amw_process_organization procorg,
382: amw_controls_all_vl controltable,
383: amw_audit_units_v orgtable,
384: amw_wf_org_hierarchy_main_v processtable,
385: fnd_objects fo,
386: amw_opinion_types_tl optypes,
387: AMW_OBJECT_OPINION_TYPES objoptypes,

Line 2798: FROM amw_audit_units_v

2794: AND aca.pk1 = ara.risk_association_id;
2795:
2796: CURSOR c_org IS
2797: SELECT subsidiary_valueset, company_code, lob_valueset, lob_code
2798: FROM amw_audit_units_v
2799: WHERE organization_id = p_organization_id;
2800:
2801: l_eval_opinion_id NUMBER;
2802: l_proc_pending_cert NUMBER;