DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_TRN_SUMMRY dependencies on HRI_BPL_FACT_SUP_WRKFC_SQL

Line 158: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

154:
155: -- new code centralization new variables/structures
156: l_wcnt_chg_fact_sql VARCHAR2(32767);
157: l_wrkfc_fact_sql VARCHAR2(32767);
158: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
159: l_wcnt_chg_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
160:
161: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
162: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

Line 232: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

228: l_wrkfc_params.include_comp := 'Y';
229: IF (fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') THEN
230: l_wrkfc_params.include_start := 'Y';
231: END IF;
232: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
233: (p_parameter_rec => l_parameter_rec,
234: p_bind_tab => l_bind_tab,
235: p_wrkfc_params => l_wrkfc_params);
236: