APPS.RCI_CTRL_DETAIL_ETL_PKG dependencies on AMW_GL_PERIODS_V

Line 280: amw_gl_periods_v agpv

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
283: and all_ctrls.APPROVAL_STATUS = 'A'
284: and o.organization_id = ctrls.pk2

Line 481: ,amw_gl_periods_v agpv

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
482: WHERE execs.entity_id = ctrlassoc.pk1
483: AND execs.entity_type = ctrlassoc.object_type
484: AND execs.organization_id = orgtable.organization_id
485: AND procorg.process_org_rev_id(+) = execs.process_org_rev_id

Line 689: amw_gl_periods_v agpv

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
692: and all_ctrls.APPROVAL_STATUS = 'A'
693: and o.organization_id = ctrls.pk2

Line 874: ,amw_gl_periods_v agpv

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
875: WHERE execs.entity_id = ctrlassoc.pk1
876: AND execs.entity_type = ctrlassoc.object_type
877: AND execs.organization_id = orgtable.organization_id
878: AND procorg.process_org_rev_id(+) = execs.process_org_rev_id