DBA Data[Home] [Help]

APPS.HRI_BPL_TREND_WRKFC_ABS_SQL dependencies on HRI_BPL_TREND_WRKFC_SQL

Line 102: hri_bpl_trend_wrkfc_sql.get_sql

98: --
99: l_trend_sql_params := p_trend_sql_params;
100: l_trend_sql_params.include_hdc := 'Y';
101: l_trend_sql_params.include_hdc_trn := 'Y'; -- use trn for abs start headcount
102: hri_bpl_trend_wrkfc_sql.get_sql
103: (p_parameter_rec => p_parameter_rec,
104: p_bind_tab => p_bind_tab,
105: p_trend_sql_params => l_trend_sql_params,
106: p_date_join_type => 'PERIOD_END',

Line 141: hri_bpl_trend_wrkfc_sql.get_sql

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