APPS.HRI_OLTP_PMV_WMV_SAL_SUP dependencies on HRI_BPL_FACT_SUP_WRKFC_SQL

Line 28: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

24: /* Direct reports string */
25: l_direct_reports_string VARCHAR2(240);
26:
27: /* Dynamic SQL controls */
28: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
29: l_wrkfc_fact_sql VARCHAR2(10000);
30:
31: BEGIN
32:

Line 75: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

71: l_wrkfc_fact_params.bind_format := 'PMV';
72: l_wrkfc_fact_params.include_comp := 'Y';
73: l_wrkfc_fact_params.include_hdc := 'Y';
74: l_wrkfc_fact_params.include_sal := 'Y';
75: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
76: (p_parameter_rec => l_parameter_rec,
77: p_bind_tab => l_bind_tab,
78: p_wrkfc_params => l_wrkfc_fact_params,
79: p_calling_module => 'HRI_OLTP_PMV_WMV_SAL_SUP.GET_SQL2');

Line 211: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.WRKFC_FACT_PARAM_TYPE;

207: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
208: --
209: -- Parameter values for getting the inner SQL
210: --
211: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.WRKFC_FACT_PARAM_TYPE;
212: --
213: -- Inner SQL
214: --
215: l_inn_sql VARCHAR2(32767);