APPS.OZF_GL_TRANSFER_PVT dependencies on OZF_SYS_PARAMETERS

Line 18: ozf_sys_parameters sp

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;
22:

Line 117: ozf_sys_parameters sp

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;
121:

Line 169: from ozf_sys_parameters

165: into l_start_date
166: from gl_period_statuses
167: where application_id = 222
168: and set_of_books_id in ( select set_of_books_id
169: from ozf_sys_parameters
170: where set_of_books_id <> -1)
171: and nvl(adjustment_period_flag,'N') = 'N'
172: and closing_status IN ( 'O','F');
173: end if;