DBA Data[Home] [Help]

APPS.RCI_UNMTG_RISKS_ETL_PKG dependencies on AMW_GL_PERIODS_V

Line 267: amw_gl_periods_v agpv

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,
267: amw_gl_periods_v agpv
268: WHERE risks.object_type = 'PROCESS_FINCERT'
269: and all_risks.risk_rev_id = risks.risk_rev_id
270: and o.organization_id = risks.pk2
271: and o.organization_id = otl.organization_id

Line 455: ,amw_gl_periods_v agpv

451: AMW_FIN_PROC_CERT_RELAN afpcr,
452: (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,
453: AMW_FIN_KEY_ACCOUNTS_VL AFKAV
454: /** 10.20.2005 npanandi begin ***/
455: ,amw_gl_periods_v agpv
456: /** 10.20.2005 npanandi end ***/
457: WHERE execs.entity_id = assoctable.pk1
458: AND execs.entity_type = assoctable.object_type
459: AND execs.organization_id = orgtable.organization_id

Line 662: amw_gl_periods_v agpv

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,
662: amw_gl_periods_v agpv
663: WHERE risks.object_type = 'PROCESS_FINCERT'
664: and all_risks.risk_rev_id = risks.risk_rev_id
665: and o.organization_id = risks.pk2
666: and o.organization_id = otl.organization_id