APPS.XTR_CASH_FCST dependencies on GL_SETS_OF_BOOKS

Line 325: sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

321: | 04-OCT-1996 Created Bidemi Carrol |
322: ---------------------------------------------------------------------*/
323: FUNCTION valid_calendar_name RETURN BOOLEAN IS
324: valid_period BOOLEAN := TRUE;
325: sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
326: calendar GL_PERIODS.period_set_name%TYPE;
327: error_msg fnd_new_messages.message_text%TYPE;
328: sob_name GL_SETS_OF_BOOKS.name%TYPE;
329:

Line 328: sob_name GL_SETS_OF_BOOKS.name%TYPE;

324: valid_period BOOLEAN := TRUE;
325: sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
326: calendar GL_PERIODS.period_set_name%TYPE;
327: error_msg fnd_new_messages.message_text%TYPE;
328: sob_name GL_SETS_OF_BOOKS.name%TYPE;
329:
330: CURSOR sob_c IS
331: SELECT gsb.period_set_name, org.set_of_books_id, org.set_of_books_name
332: FROM ce_forecast_orgs_v org,

Line 333: gl_sets_of_books gsb

329:
330: CURSOR sob_c IS
331: SELECT gsb.period_set_name, org.set_of_books_id, org.set_of_books_name
332: FROM ce_forecast_orgs_v org,
333: gl_sets_of_books gsb
334: WHERE gsb.set_of_books_id = org.set_of_books_id
335: AND org.app_short_name = G_app_short_name
336: AND org.set_of_books_id = NVL(G_set_of_books_id,org.set_of_books_id)
337: AND (org.org_id = DECODE(G_org_id, -1, org.org_id,-99, org.org_id, G_org_id)

Line 348: FROM gl_sets_of_books gsb

344:
345: IF(G_app_short_name = 'GL')THEN
346: SELECT period_set_name, set_of_books_id, name, currency_code
347: INTO calendar, sob_id, sob_name, G_sob_currency_code
348: FROM gl_sets_of_books gsb
349: WHERE gsb.set_of_books_id = G_set_of_books_id;
350:
351: IF (calendar <> G_rp_calendar_name) THEN
352: valid_period := FALSE;