APPS.QPR_COLLECT_TIME_DATA dependencies on QPR_SR_UTIL

Line 367: l_gl_table := 'GL_PERIODS' || qpr_sr_util.get_dblink(p_instance_id);

363: build_gregorian_cal(date_from, date_to);
364: elsif p_calendar_type = FISCAL_CALENDAR then
365:
366: -- Added to resolve bug 5920571
367: l_gl_table := 'GL_PERIODS' || qpr_sr_util.get_dblink(p_instance_id);
368:
369: l_sql_check_cal := 'select count(period_set_name) from ';
370: l_sql_check_cal := l_sql_check_cal || l_gl_table;
371: l_sql_check_cal := l_sql_check_cal || ' where period_set_name = ''';

Line 399: src_table := FISCAL_TIME_SRC_TBL || qpr_sr_util.get_dblink(p_instance_id);

395: and CALENDAR_CODE = p_calendar_code
396: and day between date_from and date_to;
397: end if;
398:
399: src_table := FISCAL_TIME_SRC_TBL || qpr_sr_util.get_dblink(p_instance_id);
400:
401: s_sql := 'select CALENDAR_CODE, YEAR,YEAR_DESCRIPTION,YEAR_START_DATE, ';
402: s_sql := s_sql || 'YEAR_END_DATE,QUARTER,QUARTER_DESCRIPTION, ';
403: s_sql := s_sql || 'QUARTER_START_DATE,QUARTER_END_DATE,MONTH, ' ;