DBA Data[Home] [Help]

APPS.RCI_ORG_DFCY_ETL_PKG dependencies on AMW_CONTROLS_ALL_VL

Line 307: AMW_CONTROLS_ALL_VL all_ctrls,

303: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
304: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
305: and OPINION_COMPONENT_CODE = 'DESIGN')) des_eff_id
306: FROM AMW_CONTROL_ASSOCIATIONS ctrls,
307: AMW_CONTROLS_ALL_VL all_ctrls,
308: HR_ALL_ORGANIZATION_UNITS o,
309: HR_ALL_ORGANIZATION_UNITS_TL otl,
310: AMW_OPINIONS_LOG_V op
311: WHERE ctrls.object_type = 'RISK_FINCERT'

Line 922: AMW_CONTROLS_ALL_VL all_ctrls,

918: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
919: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
920: and OPINION_COMPONENT_CODE = 'DESIGN')) des_eff_id
921: FROM AMW_CONTROL_ASSOCIATIONS ctrls,
922: AMW_CONTROLS_ALL_VL all_ctrls,
923: HR_ALL_ORGANIZATION_UNITS o,
924: HR_ALL_ORGANIZATION_UNITS_TL otl,
925: AMW_OPINIONS_LOG_V op
926: WHERE ctrls.object_type = 'RISK_FINCERT'