DBA Data[Home] [Help]

APPS.RCI_CTRL_DETAIL_ETL_PKG dependencies on AMW_CERTIFICATION_VL

Line 278: amw_certification_vl acv,

274: AMW_CONTROLS_ALL_VL all_ctrls,
275: HR_ALL_ORGANIZATION_UNITS o,
276: HR_ALL_ORGANIZATION_UNITS_TL otl,
277: AMW_OPINIONS_LOG_V op,
278: amw_certification_vl acv,
279: amw_fin_cert_scope afcs,
280: amw_gl_periods_v agpv
281: WHERE ctrls.object_type = 'RISK_FINCERT'
282: and ctrls.control_rev_id = all_ctrls.control_rev_id

Line 476: amw_certification_vl acv,

472: amw_audit_units_v orgtable,
473: amw_opinions_log_v opinionstable,
474: amw_execution_scope execs,
475: AMW_PROCESS_ORGANIZATION_VL procorg,
476: amw_certification_vl acv,
477: amw_certification_vl acv2,
478: AMW_FIN_PROC_CERT_RELAN afpcr,
479: (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,
480: AMW_FIN_KEY_ACCOUNTS_VL AFKAV

Line 477: amw_certification_vl acv2,

473: amw_opinions_log_v opinionstable,
474: amw_execution_scope execs,
475: AMW_PROCESS_ORGANIZATION_VL procorg,
476: amw_certification_vl acv,
477: amw_certification_vl acv2,
478: AMW_FIN_PROC_CERT_RELAN afpcr,
479: (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,
480: AMW_FIN_KEY_ACCOUNTS_VL AFKAV
481: ,amw_gl_periods_v agpv

Line 687: amw_certification_vl acv,

683: AMW_CONTROLS_ALL_VL all_ctrls,
684: HR_ALL_ORGANIZATION_UNITS o,
685: HR_ALL_ORGANIZATION_UNITS_TL otl,
686: AMW_OPINIONS_LOG_V op,
687: amw_certification_vl acv,
688: amw_fin_cert_scope afcs,
689: amw_gl_periods_v agpv
690: WHERE ctrls.object_type = 'RISK_FINCERT'
691: and ctrls.control_rev_id = all_ctrls.control_rev_id

Line 869: amw_certification_vl acv,

865: amw_audit_units_v orgtable,
866: amw_opinions_log_v opinionstable,
867: amw_execution_scope execs,
868: AMW_PROCESS_ORGANIZATION_VL procorg,
869: amw_certification_vl acv,
870: amw_certification_vl acv2,
871: AMW_FIN_PROC_CERT_RELAN afpcr,
872: (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,
873: AMW_FIN_KEY_ACCOUNTS_VL AFKAV

Line 870: amw_certification_vl acv2,

866: amw_opinions_log_v opinionstable,
867: amw_execution_scope execs,
868: AMW_PROCESS_ORGANIZATION_VL procorg,
869: amw_certification_vl acv,
870: amw_certification_vl acv2,
871: AMW_FIN_PROC_CERT_RELAN afpcr,
872: (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,
873: AMW_FIN_KEY_ACCOUNTS_VL AFKAV
874: ,amw_gl_periods_v agpv