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

Line 72: gl_period_statuses fps

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

Line 113: FROM gl_period_statuses

109: IF (pv_period_from IS NOT NULL)
110: THEN
111: SELECT start_date
112: INTO ld_start_date
113: FROM gl_period_statuses
114: WHERE ledger_id = pn_ledger_id
115: AND application_id = 101
116: AND period_name = pv_period_from
117: AND to_char(period_year) = pv_accounting_year;

Line 126: FROM gl_period_statuses

122: IF (pv_period_to IS NOT NULL)
123: THEN
124: SELECT end_date
125: INTO ld_end_date
126: FROM gl_period_statuses
127: WHERE ledger_id = pn_ledger_id
128: AND application_id = 101
129: AND period_name = pv_period_to
130: AND to_char(period_year) = pv_accounting_year;

Line 443: gl_period_statuses

439: INTO
440: ld_start_date
441: , lv_period_name
442: FROM
443: gl_period_statuses
444: WHERE ledger_id = pn_ledger_id
445: AND application_id = 101
446: AND period_name = pv_period_from
447: AND to_char(period_year) = pv_accounting_year;

Line 459: gl_period_statuses

455: end_date
456: INTO
457: ld_end_date
458: FROM
459: gl_period_statuses
460: WHERE ledger_id = pn_ledger_id
461: AND application_id = 101
462: AND period_name = pv_period_to
463: AND to_char(period_year) = pv_accounting_year;