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_DFCY_ETL_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 309: HR_ALL_ORGANIZATION_UNITS_TL otl,

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'
312: and ctrls.control_rev_id = all_ctrls.control_rev_id
313: and all_ctrls.APPROVAL_STATUS = 'A'

Line 357: ,HR_ALL_ORGANIZATION_UNITS_TL haout

353: from amw_control_associations aca
354: ,amw_opinions_log_v aolv
355: ,amw_latest_revisions_v alrv
356: ,HR_ALL_ORGANIZATION_UNITS haou
357: ,HR_ALL_ORGANIZATION_UNITS_TL haout
358: ,amw_opinions_v aov1
359: ,amw_opinions_v aov2
360: ,amw_certification_b acb
361: ,(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

Line 924: HR_ALL_ORGANIZATION_UNITS_TL otl,

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'
927: and ctrls.control_rev_id = all_ctrls.control_rev_id
928: and all_ctrls.APPROVAL_STATUS = 'A'