APPS.BIX_UTIL_PKG dependencies on GL_PERIODS

Line 399: FROM gl_periods a, gl_periods b

395: a.start_date
396: INTO p_period_start_date,
397: l_prev_end_date,
398: l_curr_start_date
399: FROM gl_periods a, gl_periods b
400: WHERE a.period_set_name = p_period_set_name
401: AND a.period_type = p_period_type
402: AND a.adjustment_period_flag = 'N'
403: AND trunc(p_date) between a.start_date and a.end_date

Line 435: FROM gl_periods

431: BEGIN
432:
433: SELECT start_date
434: INTO p_period_start_date
435: FROM gl_periods
436: WHERE period_set_name = p_period_set_name
437: AND period_type = p_period_type
438: AND adjustment_period_flag = 'N'
439: AND trunc(p_date) between start_date and end_date;

Line 778: FROM gl_periods

774: LOOP
775:
776: SELECT start_date
777: INTO l_start_date
778: FROM gl_periods
779: WHERE upper(period_set_name) = upper(l_rpt_calendar)
780: AND upper(period_type) = upper(l_period_type)
781: AND adjustment_period_flag = 'N'
782: AND l_ctl_date BETWEEN start_date and end_date;

Line 855: FROM gl_periods

851: ELSIF upper(p_period) = 'MONTH'
852: THEN
853: SELECT to_char(start_date,'MON') ||'-'|| period_year
854: INTO l_group_by
855: FROM gl_periods
856: WHERE upper(period_set_name) = upper(l_rpt_calendar)
857: AND upper(period_type) = upper(p_period)
858: AND adjustment_period_flag = 'N'
859: AND p_end_date BETWEEN start_date and end_date;

Line 864: FROM gl_periods

860: ELSIF upper(p_period) = 'QUARTER'
861: THEN
862: SELECT period_year || '-Q' || period_num
863: INTO l_group_by
864: FROM gl_periods
865: WHERE upper(period_set_name) = upper(l_rpt_calendar)
866: AND upper(period_type) = upper(p_period)
867: AND adjustment_period_flag = 'N'
868: AND p_end_date BETWEEN start_date and end_date;