DBA Data[Home] [Help]

APPS.RCI_PROC_CERT_SUMM_PKG dependencies on AMW_CERTIFICATION_B

Line 619: amw_certification_b acb, amw_gl_periods_v agpv, amw_fin_cert_scope fin_scope

615: to_number(to_char(agpv.period_year)||to_char(agpv.quarter_num)) ent_qtr_id,
616: agpv.period_year ent_year_id,
617: to_number(to_char(agpv.end_date,'J')) report_date_julian
618: FROM
619: amw_certification_b acb, amw_gl_periods_v agpv, amw_fin_cert_scope fin_scope
620: WHERE
621: acb.object_type = 'FIN_STMT'
622: -- AND acb.certification_status in ('ACTIVE','DRAFT')
623: AND acb.certification_id = fin_scope.fin_certification_id

Line 669: amw_certification_b acb, amw_gl_periods_v agpv, amw_opinions_log_v aolv

665: agpv.period_year ent_year_id,
666: to_number(to_char(agpv.end_date,'J')) report_date_julian,
667: G_USER_ID, sysdate, G_USER_ID, sysdate, G_LOGIN_ID
668: FROM
669: amw_certification_b acb, amw_gl_periods_v agpv, amw_opinions_log_v aolv
670: WHERE
671: acb.object_type = 'PROCESS'
672: AND aolv.opinion_type_code = 'CERTIFICATION'
673: AND aolv.object_name = 'AMW_ORG_PROCESS'