APPS.ISC_MAINT_WO_CMPL_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 493: l_stmt := l_stmt || l_inner_query || poa_dbi_template_pkg.status_sql

489: , 'N' ) || ' , ' ||
490: isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl)||' from ';
491:
492:
493: l_stmt := l_stmt || l_inner_query || poa_dbi_template_pkg.status_sql
494: ( p_fact_name => l_mv
495: , p_where_clause => l_where_clause
496: , p_join_tables => l_join_tbl
497: , p_use_windowing => 'Y'

Line 678: ' || poa_dbi_template_pkg.trend_sql

674: , 'iset.c_num_late_completion'
675: , 'BIV_MEASURE12'
676: , 'N' ) || ' /* Average Days Late */
677: from
678: ' || poa_dbi_template_pkg.trend_sql
679: ( p_xtd => l_xtd
680: , p_comparison_type => l_comparison_type
681: , p_fact_name => l_mv
682: , p_where_clause => l_where_clause

Line 821: ( select * from ( ' || poa_dbi_template_pkg.status_sql

817: , 'Y' ) || '
818: /* Grand Total Percent of Total */
819: , null BIV_ATTRIBUTE10
820: from
821: ( select * from ( ' || poa_dbi_template_pkg.status_sql
822: ( p_fact_name => l_mv
823: , p_where_clause => l_where_clause
824: , p_join_tables => l_join_tbl
825: , p_use_windowing => 'N'