DBA Data[Home] [Help]

APPS.JA_CN_PS_FA_MI_EXP_PKG dependencies on GL_PERIOD_STATUSES

Line 173: gl_period_statuses

169: start_date
170: INTO
171: ld_start_date
172: FROM
173: gl_period_statuses
174: WHERE ledger_id = pn_ledger_id
175: AND application_id = 101
176: AND period_name = pv_period_from
177: AND period_year = pv_accounting_year;

Line 184: gl_period_statuses

180: end_date
181: INTO
182: ld_end_date
183: FROM
184: gl_period_statuses
185: WHERE ledger_id = pn_ledger_id
186: AND application_id = 101
187: AND period_name = pv_period_to
188: AND period_year = pv_accounting_year;

Line 217: gl_period_statuses gp

213: period_num
214: INTO
215: lv_period_name
216: FROM
217: gl_period_statuses gp
218: WHERE period_year = pv_accounting_year
219: AND application_id = 101
220: AND ledger_id = pn_ledger_id
221: AND gp.adjustment_period_flag = 'N'