APPS.ISC_FS_TECH_UTL_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 180: l_stmt := poa_dbi_template_pkg.union_all_status_sql

176: l_mv_tbl(2).mv_where := replace(l_where_clause, '&' || isc_fs_rpt_util_pkg.G_TASK_TYPE, '-999');
177: l_mv_tbl(2).in_join_tbls := NULL;
178: l_mv_tbl(2).use_grp_id := 'N';
179:
180: l_stmt := poa_dbi_template_pkg.union_all_status_sql
181: (p_mv => l_mv_tbl
182: ,p_join_tables => l_join_tbl
183: ,p_use_windowing => 'Y'
184: ,p_paren_count => 3

Line 529: l_stmt := poa_dbi_template_pkg.union_all_trend_sql(

525: l_mv_tbl(2).in_join_tbls := NULL;
526: l_mv_tbl(2).use_grp_id := 'N';
527: l_mv_tbl(2).mv_xtd := l_xtd;
528:
529: l_stmt := poa_dbi_template_pkg.union_all_trend_sql(
530: p_mv => l_mv_tbl,
531: p_comparison_type => l_comparison_type,
532: p_filter_where => NULL
533: );