eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.RCI_ORG_DFCY_ETL_PKG dependencies on AMW_RISK_ASSOCIATIONS

Line 40: FROM amw_risk_associations ara, amw_opinions_v aov

36: ,c_organization_id in number
37: ,c_process_id in number) is
38: SELECT count(1)
39: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
40: FROM amw_risk_associations ara, amw_opinions_v aov
41: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
42: AND ara.pk1 = c_certification_id
43: AND ara.pk2 = c_organization_id
44: AND ara.pk3 IN (SELECT DISTINCT process_id