APPS.JA_CN_GL_INTER_VALID_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 251: FROM JA_CN_LEDGER_LE_BSV_GT tmpbsv

247: THEN
248: --check the company segment belongs to the current legal entity or not.
249: SELECT count(*) row_count
250: INTO l_com_seg_check
251: FROM JA_CN_LEDGER_LE_BSV_GT tmpbsv
252: WHERE tmpbsv.LEGAL_ENTITY_ID = l_le_id --using variable l_le_id
253: AND tmpbsv.ledger_id = l_ledger_id --using variable l_ledger_id
254: AND tmpbsv.bal_seg_value = l_com_seg; --using variable l_com_seg
255:

Line 901: FROM JA_CN_LEDGER_LE_BSV_GT

897: END IF;
898:
899: --Get the BSV reffered to the current legal entity and ledger
900: DELETE
901: FROM JA_CN_LEDGER_LE_BSV_GT
902: ;
903: COMMIT ;
904: --
905: IF ja_cn_utility.populate_ledger_le_bsv_gt( P_LEDGER_ID,P_LE_ID) <> 'S' THEN

Line 1437: FROM JA_CN_LEDGER_LE_BSV_GT bsv

1433: /*
1434: --Cursor to get the BSV according to the current legal entity and ledger id
1435: CURSOR c_bsvs IS
1436: SELECT bsv.*
1437: FROM JA_CN_LEDGER_LE_BSV_GT bsv
1438: WHERE bsv.ledger_id = P_LEDGER_ID
1439: AND bsv.legal_entity_id = P_LE_ID
1440: AND bsv.chart_of_accounts_id = P_COA_ID
1441: ;

Line 1611: FROM JA_CN_LEDGER_LE_BSV_GT

1607:
1608:
1609: --Get the BSV reffered to the current legal entity and ledger
1610: DELETE
1611: FROM JA_CN_LEDGER_LE_BSV_GT
1612: ;
1613: COMMIT ;
1614: --
1615: IF ja_cn_utility.populate_ledger_le_bsv_gt( P_LEDGER_ID,P_LE_ID) <> 'S' THEN

Line 1772: FROM JA_CN_LEDGER_LE_BSV_GT tmp_bsv

1768: -- sender amounts;
1769: BEGIN
1770: SELECT count(*)
1771: INTO l_trx_sender_c
1772: FROM JA_CN_LEDGER_LE_BSV_GT tmp_bsv
1773: WHERE tmp_bsv.ledger_id = l_trx_send_ledger_id -- ?? not sure
1774: AND tmp_bsv.legal_entity_id = l_trx_send_le_id -- ?? not sure
1775: AND tmp_bsv.bal_seg_value = l_codecmb_com_seg
1776: ;

Line 1787: FROM JA_CN_LEDGER_LE_BSV_GT tmp_bsv

1783: -- receiver amounts;
1784: BEGIN
1785: SELECT count(*)
1786: INTO l_trx_receiver_c
1787: FROM JA_CN_LEDGER_LE_BSV_GT tmp_bsv
1788: WHERE tmp_bsv.ledger_id = l_trx_recv_ledger_id -- ?? not sure
1789: AND tmp_bsv.legal_entity_id = l_trx_recv_le_id -- ?? not sure
1790: AND tmp_bsv.bal_seg_value = l_codecmb_com_seg
1791: ;