DBA Data[Home] [Help]

APPS.RCI_ORG_CERT_ETL_PKG dependencies on AMW_ACCT_ASSOCIATIONS

Line 221: (select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa

217: AMW_PROCESS_ORGANIZATION_VL proc,
218: HR_ALL_ORGANIZATION_UNITS o,
219: HR_ALL_ORGANIZATION_UNITS_TL otl,
220: AMW_OPINIONS_LOG_V op,
221: (select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa
222: WHERE risks.object_type = 'PROCESS_FINCERT'
223: and all_risks.risk_rev_id = risks.risk_rev_id
224: and o.organization_id = risks.pk2
225: and o.organization_id = otl.organization_id