APPS.JA_CN_VOUCHER_NUM_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 87: FROM ja_cn_ledger_le_bsv_gt jclllbg

83: AND gjh.status = 'P'
84: AND gjh.period_name = pv_period_name
85: AND EXISTS
86: (SELECT jclllbg.bal_seg_value
87: FROM ja_cn_ledger_le_bsv_gt jclllbg
88: WHERE get_balancing_segment(gjl.code_combination_id) =
89: jclllbg.bal_seg_value
90: AND jclllbg.Ledger_Id = pn_ledger_id
91: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)

Line 152: FROM ja_cn_ledger_le_bsv_gt

148: BEGIN
149:
150: SELECT count(*)
151: INTO ln_bsv_assigned_num
152: FROM ja_cn_ledger_le_bsv_gt
153: WHERE ledger_id = pn_ledger_id;
154: -- BSV is assigned, only the parameter legal entity will be handled.
155: IF (ln_bsv_assigned_num > 0) THEN
156: IF (pv_regenerate_flag = 'Y') THEN