APPS.HRI_OLTP_PMV_ABS_CAT dependencies on HRI_BPL_FACT_ABS_SQL

Line 228: l_abs_fact_params hri_bpl_fact_abs_sql.abs_fact_param_type;

224: l_security_clause VARCHAR2(4000);
225: l_custom_rec BIS_QUERY_ATTRIBUTES ;
226:
227: /* Dynamic SQL Controls */
228: l_abs_fact_params hri_bpl_fact_abs_sql.abs_fact_param_type;
229: l_abs_fact_sql VARCHAR2(10000);
230: l_parameter_name VARCHAR2(100);
231: l_dynmc_drtn_curr VARCHAR2(100) DEFAULT 'curr_abs_drtn_days';
232: l_dynmc_tot_drtn_curr VARCHAR2(100) DEFAULT 'tot_abs_drtn_days_curr';

Line 284: l_abs_fact_sql := hri_bpl_fact_abs_sql.get_sql

280: l_abs_fact_params.include_abs_in_period := 'N';
281: l_abs_fact_params.include_abs_ntfctn_period := 'N';
282: l_abs_fact_params.include_comp := 'N';
283: l_abs_fact_params.kpi_mode := 'N';
284: l_abs_fact_sql := hri_bpl_fact_abs_sql.get_sql
285: (p_parameter_rec => l_parameter_rec,
286: p_bind_tab => l_bind_tab,
287: p_abs_params => l_abs_fact_params,
288: p_calling_module => 'HRI_P_ABS_CAT_TN_GRAPH');