APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on GL_SETS_OF_BOOKS

Line 64: CURSOR Start_date(p_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE) IS

60: and nvl(pvs.language,p_base_language)=p_session_language;
61:
62: /*--Cusrsor start date holds the Start date for a period
63:
64: CURSOR Start_date(p_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE) IS
65: SELECT gp.start_date
66: FROM gl_period_types gpt,gl_periods gp,
67: gl_period_sets gps,gl_sets_of_books sob
68: WHERE

Line 67: gl_period_sets gps,gl_sets_of_books sob

63:
64: CURSOR Start_date(p_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE) IS
65: SELECT gp.start_date
66: FROM gl_period_types gpt,gl_periods gp,
67: gl_period_sets gps,gl_sets_of_books sob
68: WHERE
69: sob.set_of_books_id=p_set_of_books_id
70: and sob.period_set_name=gps.period_set_name
71: and sob.accounted_period_type=gpt.period_type

Line 170: Selecting the organization from gl_sets_of_books

166: where installed_flag = 'B';
167:
168: -- for bug#1721165 End TMANDA
169: /* For bug 2113775
170: Selecting the organization from gl_sets_of_books
171: in case of single org since the org_id will be
172: null in hr_organization_units
173: */
174:

Line 187: FROM gl_sets_of_books

183: When no_data_found Then
184: Begin
185: Select name
186: INTO l_organization_name
187: FROM gl_sets_of_books
188: WHERE set_of_books_id = P_Set_of_books_id;
189: Exception
190: When others then
191: null;

Line 201: FROM gl_sets_of_books

197:
198:
199: SELECT currency_code
200: INTO l_functional_currency_code
201: FROM gl_sets_of_books
202: WHERE set_of_books_id = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
203:
204: /*OPEN start_date(p_set_of_books_id);
205: FETCH start_date into l_start_date;