APPS.HRI_OLTP_PMV_ABS_WMV_PVT dependencies on HRI_BPL_FACT_SUP_WRKFC_SQL

Line 25: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

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);
28: l_dynsql_order_by VARCHAR2(100);
29:

Line 166: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

162: l_wrkfc_fact_params.include_sal := 'N';
163: l_wrkfc_fact_params.include_low := 'N';
164: l_wrkfc_fact_params.include_comp := 'N';
165: l_wrkfc_fact_params.kpi_mode := 'N';
166: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
167: (p_parameter_rec => l_parameter_rec,
168: p_bind_tab => l_bind_tab,
169: p_wrkfc_params => l_wrkfc_fact_params,
170: p_calling_module => 'HRI_P_ABS_WMV_PVT');

Line 371: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

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);
374: l_dynsql_order_by VARCHAR2(100);
375:

Line 457: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

453: l_wrkfc_fact_params.include_sal := 'N';
454: l_wrkfc_fact_params.include_low := 'N';
455: l_wrkfc_fact_params.include_comp := 'Y';
456: l_wrkfc_fact_params.kpi_mode := 'Y';
457: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
458: (p_parameter_rec => l_parameter_rec,
459: p_bind_tab => l_bind_tab,
460: p_wrkfc_params => l_wrkfc_fact_params,
461: p_calling_module => 'HRI_K_ABS_WMV');