APPS.ISC_MAINT_REQ_CMPL_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 466: poa_dbi_template_pkg.status_sql

462: , null BIV_ATTRIBUTE1, '
463: end || isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl)||' from ';
464:
465: l_stmt := l_stmt || l_inner_query ||
466: poa_dbi_template_pkg.status_sql
467: ( p_fact_name => l_mv
468: , p_where_clause => l_where_clause
469: , p_join_tables => l_join_tbl
470: , p_use_windowing => 'Y'

Line 625: ' || poa_dbi_template_pkg.trend_sql

621: , 'N' )
622: , 'BIV_MEASURE9' -- change completion days (as float)
623: , 'N' ) || '
624: from
625: ' || poa_dbi_template_pkg.trend_sql
626: ( p_xtd => l_xtd
627: , p_comparison_type => l_comparison_type
628: , p_fact_name => l_mv
629: , p_where_clause => l_where_clause

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

757: ''&pParamIds=Y'' BIV_ATTRIBUTE1
758: , null BIV_ATTRIBUTE2' -- this is needed for bucket to region association
759: || '
760: from
761: ( select * from ( ' || poa_dbi_template_pkg.status_sql
762: ( p_fact_name => l_mv
763: , p_where_clause => l_where_clause
764: , p_join_tables => l_join_tbl
765: , p_use_windowing => 'N'