APPS.CE_CASH_FCST dependencies on GL_SETS_OF_BOOKS

Line 806: sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

802: | 04-OCT-1996 Created Bidemi Carrol |
803: ---------------------------------------------------------------------*/
804: FUNCTION valid_calendar_name RETURN BOOLEAN IS
805: valid_period BOOLEAN := TRUE;
806: sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
807: calendar GL_PERIODS.period_set_name%TYPE;
808: error_msg fnd_new_messages.message_text%TYPE;
809: sob_name GL_SETS_OF_BOOKS.name%TYPE;
810:

Line 809: sob_name GL_SETS_OF_BOOKS.name%TYPE;

805: valid_period BOOLEAN := TRUE;
806: sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
807: calendar GL_PERIODS.period_set_name%TYPE;
808: error_msg fnd_new_messages.message_text%TYPE;
809: sob_name GL_SETS_OF_BOOKS.name%TYPE;
810:
811: CURSOR sob_c IS
812: SELECT gsb.period_set_name, org.set_of_books_id, org.set_of_books_name
813: FROM ce_forecast_orgs_v org,

Line 814: gl_sets_of_books gsb

810:
811: CURSOR sob_c IS
812: SELECT gsb.period_set_name, org.set_of_books_id, org.set_of_books_name
813: FROM ce_forecast_orgs_v org,
814: gl_sets_of_books gsb
815: WHERE gsb.set_of_books_id = org.set_of_books_id
816: AND org.app_short_name = G_app_short_name
817: AND org.set_of_books_id = NVL(G_set_of_books_id,org.set_of_books_id)
818: AND (org.org_id = DECODE(G_org_id, -1, org.org_id,-99, org.org_id, G_org_id)

Line 827: FROM gl_sets_of_books gsb

823:
824: IF(G_app_short_name = 'GL')THEN
825: SELECT period_set_name, set_of_books_id, name, currency_code
826: INTO calendar, sob_id, sob_name, G_sob_currency_code
827: FROM gl_sets_of_books gsb
828: WHERE gsb.set_of_books_id = G_set_of_books_id;
829:
830: IF (calendar <> G_rp_calendar_name) THEN
831: valid_period := FALSE;