APPS.HRI_OLTP_PMV_WMV_WF_SUP dependencies on HRI_BPL_FACT_SUP_WCNT_CHG_SQL

Line 143: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;

139:
140: /* Dynamic SQL controls */
141: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
142: l_wrkfc_fact_sql VARCHAR2(10000);
143: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
144: l_wcnt_chg_fact_sql VARCHAR2(10000);
145:
146: BEGIN
147:

Line 280: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql

276: l_wcnt_chg_fact_params.include_trin := 'Y';
277: l_wcnt_chg_fact_params.include_trout := 'Y';
278: l_wcnt_chg_fact_params.include_term := 'Y';
279: l_wcnt_chg_fact_params.bucket_dim := 'HRI_PRSNTYP+HRI_WKTH_WKTYP';
280: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
281: (p_parameter_rec => l_parameter_rec,
282: p_bind_tab => l_bind_tab,
283: p_wcnt_chg_params => l_wcnt_chg_fact_params,
284: p_calling_module => 'HRI_OLTP_PMV_WMV_WF_SUP.GET_SQL');