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.

APPS.RCI_ORG_CERT_ETL_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 64: HR_ALL_ORGANIZATION_UNITS_TL otl,

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
66: WHERE ctrls.object_type = 'RISK_FINCERT'
67: and ctrls.control_rev_id = all_ctrls.control_rev_id
68: and all_ctrls.APPROVAL_STATUS = 'A'

Line 92: ,HR_ALL_ORGANIZATION_UNITS_TL haout

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
93: ,amw_opinions_v aov1
94: ,amw_opinions_v aov2
95: ,amw_certification_b acb
96: where aca.object_type='RISK_FINCERT'

Line 147: HR_ALL_ORGANIZATION_UNITS_TL otl,

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
149: WHERE ctrls.object_type = 'RISK_FINCERT'
150: and ctrls.control_rev_id = all_ctrls.control_rev_id
151: and all_ctrls.APPROVAL_STATUS = 'A'

Line 219: HR_ALL_ORGANIZATION_UNITS_TL otl,

215: FROM AMW_RISK_ASSOCIATIONS risks,
216: AMW_RISKS_ALL_VL all_risks,
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

Line 338: HR_ALL_ORGANIZATION_UNITS_TL otl,

334: from AMW_FIN_CERT_SCOPE finscope,
335: AMW_FIN_PROC_CERT_RELAN REL,
336: AMW_FIN_PROCESS_EVAL_SUM finprocsum,
337: HR_ALL_ORGANIZATION_UNITS o,
338: HR_ALL_ORGANIZATION_UNITS_TL otl,
339: AMW_PROCESS_ORGANIZATION_VL proc,
340: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
341: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn
342: where rel.FIN_STMT_CERT_ID = finprocsum.FIN_CERTIFICATION_ID

Line 377: HR_ALL_ORGANIZATION_UNITS_TL otl,

373: from AMW_FIN_CERT_SCOPE finscope,
374: AMW_FIN_PROC_CERT_RELAN REL,
375: AMW_FIN_PROCESS_EVAL_SUM finprocsum,
376: HR_ALL_ORGANIZATION_UNITS o,
377: HR_ALL_ORGANIZATION_UNITS_TL otl,
378: AMW_PROCESS_ORGANIZATION_VL proc,
379: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
380: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn
381: where rel.FIN_STMT_CERT_ID = finprocsum.FIN_CERTIFICATION_ID

Line 416: HR_ALL_ORGANIZATION_UNITS_TL otl,

412: from AMW_FIN_CERT_SCOPE finscope,
413: AMW_FIN_PROC_CERT_RELAN REL,
414: AMW_FIN_PROCESS_EVAL_SUM finprocsum,
415: HR_ALL_ORGANIZATION_UNITS o,
416: HR_ALL_ORGANIZATION_UNITS_TL otl,
417: AMW_PROCESS_ORGANIZATION_VL proc,
418: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
419: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn
420: where rel.FIN_STMT_CERT_ID = finprocsum.FIN_CERTIFICATION_ID