APPS.GL_GLXCLVAL_XMLP_PKG dependencies on GL_PERIODS

Line 9: FROM gl_periods

5: dummy NUMBER;
6: begin
7: SELECT period_year, min(period_num)
8: INTO dummy, first_period_num
9: FROM gl_periods
10: WHERE
11: period_set_name = periodset
12: AND period_type = periodtype
13: AND period_year = first_period_year

Line 40: FROM gl_periods

36: max_year NUMBER;
37: begin
38: SELECT max(period_year)
39: INTO max_year
40: FROM gl_periods
41: WHERE
42: period_set_name = periodset
43: AND period_type = periodtype;
44: return(max_year);

Line 55: FROM gl_periods

51: ELSE
52: SELECT
53: max(end_date)
54: INTO date_low
55: FROM gl_periods
56: WHERE period_set_name = periodset
57: AND period_type = periodtype
58: AND period_year < P_start_year
59: ;

Line 63: FROM gl_periods

59: ;
60: IF (date_low is NULL) THEN
61: SELECT min(start_date)
62: INTO date_low
63: FROM gl_periods
64: WHERE period_set_name = periodset
65: AND period_type = periodtype
66: AND period_year = P_start_year;
67: END IF;

Line 83: FROM gl_periods

79: ELSE
80: SELECT
81: min(start_date)
82: INTO date_high
83: FROM gl_periods
84: WHERE period_set_name = periodset
85: AND period_type = periodtype
86: AND period_year > P_end_year
87: ;

Line 91: FROM gl_periods

87: ;
88: IF (date_high is NULL) THEN
89: SELECT max(end_date)
90: INTO date_high
91: FROM gl_periods
92: WHERE period_set_name = periodset
93: AND period_type = periodtype
94: AND period_year = P_end_year;
95: END IF;

Line 107: FROM gl_periods

103: first_period_year NUMBER;
104: begin
105: SELECT min(period_year)
106: INTO first_period_year
107: FROM gl_periods
108: WHERE
109: period_set_name = periodset
110: AND period_type = periodtype
111: AND start_date = to_date(first_period_date,'YYYY/MM/DD');

Line 120: FROM gl_periods p

116: begin
117: SELECT min(decode(p.period_year,
118: first_period_year, p.quarter_num, 1))
119: INTO min_quarter
120: FROM gl_periods p
121: WHERE p.period_set_name = periodset
122: AND p.period_type = periodtype
123: AND p.period_year = period_year_qg;
124: return(min_quarter);

Line 131: FROM gl_periods p

127: max_quarter NUMBER(15);
128: begin
129: SELECT max(p.quarter_num)
130: INTO max_quarter
131: FROM gl_periods p
132: WHERE p.period_set_name = periodset
133: AND p.period_type = periodtype
134: AND p.period_year = period_year_qg;
135: return(max_quarter);