APPS.RCI_ORG_CERT_ETL_PKG dependencies on AMW_GL_PERIODS_V

Line 348: amw_gl_periods_v agpv,

344: amw_audit_units_v auv,
345: amw_opinions_log_v certopinion,
346: amw_opinions_log_v evalopinion,
347: amw_certification_vl acv,
348: amw_gl_periods_v agpv,
349: amw_fin_cert_scope afcs
350: WHERE hier.entity_type = 'FINSTMT_CERTIFICATION'
351: AND hier.entity_id = orgeval.fin_certification_id
352: and acv.certification_id = hier.entity_id

Line 621: ,amw_gl_periods_v agpv

617: ,AMW_FIN_PROC_CERT_RELAN afpcr
618: ,(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
619: ,AMW_FIN_KEY_ACCOUNTS_VL AFKAV
620: /** 10.20.2005 npanandi begin ***/
621: ,amw_gl_periods_v agpv
622: /** 10.20.2005 npanandi end ***/
623: where entity_type='BUSIPROC_CERTIFICATION'
624: and acv.object_type='PROCESS'
625: and acv.certification_id=aes.entity_id

Line 894: amw_gl_periods_v agpv,

890: amw_audit_units_v auv,
891: amw_opinions_log_v certopinion,
892: amw_opinions_log_v evalopinion,
893: amw_certification_vl acv,
894: amw_gl_periods_v agpv,
895: amw_fin_cert_scope afcs
896: WHERE hier.entity_type = 'FINSTMT_CERTIFICATION'
897: AND hier.entity_id = orgeval.fin_certification_id
898: and acv.certification_id = hier.entity_id

Line 1138: ,amw_gl_periods_v agpv

1134: ,AMW_FIN_PROC_CERT_RELAN afpcr
1135: ,(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
1136: ,AMW_FIN_KEY_ACCOUNTS_VL AFKAV
1137: /** 10.20.2005 npanandi begin ***/
1138: ,amw_gl_periods_v agpv
1139: /** 10.20.2005 npanandi end ***/
1140: where entity_type='BUSIPROC_CERTIFICATION'
1141: and acv.object_type='PROCESS'
1142: and acv.certification_id=aes.entity_id