19: l_security_clause VARCHAR2(4000);
20: l_custom_rec BIS_QUERY_ATTRIBUTES ;
21:
22: /* Dynamic SQL Controls */
23: l_abs_fact_params hri_bpl_fact_abs_sql.abs_fact_param_type;
24: l_abs_fact_sql VARCHAR2(10000);
25: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
26: l_wrkfc_fact_sql VARCHAR2(10000);
27: l_direct_reports_string VARCHAR2(100);
148: l_abs_fact_params.include_abs_in_period := 'Y';
149: l_abs_fact_params.include_abs_ntfctn_period := 'Y';
150: l_abs_fact_params.include_comp := 'Y';
151: l_abs_fact_params.kpi_mode := 'N';
152: l_abs_fact_sql := hri_bpl_fact_abs_sql.get_sql
153: (p_parameter_rec => l_parameter_rec,
154: p_bind_tab => l_bind_tab,
155: p_abs_params => l_abs_fact_params,
156: p_calling_module => 'HRI_P_ABS_WMV_PVT');
365: l_security_clause VARCHAR2(4000);
366: l_custom_rec BIS_QUERY_ATTRIBUTES ;
367:
368: /* Dynamic SQL Controls */
369: l_abs_fact_params hri_bpl_fact_abs_sql.abs_fact_param_type;
370: l_abs_fact_sql VARCHAR2(10000);
371: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
372: l_wrkfc_fact_sql VARCHAR2(10000);
373: l_direct_reports_string VARCHAR2(100);
439: l_abs_fact_params.include_abs_in_period := 'Y';
440: l_abs_fact_params.include_abs_ntfctn_period := 'Y';
441: l_abs_fact_params.include_comp := 'Y';
442: l_abs_fact_params.kpi_mode := 'Y';
443: l_abs_fact_sql := hri_bpl_fact_abs_sql.get_sql
444: (p_parameter_rec => l_parameter_rec,
445: p_bind_tab => l_bind_tab,
446: p_abs_params => l_abs_fact_params,
447: p_calling_module => 'HRI_K_ABS_WMV');