58:
59: BEGIN
60: select set_of_books_id
61: into h_set_of_books_id
62: from fa_book_controls
63: where book_type_code = p_book;
64: EXCEPTION
65: WHEN OTHERS THEN
66: h_set_of_books_id := NULL;
1643: l_Distribution_Source_Book
1644: FROM
1645: FA_DEPRN_PERIODS P1,
1646: FA_DEPRN_PERIODS P2,
1647: FA_BOOK_CONTROLS BC
1648: WHERE
1649: BC.Book_Type_Code = p_Book AND
1650: P1.Book_Type_Code = p_Book AND
1651: P1.Period_Name = p_Start_Period_Name AND
1727: WHERE amount = 0;
1728:
1729: SELECT SOB.Chart_of_Accounts_ID
1730: INTO l_chart_of_accounts_id
1731: FROM fa_book_controls BC,
1732: gl_sets_of_books SOB
1733: WHERE BC.Book_Type_Code = p_book AND
1734: SOB.Set_Of_Books_ID = BC.Set_Of_Books_ID;
1735: