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_PS_FA_AC_EXP_PKG dependencies on GL_PERIOD_STATUSES

Line 70: gl_period_statuses fps

66: DISTINCT fps.period_name
67: , fps.start_date
68: , fps.end_date
69: FROM
70: gl_period_statuses fps
71: WHERE ledger_id = pn_ledger_id
72: AND application_id = 101
73: AND fps.start_date >= ld_start_date
74: AND fps.end_date <= ld_end_date

Line 112: gl_period_statuses

108: start_date
109: INTO
110: ld_start_date
111: FROM
112: gl_period_statuses
113: WHERE ledger_id = pn_ledger_id
114: AND application_id = 101
115: AND period_name = pv_period_from
116: AND TO_CHAR(period_year) = pv_accounting_year;

Line 129: gl_period_statuses

125: end_date
126: INTO
127: ld_end_date
128: FROM
129: gl_period_statuses
130: WHERE ledger_id = pn_ledger_id
131: AND application_id = 101
132: AND period_name = pv_period_to
133: AND TO_CHAR(period_year) = pv_accounting_year;

Line 429: gl_period_statuses

425: INTO
426: ld_start_date
427: , lv_accounting_period
428: FROM
429: gl_period_statuses
430: WHERE ledger_id = pn_ledger_id
431: AND application_id = 101
432: AND period_name = pv_period_from
433: AND TO_CHAR(period_year) = pv_accounting_year;

Line 446: gl_period_statuses

442: end_date
443: INTO
444: ld_end_date
445: FROM
446: gl_period_statuses
447: WHERE ledger_id = pn_ledger_id
448: AND application_id = 101
449: AND period_name = pv_period_to
450: AND TO_CHAR(period_year) = pv_accounting_year;