APPS.ISC_FS_TASK_BAC_AGE_ETL_PKG dependencies on FII_TIME_API

Line 276: when id = 9 then FII_TIME_API.sd_lyswk(l_collect_to_date_trunc)+86399/86400

272: from fii_time_week fii
273: , (select
274: id
275: , case
276: when id = 9 then FII_TIME_API.sd_lyswk(l_collect_to_date_trunc)+86399/86400
277: when id = 5 then FII_TIME_API.sd_pwk(l_collect_to_date_trunc)+86399/86400
278: else l_collect_to_date
279: end the_date
280: from oki_dbi_multiplexer_b

Line 277: when id = 5 then FII_TIME_API.sd_pwk(l_collect_to_date_trunc)+86399/86400

273: , (select
274: id
275: , case
276: when id = 9 then FII_TIME_API.sd_lyswk(l_collect_to_date_trunc)+86399/86400
277: when id = 5 then FII_TIME_API.sd_pwk(l_collect_to_date_trunc)+86399/86400
278: else l_collect_to_date
279: end the_date
280: from oki_dbi_multiplexer_b
281: where id in (1,5,9)

Line 308: when id = 10 then FII_TIME_API.ent_sd_lysper_end(l_collect_to_date_trunc)+86399/86400

304: from fii_time_ent_period fii
305: , (select
306: id
307: , case
308: when id = 10 then FII_TIME_API.ent_sd_lysper_end(l_collect_to_date_trunc)+86399/86400
309: when id = 6 then FII_TIME_API.ent_sd_pper_end(l_collect_to_date_trunc)+86399/86400
310: else l_collect_to_date
311: end the_date
312: from oki_dbi_multiplexer_b

Line 309: when id = 6 then FII_TIME_API.ent_sd_pper_end(l_collect_to_date_trunc)+86399/86400

305: , (select
306: id
307: , case
308: when id = 10 then FII_TIME_API.ent_sd_lysper_end(l_collect_to_date_trunc)+86399/86400
309: when id = 6 then FII_TIME_API.ent_sd_pper_end(l_collect_to_date_trunc)+86399/86400
310: else l_collect_to_date
311: end the_date
312: from oki_dbi_multiplexer_b
313: where id in (2,6,10)

Line 340: when id = 11 then FII_TIME_API.ent_sd_lysqtr_end(l_collect_to_date_trunc)+86399/86400

336: from fii_time_ent_qtr fii
337: , (select
338: id
339: , case
340: when id = 11 then FII_TIME_API.ent_sd_lysqtr_end(l_collect_to_date_trunc)+86399/86400
341: when id = 7 then FII_TIME_API.ent_sd_pqtr_end (l_collect_to_date_trunc)+86399/86400
342: else l_collect_to_date
343: end the_date
344: from oki_dbi_multiplexer_b

Line 341: when id = 7 then FII_TIME_API.ent_sd_pqtr_end (l_collect_to_date_trunc)+86399/86400

337: , (select
338: id
339: , case
340: when id = 11 then FII_TIME_API.ent_sd_lysqtr_end(l_collect_to_date_trunc)+86399/86400
341: when id = 7 then FII_TIME_API.ent_sd_pqtr_end (l_collect_to_date_trunc)+86399/86400
342: else l_collect_to_date
343: end the_date
344: from oki_dbi_multiplexer_b
345: where id in (3,7,11)

Line 372: when id = 12 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date_trunc)+86399/86400

368: from fii_time_ent_year fii
369: , (select
370: id
371: , case
372: when id = 12 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date_trunc)+86399/86400
373: when id = 8 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date_trunc)+86399/86400
374: else l_collect_to_date
375: end the_date
376: from oki_dbi_multiplexer_b

Line 373: when id = 8 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date_trunc)+86399/86400

369: , (select
370: id
371: , case
372: when id = 12 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date_trunc)+86399/86400
373: when id = 8 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date_trunc)+86399/86400
374: else l_collect_to_date
375: end the_date
376: from oki_dbi_multiplexer_b
377: where id in (4,8,12)

Line 401: when id = 15 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date_trunc)+86399/86400

397: from fii_time_day fii
398: , (select
399: id
400: , case
401: when id = 15 then FII_TIME_API.ent_sd_lyr_end(l_collect_to_date_trunc)+86399/86400
402: when id = 14 then (l_collect_to_date_trunc - 1)+86399/86400
403: else l_collect_to_date
404: end the_date
405: from oki_dbi_multiplexer_b