APPS.FII_TIME_M_C dependencies on GL_SETS_OF_BOOKS

Line 149: gl_sets_of_books book

145: per.period_type,
146: min(start_date),
147: max(end_date)
148: From gl_periods per,
149: gl_sets_of_books book
150: where per.ADJUSTMENT_PERIOD_FLAG = 'N'
151: and per.period_set_name = book.period_set_name
152: and per.period_type = book.accounted_period_type
153: and per.end_date >= NVL(p_from_date, per.end_date)

Line 165: gl_sets_of_books book

161: per.period_type,
162: min(start_date),
163: max(end_date)
164: From gl_periods per,
165: gl_sets_of_books book
166: where
167: per.period_set_name = book.period_set_name
168: and per.period_type = book.accounted_period_type
169: Group By per.period_set_name,

Line 185: gl_sets_of_books sob,

181: paprd.gl_period_name,
182: (glprd.period_year * 10000) + glprd.period_num
183: from gl_date_period_map map,
184: pa_implementations_all imp,
185: gl_sets_of_books sob,
186: pa_periods_all paprd,
187: gl_periods glprd
188: where imp.set_of_books_id = sob.set_of_books_id
189: and paprd.org_id = imp.org_id

Line 210: gl_sets_of_books sob,

206: paprd.gl_period_name,
207: imp.pa_period_type,
208: (glprd.period_year * 10000) + glprd.period_num
209: from pa_implementations_all imp,
210: gl_sets_of_books sob,
211: pa_periods_all paprd,
212: gl_periods glprd
213: where imp.set_of_books_id = sob.set_of_books_id
214: and paprd.org_id = imp.org_id

Line 234: gl_sets_of_books book

230: per.start_date,
231: per.end_date,
232: (per.period_year * 10000) + per.period_num
233: from gl_periods per,
234: gl_sets_of_books book
235: where per.adjustment_period_flag = 'N'
236: and per.period_set_name = book.period_set_name
237: and per.period_type = book.accounted_period_type;
238:

Line 249: gl_sets_of_books book

245: per.quarter_num,
246: min(per.start_date),
247: max(per.end_date)
248: from gl_periods per,
249: gl_sets_of_books book
250: where per.period_set_name = book.period_set_name
251: and per.period_type = book.accounted_period_type
252: group by per.period_set_name,
253: per.period_type,

Line 266: gl_sets_of_books book

262: period_year,
263: min(start_date),
264: max(end_date)
265: from gl_periods per,
266: gl_sets_of_books book
267: where per.period_set_name = book.period_set_name
268: and per.period_type = book.accounted_period_type
269: group by per.period_set_name,
270: per.period_type,

Line 1131: from gl_sets_of_books sob,

1127: sob.period_set_name, --name
1128: sysdate, --end_date
1129: 1, --timespan
1130: 'READY' --collection_status
1131: from gl_sets_of_books sob,
1132: gl_period_sets sets
1133: where sob.period_set_name = sets.period_set_name;
1134:
1135: l_row_name:=l_row_name+sql%rowcount;