APPS.POA_DBI_UPR_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 115: poa_dbi_template_pkg.status_sql(

111: end if;
112:
113:
114: l_query := get_status_sel_clause(l_view_by, l_view_by_col) || ' from '||
115: poa_dbi_template_pkg.status_sql(
116: l_mv,
117: l_where_clause,
118: l_join_tbl,
119: p_use_windowing => 'P',

Line 367: poa_dbi_template_pkg.status_sql(

363:
364: l_query := get_amt_sel_clause(l_view_by
365: ,l_view_by_col
366: ,l_bucket_rec) || ' from ' ||
367: poa_dbi_template_pkg.status_sql(
368: l_mv,
369: l_where_clause,
370: l_join_tbl,
371: p_use_windowing => 'P',

Line 671: poa_dbi_template_pkg.status_sql(

667: end if;
668: l_query := get_age_sel_clause(l_view_by
669: ,l_view_by_col
670: ,l_bucket_rec) || ' from ' ||
671: poa_dbi_template_pkg.status_sql(
672: l_mv,
673: l_where_clause,
674: l_join_tbl,
675: p_use_windowing => 'P',

Line 969: poa_dbi_template_pkg.status_sql(

965: , p_to_date_type => 'NA');
966:
967: end if;
968: l_query := get_sum_sel_clause(l_view_by, l_view_by_col) || ' from '||
969: poa_dbi_template_pkg.status_sql(
970: l_mv,
971: l_where_clause,
972: l_join_tbl,
973: p_use_windowing => 'P',