APPS.HRI_BPL_TREND_TRN_SQL dependencies on HRI_BPL_TREND_WRKFC_SQL

Line 100: hri_bpl_trend_wrkfc_sql.get_sql

96: -- turnover calculation
97: --
98: l_trend_sql_params := p_trend_sql_params;
99: l_trend_sql_params.include_hdc_trn := 'Y';
100: hri_bpl_trend_wrkfc_sql.get_sql
101: (p_parameter_rec => p_parameter_rec,
102: p_bind_tab => p_bind_tab,
103: p_trend_sql_params => l_trend_sql_params,
104: p_date_join_type => 'PERIOD_END',

Line 138: hri_bpl_trend_wrkfc_sql.get_sql

134: -- SQL returned needs to join to workforce fact twice to get the
135: -- headcount at start and end of each period
136:
137: /* Get the SQL for headcount at period start */
138: hri_bpl_trend_wrkfc_sql.get_sql
139: (p_parameter_rec => p_parameter_rec,
140: p_bind_tab => p_bind_tab,
141: p_trend_sql_params => p_trend_sql_params,
142: p_date_join_type => 'PERIOD_START',