APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 257: FROM JA_CN_LEDGER_LE_BSV_GT tmpbsv

253: --check the company segment belongs to the current legal entity or not.
254: l_com_seg_check := 0;
255: SELECT count(*) row_count
256: INTO l_com_seg_check
257: FROM JA_CN_LEDGER_LE_BSV_GT tmpbsv
258: WHERE tmpbsv.LEGAL_ENTITY_ID = l_le_id --using variable l_le_id
259: AND tmpbsv.ledger_id = l_ledger_id --using variable l_ledger_id
260: AND tmpbsv.bal_seg_value = l_com_seg; --using variable l_com_seg
261:

Line 300: FROM JA_CN_LEDGER_LE_BSV_GT tmpbsv

296: --check the company segment belongs to the current legal entity or not.
297: l_com_seg_check := 0;
298: SELECT count(*) row_count
299: INTO l_com_seg_check
300: FROM JA_CN_LEDGER_LE_BSV_GT tmpbsv
301: WHERE tmpbsv.LEGAL_ENTITY_ID = l_le_id --using variable l_le_id
302: AND tmpbsv.ledger_id = l_ledger_id --using variable l_ledger_id
303: AND tmpbsv.bal_seg_value = TO_CHAR(l_com_seg); --using variable l_com_seg
304: END IF;

Line 309: FROM JA_CN_LEDGER_LE_BSV_GT tmpbsv

305: /*
306: ----------------------------for test--------------------------------------------
307: SELECT count(*) row_count
308: INTO l_com_seg_check
309: FROM JA_CN_LEDGER_LE_BSV_GT tmpbsv
310: WHERE tmpbsv.LEGAL_ENTITY_ID = l_le_id --using variable l_le_id
311: AND tmpbsv.ledger_id = l_ledger_id; --using variable l_ledger_id
312: ----------------------------fro test--------------------------------------------
313: */

Line 931: --,JA_CN_LEDGER_LE_BSV_GT tmpbsv

927: FROM FUN_TRX_LINES trl
928: ,FUN_DIST_LINES trldist
929: ,GL_CODE_COMBINATIONS codecmb
930: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
931: --,JA_CN_LEDGER_LE_BSV_GT tmpbsv
932: ,JA_CN_DFF_ASSIGNMENTS dff
933: ,xle_entity_profiles xep -- Added for fixing bug# 8744259 by Chaoqun on 30-Jul-2009
934: WHERE trl.line_id=trldist.line_id
935: AND trl.trx_id=trldist.trx_id

Line 954: ) = tmpbsv.bal_seg_value --select only company segment list in the ja_cn_ledger_le_bsv_gt table */

950: 'SEGMENT19',codecmb.SEGMENT19, 'SEGMENT20',codecmb.SEGMENT20, 'SEGMENT21',codecmb.SEGMENT21,
951: 'SEGMENT22',codecmb.SEGMENT22, 'SEGMENT23',codecmb.SEGMENT23, 'SEGMENT24',codecmb.SEGMENT24,
952: 'SEGMENT25',codecmb.SEGMENT25, 'SEGMENT26',codecmb.SEGMENT26, 'SEGMENT27',codecmb.SEGMENT27,
953: 'SEGMENT28',codecmb.SEGMENT28, 'SEGMENT29',codecmb.SEGMENT29, 'SEGMENT30',codecmb.SEGMENT30
954: ) = tmpbsv.bal_seg_value --select only company segment list in the ja_cn_ledger_le_bsv_gt table */
955: --locate to the right segment attribute value
956: AND fsav.application_id = 101
957: AND fsav.id_flex_num = l_coa_id
958: AND fsav.attribute_value = 'Y'

Line 981: FROM JA_CN_LEDGER_LE_BSV_GT;

977: END IF; --(l_proc_level >= l_dbg_level)
978:
979: --Get the BSV reffered to the current legal entity and ledger
980: DELETE
981: FROM JA_CN_LEDGER_LE_BSV_GT;
982: COMMIT ;
983: --
984: --ja_cn_utility_pkg.populate_ledger_le_bsv_gt( P_LEDGER_ID,P_LE_ID);
985: