APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 392: ' ,ja_cn_ledger_le_bsv_gt bsv' ||

388: ' ,gl_je_lines jel' ||
389: ' ,gl_code_combinations gcc' ||
390: ' ,gl_periods gp' ||
391: ' ,gl_ledgers led' ||
392: ' ,ja_cn_ledger_le_bsv_gt bsv' ||
393: ' WHERE jeh.je_header_id = jel.je_header_id' ||
394: ' AND jeh.status = ''P''' ||
395: ' AND jeh.period_name = gp.period_name' ||
396: ' AND jel.code_combination_id = gcc.code_combination_id' ||

Line 1327: FROM ja_cn_ledger_le_bsv_gt bsv

1323: WHERE Je_Header_Id = l_Je_Header_Id
1324: AND Journal_Number IS NOT NULL
1325: AND Company_Segment IN
1326: (SELECT bsv.bal_seg_value
1327: FROM ja_cn_ledger_le_bsv_gt bsv
1328: WHERE Legal_Entity_Id = l_Legal_Entity_Id
1329: and ledger_id = l_ledger_id);
1330:
1331: BEGIN

Line 1362: FROM ja_cn_ledger_le_bsv_gt bsv

1358: WHERE Je_Header_Id = l_Je_Header_Id
1359: AND Journal_Number IS NULL
1360: AND Company_Segment IN
1361: (SELECT bsv.bal_seg_value
1362: FROM ja_cn_ledger_le_bsv_gt bsv
1363: WHERE Legal_Entity_Id = l_Legal_Entity_Id
1364: and ledger_id = l_ledger_id);
1365: ELSE
1366: CLOSE c_Journal_Appending;

Line 1381: FROM ja_cn_ledger_le_bsv_gt bsv

1377: SET Journal_Number = l_Journal_Number
1378: WHERE Je_Header_Id = l_Je_Header_Id
1379: AND Company_Segment IN
1380: (SELECT bsv.bal_seg_value
1381: FROM ja_cn_ledger_le_bsv_gt bsv
1382: WHERE Legal_Entity_Id = l_Legal_Entity_Id
1383: and ledger_id = l_ledger_id);
1384: END IF;
1385: