DBA Data[Home] [Help]

APPS.OZF_GL_TRANSFER_PVT dependencies on GL_SETS_OF_BOOKS

Line 17: FROM gl_sets_of_books sob,

13: FUNCTION ozf_mc_check (p_psob_id NUMBER)
14: RETURN varchar2 IS
15: cursor c1 (sob_id number) IS
16: SELECT sp.set_of_books_id
17: FROM gl_sets_of_books sob,
18: ozf_sys_parameters sp
19: WHERE sob.set_of_books_id = sp.set_of_books_id
20: AND sp.set_of_books_id = nvl(sob_id, sp.set_of_books_id)
21: AND sp.set_of_books_id <> -1;

Line 116: FROM gl_sets_of_books sob,

112: , sob.currency_code
113: , 'Accrual' accounting_method
114: , 'P' sob_type
115: , 'N' encumbrance_flag
116: FROM gl_sets_of_books sob,
117: ozf_sys_parameters sp
118: WHERE sob.set_of_books_id = sp.set_of_books_id
119: AND sp.set_of_books_id = decode(sob_id, -1,sp.set_of_books_id, sob_id)
120: AND sp.set_of_books_id <> -1;