APPS.JL_ZZ_GL_INFL_ADJ_PKG dependencies on GL_PERIOD_STATUSES

Line 489: FROM gl_period_statuses

485:
486: statement := 'ACCOUNTING DATE';
487: SELECT end_date
488: INTO p_accounting_date
489: FROM gl_period_statuses
490: WHERE application_id = GL_APPS_ID
491: AND set_of_books_id = p_set_of_books_id
492: AND period_name = p_to_period_name;
493:

Line 1087: , gl_period_statuses gps

1083: sum (nvl (accounted_cr, 0)) FV_total
1084: , gps.period_name
1085: FROM gl_je_lines gjl
1086: , gl_je_headers gjh
1087: , gl_period_statuses gps
1088: WHERE gjh.status = 'P'
1089: AND gjh.ledger_id = p_set_of_books_id
1090: AND gjl.je_header_id = gjh.je_header_id
1091: AND gjl.code_combination_id = p_code_combination_id