APPS.JL_BR_CALCBAL_PKG dependencies on JL_BR_JOURNALS_ALL

Line 457: FROM jl_br_journals_all jl

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;
460:
461: CURSOR C_Period_Ctr(p_period_set_name In gl_sets_of_books.period_set_name%TYPE

Line 477: FROM jl_br_journals_all jl

473: SELECT jl.application_id appl_id
474: ,jl.org_id
475: ,jl.personnel_id vendor_id
476: ,jl.code_combination_id ccid
477: FROM jl_br_journals_all jl
478: WHERE jl.application_id = nvl(p_appl_id, jl.application_id)
479: AND jl.org_id = nvl(p_org_id, jl.org_id)
480: AND jl.set_of_books_id = cp_sob_id
481: AND jl.personnel_id = nvl(p_vendor_id, jl.personnel_id)

Line 538: FROM jl_br_journals_all jb

534: ,cp_set_name In jl_br_balances.period_set_name%Type
535: ,cp_name In jl_br_balances.period_name%Type) Is
536: SELECT
537: NVL(SUM(DECODE(jb.trans_value_sign,'D',-1*jb.trans_value,jb.trans_value)),0) balance
538: FROM jl_br_journals_all jb
539: WHERE jb.application_id = cp_appl_id
540: AND jb.org_id = cp_org_id
541: AND jb.set_of_books_id = cp_sob
542: AND jb.personnel_id = cp_vendor_id

Line 768: Update jl_br_journals_all

764: ,l_org_id_tbl(j));
765:
766: -- Update Journals
767: Forall k in l_period_num_tbl.First .. l_period_num_tbl.Last
768: Update jl_br_journals_all
769: Set journal_balance_flag = 'Y'
770: WHERE application_id = l_appl_id_tbl(k)
771: AND org_id = l_org_id_tbl(k)
772: AND set_of_books_id = l_sob_id_tbl(k)