APPS.BIL_BI_UTIL_PKG dependencies on BIS_REFRESH_LOG

Line 546: from bis_refresh_log

542: BEGIN
543: --if yesterday falls in the same period, execute the query
544: IF (l_start_date <= l_yesterday) THEN
545: select trunc(max(period_to)) into x_snapshot_date
546: from bis_refresh_log
547: where object_name = 'BIL_BI_PIPELINE_F'
548: and status = 'SUCCESS'
549: and period_to <= l_as_of_date
550: and period_to >= l_check_date;

Line 2175: FROM bis_refresh_log a

2171:
2172:
2173: SELECT to_date(attribute1, 'dd/mm/yyyy'), MAX(to_date(attribute2, 'dd/mm/yyyy'))
2174: INTO l_coll_st_date,l_coll_end_date
2175: FROM bis_refresh_log a
2176: WHERE
2177: a.last_update_date = (
2178: SELECT MAX(b.last_update_date) FROM bis_refresh_log b
2179: WHERE b.object_name = 'BIL_BI_PIPEC_F'

Line 2178: SELECT MAX(b.last_update_date) FROM bis_refresh_log b

2174: INTO l_coll_st_date,l_coll_end_date
2175: FROM bis_refresh_log a
2176: WHERE
2177: a.last_update_date = (
2178: SELECT MAX(b.last_update_date) FROM bis_refresh_log b
2179: WHERE b.object_name = 'BIL_BI_PIPEC_F'
2180: AND status = 'SUCCESS'
2181: )
2182: AND a.object_name = 'BIL_BI_PIPEC_F'

Line 2535: FROM bis_refresh_log a

2531: l_as_of_date:= trunc(p_as_of_date);
2532:
2533: SELECT to_date(attribute1, 'dd/mm/yyyy'), MAX(to_date(attribute2, 'dd/mm/yyyy'))
2534: INTO l_coll_st_date,l_coll_end_date
2535: FROM bis_refresh_log a
2536: WHERE
2537: a.last_update_date = (
2538: SELECT MAX(b.last_update_date) FROM bis_refresh_log b
2539: WHERE b.object_name = 'BIL_BI_PIPEC_F'

Line 2538: SELECT MAX(b.last_update_date) FROM bis_refresh_log b

2534: INTO l_coll_st_date,l_coll_end_date
2535: FROM bis_refresh_log a
2536: WHERE
2537: a.last_update_date = (
2538: SELECT MAX(b.last_update_date) FROM bis_refresh_log b
2539: WHERE b.object_name = 'BIL_BI_PIPEC_F'
2540: AND status = 'SUCCESS'
2541: )
2542: AND a.object_name = 'BIL_BI_PIPEC_F'