DBA Data[Home] [Help]

APPS.JL_ZZ_GL_INFL_ADJ_PKG dependencies on GL_PERIOD_STATUSES

Line 474: FROM gl_period_statuses

470:
471: statement := 'ACCOUNTING DATE';
472: SELECT end_date
473: INTO p_accounting_date
474: FROM gl_period_statuses
475: WHERE application_id = GL_APPS_ID
476: AND set_of_books_id = p_set_of_books_id
477: AND period_name = p_to_period_name;
478:

Line 1072: , gl_period_statuses gps

1068: sum (nvl (accounted_cr, 0)) FV_total
1069: , gps.period_name
1070: FROM gl_je_lines gjl
1071: , gl_je_headers gjh
1072: , gl_period_statuses gps
1073: WHERE gjh.status = 'P'
1074: AND gjh.ledger_id = p_set_of_books_id
1075: AND gjl.je_header_id = gjh.je_header_id
1076: AND gjl.code_combination_id = p_code_combination_id