APPS.BIL_BI_UTIL_PKG dependencies on BIL_BI_RPT_TMP1

Line 2557: SELECT MIN(date2) INTO l_tmp_date FROM bil_bi_rpt_tmp1;

2553:
2554:
2555: IF p_trend_type = 'P' THEN
2556:
2557: SELECT MIN(date2) INTO l_tmp_date FROM bil_bi_rpt_tmp1;
2558:
2559: IF (l_tmp_date >= l_coll_st_date) THEN
2560: l_pipe_mv := 'BIL_BI_PIPEC_G_MV';
2561: END IF;

Line 2568: SELECT MIN(date2) INTO l_tmp_date FROM bil_bi_rpt_tmp1;

2564:
2565: /*
2566: IF p_trend_type = 'P' THEN
2567:
2568: SELECT MIN(date2) INTO l_tmp_date FROM bil_bi_rpt_tmp1;
2569:
2570: IF (l_tmp_date >= l_coll_st_date) THEN
2571: l_pipe_mv := 'BIL_BI_PIPEC_G_MV';
2572: ELSE