APPS.JL_BR_CALCBAL_PKG dependencies on JL_BR_JOURNALS

Line 74: FROM jl_br_journals jl

70: ,jl.period_set_name period_set_name
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'

Line 142: FROM jl_br_journals jb

138: ,p_set_name In jl_br_balances.period_set_name%Type
139: ,p_name In jl_br_balances.period_name%Type) Is
140: SELECT
141: NVL(SUM(DECODE(jb.trans_value_sign,'D',-1*jb.trans_value,jb.trans_value)),0) balance
142: FROM jl_br_journals jb
143: WHERE jb.application_id = p_appl_id
144: AND jb.set_of_books_id = p_sob_id
145: AND jb.personnel_id = p_vendor_id
146: AND jb.code_combination_id = p_ccid

Line 372: Update jl_br_journals

368: ,PersonnelCCID_Rec.org_id);
369:
370: -- Update Journals
371: Forall l in l_period_num_tbl.First .. l_period_num_tbl.Last
372: Update jl_br_journals
373: Set journal_balance_flag = 'Y'
374: WHERE application_id = l_appl_id_tbl(l)
375: AND set_of_books_id = l_sob_id_tbl(l)
376: AND personnel_id = l_personnel_id_tbl(l)

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)