APPS.JA_CN_ITEMIZATION_INTERFACE dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 576: FROM ja_cn_ledger_le_bsv_gt bsv

572: WHERE status=''P''
573: AND ' || l_Company_Column_Name ||
574: ' NOT IN
575: (SELECT bsv.bal_seg_value
576: FROM ja_cn_ledger_le_bsv_gt bsv
577: WHERE Legal_Entity_Id = '|| P_LEGAL_ENTITY_ID ||
578: ' AND ledger_id = '|| P_LEDGER_ID||') ';
579:
580: execute immediate l_sql;

Line 1300: ' ,ja_cn_ledger_le_bsv_gt bsv' ||

1296: ' ,gl_je_lines jel' ||
1297: ' ,gl_code_combinations gcc' ||
1298: ' ,gl_periods gp' ||
1299: ' ,gl_ledgers led' ||
1300: ' ,ja_cn_ledger_le_bsv_gt bsv' ||
1301: ' WHERE jeh.je_header_id = jel.je_header_id' ||
1302: ' AND jeh.status = ''P''' ||
1303: ' AND jeh.period_name = gp.period_name' ||
1304: ' AND jel.code_combination_id = gcc.code_combination_id' ||

Line 1407: FROM ja_cn_ledger_le_bsv_gt bsv

1403: WHERE Je_Header_Id = l_Je_Header_Id
1404: AND Journal_Number IS NOT NULL
1405: AND Company_Segment IN
1406: (SELECT bsv.bal_seg_value
1407: FROM ja_cn_ledger_le_bsv_gt bsv
1408: WHERE Legal_Entity_Id = l_Legal_Entity_Id
1409: and ledger_id = l_ledger_id);
1410:
1411: BEGIN

Line 1441: FROM ja_cn_ledger_le_bsv_gt bsv

1437: WHERE Je_Header_Id = l_Je_Header_Id
1438: AND Journal_Number IS NULL
1439: AND Company_Segment IN
1440: (SELECT bsv.bal_seg_value
1441: FROM ja_cn_ledger_le_bsv_gt bsv
1442: WHERE Legal_Entity_Id = l_Legal_Entity_Id
1443: and ledger_id = l_ledger_id);
1444: ELSE
1445:

Line 1460: FROM ja_cn_ledger_le_bsv_gt bsv

1456: SET Journal_Number = l_Journal_Number
1457: WHERE Je_Header_Id = l_Je_Header_Id
1458: AND Company_Segment IN
1459: (SELECT bsv.bal_seg_value
1460: FROM ja_cn_ledger_le_bsv_gt bsv
1461: WHERE Legal_Entity_Id = l_Legal_Entity_Id
1462: and ledger_id = l_ledger_id);
1463: END IF;
1464: