DBA Data[Home] [Help]

APPS.JL_JLCOGLAN_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 268: SELECT glp.period_num,glp.period_year into p_num,p_year from gl_periods glp,gl_sets_of_books gls

264: DECLARE
265: p_num number;
266: p_year number;
267: BEGIN
268: SELECT glp.period_num,glp.period_year into p_num,p_year from gl_periods glp,gl_sets_of_books gls
269: WHERE glp.period_name = P_start_period
270: AND glp.period_set_name = gls.period_set_name
271: AND gls.set_of_books_id = P_set_of_books_id;
272:

Line 283: SELECT glp.period_num,glp.period_year into p_num1,p_year1 from gl_periods glp,gl_sets_of_books gls

279: declare
280: p_num1 number;
281: p_year1 number;
282: begin
283: SELECT glp.period_num,glp.period_year into p_num1,p_year1 from gl_periods glp,gl_sets_of_books gls
284: WHERE glp.period_name = P_end_period
285: AND glp.period_set_name = gls.period_set_name
286: AND gls.set_of_books_id = P_set_of_books_id;
287: