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_BI_EXP_PKG dependencies on FA_DEPRN_PERIODS

Line 94: fa_deprn_periods fdp

90: (
91: SELECT
92: fdp.period_close_date
93: FROM
94: fa_deprn_periods fdp
95: WHERE fdp.book_type_code = fbcs.book_type_code
96: AND fdp.calendar_period_close_date
97: BETWEEN pd_start_date AND pd_end_date
98: AND fdp.period_close_date IS NOT NULL

Line 102: FROM fa_deprn_periods fdp

98: AND fdp.period_close_date IS NOT NULL
99: )
100: AND fdh.date_effective <
101: nvl((SELECT MAX(fdp.period_close_date)
102: FROM fa_deprn_periods fdp
103: WHERE fdp.book_type_code = fbcs.book_type_code
104: AND fdp.calendar_period_close_date <= pd_end_date
105: AND fdp.period_close_date IS NOT NULL),
106: SYSDATE)

Line 110: FROM fa_deprn_periods fdp

106: SYSDATE)
107: AND (
108: fdh.date_ineffective >
109: nvl((SELECT MAX(fdp.period_close_date)
110: FROM fa_deprn_periods fdp
111: WHERE fdp.book_type_code = fbcs.book_type_code
112: AND fdp.calendar_period_close_date <= pd_end_date
113: AND fdp.period_close_date IS NOT NULL),
114: SYSDATE) OR fdh.date_ineffective IS NULL