DBA Data[Home] [Help]

APPS.RCI_UNMTG_RISKS_ETL_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 262: HR_ALL_ORGANIZATION_UNITS_TL otl,

258: FROM AMW_RISK_ASSOCIATIONS risks,
259: AMW_RISKS_ALL_VL all_risks,
260: AMW_PROCESS_ORGANIZATION_VL proc,
261: HR_ALL_ORGANIZATION_UNITS o,
262: HR_ALL_ORGANIZATION_UNITS_TL otl,
263: AMW_OPINIONS_LOG_V op,
264: amw_certification_vl acv,
265: (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,
266: AMW_FIN_KEY_ACCOUNTS_VL AFKAV,

Line 657: HR_ALL_ORGANIZATION_UNITS_TL otl,

653: FROM AMW_RISK_ASSOCIATIONS risks,
654: AMW_RISKS_ALL_VL all_risks,
655: AMW_PROCESS_ORGANIZATION_VL proc,
656: HR_ALL_ORGANIZATION_UNITS o,
657: HR_ALL_ORGANIZATION_UNITS_TL otl,
658: AMW_OPINIONS_LOG_V op,
659: amw_certification_vl acv,
660: (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,
661: AMW_FIN_KEY_ACCOUNTS_VL AFKAV,