APPS.JL_BR_CALCBAL_PKG dependencies on GL_SETS_OF_BOOKS

Line 75: ,gl_sets_of_books sb

71: ,gp.period_type period_type
72: ,min((gp.period_year * 10000) + gp.period_num) min_jrl_perctr
73: ,max((gp.period_year * 10000) + gp.period_num) max_jrl_perctr
74: FROM jl_br_journals jl
75: ,gl_sets_of_books sb
76: ,gl_periods gp
77: WHERE jl.application_id = p_appl_id
78: AND nvl(jl.journal_balance_flag,'N') = 'N'
79: AND sb.set_of_books_id = jl.set_of_books_id

Line 455: FROM gl_sets_of_books sb

451: CURSOR C_Sob Is
452: SELECT sb.set_of_books_id sob_id
453: ,sb.period_set_name period_set_name
454: ,sb.accounted_period_type period_type
455: FROM gl_sets_of_books sb
456: ,(SELECT distinct set_of_books_id
457: FROM jl_br_journals_all jl
458: WHERE jl.set_of_books_id = nvl(p_sob_id, jl.set_of_books_id)) jl_sob
459: WHERE sb.set_of_books_id = jl_sob.set_of_books_id;

Line 461: CURSOR C_Period_Ctr(p_period_set_name In gl_sets_of_books.period_set_name%TYPE

457: FROM jl_br_journals_all jl
458: WHERE jl.set_of_books_id = nvl(p_sob_id, jl.set_of_books_id)) jl_sob
459: WHERE sb.set_of_books_id = jl_sob.set_of_books_id;
460:
461: CURSOR C_Period_Ctr(p_period_set_name In gl_sets_of_books.period_set_name%TYPE
462: ,p_period_type In gl_sets_of_books.accounted_period_type%TYPE
463: ,p_period_name In gl_periods.period_name%TYPE) Is
464: SELECT period_year peryear
465: ,period_num pernum

Line 462: ,p_period_type In gl_sets_of_books.accounted_period_type%TYPE

458: WHERE jl.set_of_books_id = nvl(p_sob_id, jl.set_of_books_id)) jl_sob
459: WHERE sb.set_of_books_id = jl_sob.set_of_books_id;
460:
461: CURSOR C_Period_Ctr(p_period_set_name In gl_sets_of_books.period_set_name%TYPE
462: ,p_period_type In gl_sets_of_books.accounted_period_type%TYPE
463: ,p_period_name In gl_periods.period_name%TYPE) Is
464: SELECT period_year peryear
465: ,period_num pernum
466: ,((period_year * 10000) + period_num) perctr