APPS.OKI_DBI_NSCM_TRM_PVT dependencies on POA_DBI_TEMPLATE_PKG

Line 88: || POA_DBI_TEMPLATE_PKG.Status_Sql (

84:
85: -- Generate sql query
86: l_query := Get_Terminations_Sel_Clause(l_view_by, l_view_by_col)
87: || ' from '
88: || POA_DBI_TEMPLATE_PKG.Status_Sql (
89: p_fact_name => l_mv,
90: p_where_clause => l_where_clause,
91: p_filter_where => l_filter_where,
92: p_join_tables => l_join_tbl,

Line 375: || poa_dbi_template_pkg.dtl_status_sql2 (

371: l_filter_where := ' ( abs(OKI_MEASURE_3) + abs(OKI_MEASURE_2) ) <> 0 ';
372:
373:
374: l_query := Get_Trm_Dtl_Sel_Clause(l_curr_suffix, l_period_type)
375: || poa_dbi_template_pkg.dtl_status_sql2 (
376: p_fact_name => l_mv
377: , p_where_clause => l_where_clause || l_rpt_specific_where
378: , p_join_tables => l_join_tbl
379: , p_use_windowing => 'Y'

Line 458: ||POA_DBI_TEMPLATE_PKG.Trend_Sql(

454: p_grand_total => 'N',
455: p_to_date_type => 'XTD');
456:
457: l_query := Get_Trm_Trend_Sel_Clause||' FROM '
458: ||POA_DBI_TEMPLATE_PKG.Trend_Sql(
459: p_xtd => l_xtd,
460: p_comparison_type => l_comparison_type,
461: p_fact_name => l_mv,
462: p_where_clause => l_where_clause,