APPS.RCI_SIG_ACCT_EVAL_SUMM_PKG dependencies on AMW_GL_PERIODS_V

Line 229: ,(select period_name, quarter_num, period_year from amw_gl_periods_v) agpv*/

225: ,amw_fin_stmnt_vl afsv
226: /* ,(select id,value from rci_fs_acct_eval_v where obj_name=''AMW_KEY_ACCOUNT'') evallook
227: ,(select * from rci_fs_cert_status_v rfcsv) statuslook
228: ,(select * from rci_fs_cert_type_v rfctv) typelook
229: ,(select period_name, quarter_num, period_year from amw_gl_periods_v) agpv*/
230: ,rci_fs_cert_status_v statuslook
231: ,rci_fs_cert_type_v typelook
232: ,amw_gl_periods_v agpv
233: /*01.26.2006 npanandi: bug 5000443 fix below**/

Line 232: ,amw_gl_periods_v agpv

228: ,(select * from rci_fs_cert_type_v rfctv) typelook
229: ,(select period_name, quarter_num, period_year from amw_gl_periods_v) agpv*/
230: ,rci_fs_cert_status_v statuslook
231: ,rci_fs_cert_type_v typelook
232: ,amw_gl_periods_v agpv
233: /*01.26.2006 npanandi: bug 5000443 fix below**/
234: ,RCI_FS_ACCT_EVAL_V rfaev
235: WHERE
236: accteval.sig_acct_id = afces.natural_account_id

Line 397: period_year ent_year_id from amw_gl_periods_v) agpv

393: evalopinion
394: ,(select period_name, period_set_name,
395: to_number(to_char(period_year)||to_char(quarter_num)||to_char(period_num)) ent_period_id,
396: to_number(to_char(period_year)||to_char(quarter_num)) ent_qtr_id,
397: period_year ent_year_id from amw_gl_periods_v) agpv
398: WHERE
399: aauv.organization_id = rocsf.organization_id
400: AND acv.certification_id = rocsf.certification_id
401: AND certres.id = nvl(rocsf.org_certification_status,''NOT_CERTIFIED'')

Line 1282: ,amw_gl_periods_v agpv

1278: amw_fin_cert_scope a
1279: ,amw_fin_cert_eval_sum afces
1280: ,amw_certification_b acb
1281: ,amw_opinions_v o
1282: ,amw_gl_periods_v agpv
1283: WHERE
1284: a.fin_certification_id = acb.certification_id
1285: and acb.object_type = 'FIN_STMT'
1286: and afces.object_type = 'ACCOUNT'