DBA Data[Home] [Help]

APPS.RCI_PROC_DETAIL_ETL_PKG dependencies on AMW_OPINIONS_V

Line 336: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,

332: AMW_FIN_PROCESS_EVAL_SUM finprocsum,
333: HR_ALL_ORGANIZATION_UNITS o,
334: HR_ALL_ORGANIZATION_UNITS_TL otl,
335: AMW_PROCESS_ORGANIZATION_VL proc,
336: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
337: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn,
338: amw_certification_b acb,
339: (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,
340: amw_gl_periods_v agpv

Line 337: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn,

333: HR_ALL_ORGANIZATION_UNITS o,
334: HR_ALL_ORGANIZATION_UNITS_TL otl,
335: AMW_PROCESS_ORGANIZATION_VL proc,
336: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
337: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn,
338: amw_certification_b acb,
339: (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,
340: amw_gl_periods_v agpv
341: where rel.FIN_STMT_CERT_ID = finprocsum.FIN_CERTIFICATION_ID

Line 531: amw_opinions_v opinions_cert,

527: G_USER_ID,
528: G_LOGIN_ID
529: FROM amw_proc_cert_eval_sum proccert,
530: amw_opinions_log_v opinions_eval,
531: amw_opinions_v opinions_cert,
532: amw_process_organization_vl process,
533: amw_execution_scope execs,
534: amw_audit_units_v audit_v,
535: amw_certification_vl acv,

Line 745: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,

741: AMW_FIN_PROCESS_EVAL_SUM finprocsum,
742: HR_ALL_ORGANIZATION_UNITS o,
743: HR_ALL_ORGANIZATION_UNITS_TL otl,
744: AMW_PROCESS_ORGANIZATION_VL proc,
745: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
746: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn,
747: amw_certification_b acb,
748: (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,
749: amw_gl_periods_v agpv

Line 746: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn,

742: HR_ALL_ORGANIZATION_UNITS o,
743: HR_ALL_ORGANIZATION_UNITS_TL otl,
744: AMW_PROCESS_ORGANIZATION_VL proc,
745: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
746: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn,
747: amw_certification_b acb,
748: (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,
749: amw_gl_periods_v agpv
750: where rel.FIN_STMT_CERT_ID = finprocsum.FIN_CERTIFICATION_ID

Line 925: amw_opinions_v opinions_cert,

921: G_USER_ID,
922: G_LOGIN_ID
923: FROM amw_proc_cert_eval_sum proccert,
924: amw_opinions_log_v opinions_eval,
925: amw_opinions_v opinions_cert,
926: amw_process_organization_vl process,
927: amw_execution_scope execs,
928: amw_audit_units_v audit_v,
929: amw_certification_vl acv,