APPS.POA_DBI_POP_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 64: '|| poa_dbi_template_pkg.status_sql(

60: l_url := 'pFunctionName=POA_DBI_POP_STATUS_RPT&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=SUPPLIER+POA_SUPPLIERS&pParamIds=Y';
61: end if;
62:
63: l_query := get_status_sel_clause(l_view_by_col, l_url) || ' from
64: '|| poa_dbi_template_pkg.status_sql(
65: l_mv,
66: l_where_clause,
67: l_join_tbl,
68: p_use_windowing => 'Y',

Line 117: '|| poa_dbi_template_pkg.trend_sql(

113:
114: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'purchase_amt', 'N',p_to_date_type => l_to_date_type);
115:
116: l_query := get_trend_sel_clause || ' from
117: '|| poa_dbi_template_pkg.trend_sql(
118: l_xtd,
119: l_comparison_type,
120: l_mv,
121: l_where_clause,

Line 234: ' || poa_dbi_template_pkg.status_sql(

230: p_purchase_amt POA_MEASURE5,
231: nvl(c_purchase_amt_total,0) POA_MEASURE6,
232: p_purchase_amt_total POA_MEASURE7
233: from
234: ' || poa_dbi_template_pkg.status_sql(
235: l_mv,
236: l_where_clause,
237: l_join_tbl,
238: p_use_windowing => 'N',