APPS.JA_CN_VOUCHER_NUM_MIG_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 86: FROM ja_cn_ledger_le_bsv_gt jclllbg

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

Line 155: FROM ja_cn_ledger_le_bsv_gt jclllbg

151: --AND jcjl.status = 'P'
152: AND gjh.period_name = pv_period_name
153: AND EXISTS
154: (SELECT jclllbg.bal_seg_value
155: FROM ja_cn_ledger_le_bsv_gt jclllbg
156: WHERE JA_CN_VOUCHER_NUM_PKG.get_balancing_segment(jcjl.code_combination_id) =
157: jclllbg.bal_seg_value
158: AND jclllbg.Ledger_Id = pn_ledger_id
159: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)

Line 191: FROM ja_cn_ledger_le_bsv_gt

187: gjh.je_header_id ASC;
188:
189: SELECT count(*)
190: INTO ln_bsv_assigned_num
191: FROM ja_cn_ledger_le_bsv_gt
192: WHERE ledger_id = pn_ledger_id;
193: -- BSV is assigned, only the parameter legal entity will be handled.
194: IF (ln_bsv_assigned_num > 0) THEN
195: IF (ln_bsv_mig_num > 0) THEN