eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_FA_ADIRA_EXPORT_PKG dependencies on GL_PERIOD_STATUSES

Line 148: FROM GL_PERIOD_STATUSES

144:
145: --Fetch start data and end date
146: SELECT start_date
147: INTO ld_start_date
148: FROM GL_PERIOD_STATUSES
149: WHERE ledger_id = pn_ledger_id
150: AND application_id = 101
151: AND period_name = pv_period_from
152: AND period_year = pv_accounting_year;

Line 156: FROM GL_PERIOD_STATUSES

152: AND period_year = pv_accounting_year;
153:
154: SELECT end_date
155: INTO ld_end_date
156: FROM GL_PERIOD_STATUSES
157: WHERE ledger_id = pn_ledger_id
158: AND application_id = 101
159: AND period_name = pv_period_to
160: AND period_year = pv_accounting_year;

Line 205: FROM gl_period_statuses gp

201: ,Ja_Cn_Utility.GV_REQUIRED_YES
202: ,Ja_Cn_Utility.GV_MODULE_FA);
203: SELECT period_num
204: INTO lv_period_name
205: FROM gl_period_statuses gp
206: WHERE period_year = pv_accounting_year
207: AND application_id = 101
208: AND ledger_id = pn_ledger_id
209: AND gp.adjustment_period_flag = 'N'