APPS.ISC_FS_INV_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 237: l_stmt := poa_dbi_template_pkg.union_all_status_sql

233: l_mv_tbl(2).mv_where := l_where_clause;
234: l_mv_tbl(2).in_join_tbls := NULL;
235: l_mv_tbl(2).use_grp_id := 'N';
236:
237: l_stmt := poa_dbi_template_pkg.union_all_status_sql
238: (p_mv => l_mv_tbl
239: ,p_join_tables => l_join_tbl
240: ,p_use_windowing => 'Y'
241: ,p_paren_count => 3

Line 624: l_stmt := poa_dbi_template_pkg.union_all_trend_sql(

620: l_mv_tbl(l_mv_tbl.count).use_grp_id := 'N';
621: l_mv_tbl(l_mv_tbl.count).mv_xtd := l_xtd; /* This determines what calendar tables to use and what FII struct table to use. For XTD is the FII_TIME_ENT tables and
622: fii_time_rpt_struct_v. If rolling, it will use the Rolling calendars inline views for week, month, quarter, year and fii_time_structures */
623:
624: l_stmt := poa_dbi_template_pkg.union_all_trend_sql(
625: p_mv => l_mv_tbl,
626: p_comparison_type => l_comparison_type,
627: p_filter_where => NULL
628: );