APPS.PSB_BUDGET_ACCOUNT_PVT dependencies on GL_SETS_OF_BOOKS

Line 28: g_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

24: -- To store set of books id for the current set.
25: g_set_of_books_id psb_account_position_sets.set_of_books_id%TYPE;
26:
27: -- To store chart of accounts id for the current set.
28: g_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
29:
30: -- To store total number of active segments for the current chart of
31: -- accounts..
32: g_total_active_segments NUMBER := 0;

Line 315: FROM gl_sets_of_books

311: WHERE account_position_set_id = p_account_set_id ;
312:
313: -- Get the chart of accounts for the set_of_books_id.
314: SELECT chart_of_accounts_id INTO g_chart_of_accounts_id
315: FROM gl_sets_of_books
316: WHERE set_of_books_id = g_set_of_books_id;
317:
318: -- Bug 3458191: Introduce the following condition to avoiding extra queries.
319: IF g_chart_of_accounts_id <> NVL(g_cached_chart_of_account_id, -99)

Line 714: l_set_of_books_name gl_sets_of_books.name%TYPE;

710: l_msg_count NUMBER ;
711: l_msg_data VARCHAR2(2000) ;
712: l_msg_index_out NUMBER;
713: --
714: l_set_of_books_name gl_sets_of_books.name%TYPE;
715: l_account_set_name psb_account_position_sets.name%TYPE;
716: --
717: BEGIN
718: --

Line 728: FROM gl_sets_of_books

724: 'Set of books Name : ALL');
725: ELSE
726: --
727: SELECT name INTO l_set_of_books_name
728: FROM gl_sets_of_books
729: WHERE set_of_books_id = p_set_of_books_id ;
730: --
731: FND_FILE.Put_Line( FND_FILE.OUTPUT,
732: 'Set of books name : ' || l_set_of_books_name );