APPS.CE_CASH_FCST dependencies on GL_SETS_OF_BOOKS

Line 792: sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

788: | 04-OCT-1996 Created Bidemi Carrol |
789: ---------------------------------------------------------------------*/
790: FUNCTION valid_calendar_name RETURN BOOLEAN IS
791: valid_period BOOLEAN := TRUE;
792: sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
793: calendar GL_PERIODS.period_set_name%TYPE;
794: error_msg fnd_new_messages.message_text%TYPE;
795: sob_name GL_SETS_OF_BOOKS.name%TYPE;
796:

Line 795: sob_name GL_SETS_OF_BOOKS.name%TYPE;

791: valid_period BOOLEAN := TRUE;
792: sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
793: calendar GL_PERIODS.period_set_name%TYPE;
794: error_msg fnd_new_messages.message_text%TYPE;
795: sob_name GL_SETS_OF_BOOKS.name%TYPE;
796:
797: CURSOR sob_c IS
798: SELECT gsb.period_set_name, org.set_of_books_id, org.set_of_books_name
799: FROM ce_forecast_orgs_v org,

Line 800: gl_sets_of_books gsb

796:
797: CURSOR sob_c IS
798: SELECT gsb.period_set_name, org.set_of_books_id, org.set_of_books_name
799: FROM ce_forecast_orgs_v org,
800: gl_sets_of_books gsb
801: WHERE gsb.set_of_books_id = org.set_of_books_id
802: AND org.app_short_name = G_app_short_name
803: AND org.set_of_books_id = NVL(G_set_of_books_id,org.set_of_books_id)
804: AND (org.org_id = DECODE(G_org_id, -1, org.org_id,-99, org.org_id, G_org_id)

Line 813: FROM gl_sets_of_books gsb

809:
810: IF(G_app_short_name = 'GL')THEN
811: SELECT period_set_name, set_of_books_id, name, currency_code
812: INTO calendar, sob_id, sob_name, G_sob_currency_code
813: FROM gl_sets_of_books gsb
814: WHERE gsb.set_of_books_id = G_set_of_books_id;
815:
816: IF (calendar <> G_rp_calendar_name) THEN
817: valid_period := FALSE;