APPS.RCI_PROC_DETAIL_ETL_PKG dependencies on AMW_GL_PERIODS_V

Line 340: amw_gl_periods_v agpv

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
342: and rel.end_date is null
343: and finprocsum.FIN_CERTIFICATION_ID = finscope.fin_certification_id
344: and finprocsum.ORGANIZATION_ID = finscope.ORGANIZATION_ID

Line 542: amw_gl_periods_v agpv

538: AMW_FIN_PROC_CERT_RELAN afpcr,
539: (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,
540: AMW_FIN_KEY_ACCOUNTS_VL AFKAV,
541: /** 10.19.2005 npanandi begin ***/
542: amw_gl_periods_v agpv
543: /** 10.19.2005 npanandi end ***/
544: WHERE execs.entity_id = opinions_cert.pk2_value(+)
545: AND execs.organization_id = opinions_cert.pk3_value(+)
546: AND execs.process_id = opinions_cert.pk1_value(+)

Line 749: amw_gl_periods_v agpv

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
751: and rel.end_date is null
752: and finprocsum.FIN_CERTIFICATION_ID = finscope.fin_certification_id
753: and finprocsum.ORGANIZATION_ID = finscope.ORGANIZATION_ID

Line 936: amw_gl_periods_v agpv

932: AMW_FIN_PROC_CERT_RELAN afpcr,
933: (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,
934: AMW_FIN_KEY_ACCOUNTS_VL AFKAV,
935: /** 10.19.2005 npanandi begin ***/
936: amw_gl_periods_v agpv
937: /** 10.19.2005 npanandi end ***/
938: WHERE execs.entity_id = opinions_cert.pk2_value(+)
939: AND execs.organization_id = opinions_cert.pk3_value(+)
940: AND execs.process_id = opinions_cert.pk1_value(+)