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.BIV_DBI_COLLECTION_AGE dependencies on FII_TIME_API

Line 179: when id = 11 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date)

175: from fii_time_day fii
176: , (select
177: id
178: , case
179: when id = 11 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date)
180: when id = 6 then (trunc(l_collect_to_date))
181: else l_collect_to_date
182: end the_date
183: from oki_dbi_multiplexer_b

Line 203: when id = 12 then FII_TIME_API.sd_lyswk(l_collect_to_date)

199: from fii_time_week fii
200: , (select
201: id
202: , case
203: when id = 12 then FII_TIME_API.sd_lyswk(l_collect_to_date)
204: when id = 7 then FII_TIME_API.sd_pwk(l_collect_to_date)
205: else l_collect_to_date
206: end the_date
207: from oki_dbi_multiplexer_b

Line 204: when id = 7 then FII_TIME_API.sd_pwk(l_collect_to_date)

200: , (select
201: id
202: , case
203: when id = 12 then FII_TIME_API.sd_lyswk(l_collect_to_date)
204: when id = 7 then FII_TIME_API.sd_pwk(l_collect_to_date)
205: else l_collect_to_date
206: end the_date
207: from oki_dbi_multiplexer_b
208: where id in (2,7,12)

Line 227: when id = 13 then FII_TIME_API.ent_sd_lysper_end(l_collect_to_date)

223: from fii_time_ent_period fii
224: , (select
225: id
226: , case
227: when id = 13 then FII_TIME_API.ent_sd_lysper_end(l_collect_to_date)
228: when id = 8 then FII_TIME_API.ent_sd_pper_end(l_collect_to_date)
229: else l_collect_to_date
230: end the_date
231: from oki_dbi_multiplexer_b

Line 228: when id = 8 then FII_TIME_API.ent_sd_pper_end(l_collect_to_date)

224: , (select
225: id
226: , case
227: when id = 13 then FII_TIME_API.ent_sd_lysper_end(l_collect_to_date)
228: when id = 8 then FII_TIME_API.ent_sd_pper_end(l_collect_to_date)
229: else l_collect_to_date
230: end the_date
231: from oki_dbi_multiplexer_b
232: where id in (3,8,13)

Line 251: when id = 14 then FII_TIME_API.ent_sd_lysqtr_end(l_collect_to_date)

247: from fii_time_ent_qtr fii
248: , (select
249: id
250: , case
251: when id = 14 then FII_TIME_API.ent_sd_lysqtr_end(l_collect_to_date)
252: when id = 9 then FII_TIME_API.ent_sd_pqtr_end (l_collect_to_date)
253: else l_collect_to_date
254: end the_date
255: from oki_dbi_multiplexer_b

Line 252: when id = 9 then FII_TIME_API.ent_sd_pqtr_end (l_collect_to_date)

248: , (select
249: id
250: , case
251: when id = 14 then FII_TIME_API.ent_sd_lysqtr_end(l_collect_to_date)
252: when id = 9 then FII_TIME_API.ent_sd_pqtr_end (l_collect_to_date)
253: else l_collect_to_date
254: end the_date
255: from oki_dbi_multiplexer_b
256: where id in (4,9,14)

Line 275: when id = 15 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date)

271: from fii_time_ent_year fii
272: , (select
273: id
274: , case
275: when id = 15 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date)
276: when id = 10 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date)
277: else l_collect_to_date
278: end the_date
279: from oki_dbi_multiplexer_b

Line 276: when id = 10 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date)

272: , (select
273: id
274: , case
275: when id = 15 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date)
276: when id = 10 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date)
277: else l_collect_to_date
278: end the_date
279: from oki_dbi_multiplexer_b
280: where id in (5,10,15)