APPS.ISC_FS_TASK_BAC_AGE_ETL_PKG dependencies on OKI_DBI_MULTIPLEXER_B

Line 280: from oki_dbi_multiplexer_b

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)
282: ) m
283: where fii.start_date < m.the_date
284: )

Line 312: from oki_dbi_multiplexer_b

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)
314: ) m
315: where fii.start_date < m.the_date
316: )

Line 344: from oki_dbi_multiplexer_b

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)
346: ) m
347: where fii.start_date < m.the_date
348: )

Line 376: from oki_dbi_multiplexer_b

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)
378: ) m
379: where fii.start_date < m.the_date
380: )

Line 405: from oki_dbi_multiplexer_b

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
406: where id in (13,14,15)
407: ) m
408: where fii.report_date < m.the_date
409: )