APPS.RCI_ORG_CERT_ETL_PKG dependencies on AMW_CONTROL_ASSOCIATIONS

Line 61: FROM AMW_CONTROL_ASSOCIATIONS ctrls,

57: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
58: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
59: and OPINION_COMPONENT_CODE = 'DESIGN')) des_eff_id
60: ***/
61: FROM AMW_CONTROL_ASSOCIATIONS ctrls,
62: AMW_CONTROLS_ALL_VL all_ctrls,
63: HR_ALL_ORGANIZATION_UNITS o,
64: HR_ALL_ORGANIZATION_UNITS_TL otl,
65: AMW_OPINIONS_LOG_V op

Line 88: from amw_control_associations aca

84: ,aov1.authored_by ----certified_by_id
85: ,aov2.audit_result_code -----evaluation_result_code
86: ,aov2.authored_by -----last_evaluated_by_id
87: ,aov2.authored_date -----last_evaluated_on
88: from amw_control_associations aca
89: ,amw_opinions_log_v aolv
90: ,amw_latest_revisions_v alrv
91: ,HR_ALL_ORGANIZATION_UNITS haou
92: ,HR_ALL_ORGANIZATION_UNITS_TL haout

Line 144: FROM AMW_CONTROL_ASSOCIATIONS ctrls,

140: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
141: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
142: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
143: and OPINION_COMPONENT_CODE = 'DESIGN')) des_eff_id
144: FROM AMW_CONTROL_ASSOCIATIONS ctrls,
145: AMW_CONTROLS_ALL_VL all_ctrls,
146: HR_ALL_ORGANIZATION_UNITS o,
147: HR_ALL_ORGANIZATION_UNITS_TL otl,
148: AMW_OPINIONS_LOG_V op

Line 173: FROM amw_control_associations ctrlassoc,

169: controltable.control_id as ctrl_id,
170: opinionstable.audit_result as eval,
171: ctrlassoc.control_rev_id as ctrl_rev_id,
172: opinionstable.audit_result_code as audit_result_code
173: FROM amw_control_associations ctrlassoc,
174: amw_controls_all_vl controltable,
175: amw_audit_units_v orgtable,
176: amw_opinions_log_v opinionstable,
177: amw_execution_scope execs,