eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_POST_UTILITY_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 1412: --Step1: Populate balancing segment values to table ja_cn_ledger_le_bsv_gt

1408: AND ifs.APPLICATION_COLUMN_NAME= sav.APPLICATION_COLUMN_NAME
1409: AND led.ledger_id = p_ledger_id;
1410:
1411: --Begin: Added for fixing bug 9582957 by Chaoqun on 27-May-2010
1412: --Step1: Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
1413: DELETE
1414: FROM JA_CN_LEDGER_LE_BSV_GT;
1415: COMMIT ;
1416: IF ja_cn_utility.populate_ledger_le_bsv_gt(p_ledger_id, p_legal_entity_id) <> 'S'

Line 1414: FROM JA_CN_LEDGER_LE_BSV_GT;

1410:
1411: --Begin: Added for fixing bug 9582957 by Chaoqun on 27-May-2010
1412: --Step1: Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
1413: DELETE
1414: FROM JA_CN_LEDGER_LE_BSV_GT;
1415: COMMIT ;
1416: IF ja_cn_utility.populate_ledger_le_bsv_gt(p_ledger_id, p_legal_entity_id) <> 'S'
1417: THEN
1418: RETURN;

Line 1587: FROM ja_cn_ledger_le_bsv_gt llbg

1583: AND nvl(jcc1.SEGMENT29,'0')= nvl(jcc.SEGMENT29,'0')
1584: AND nvl(jcc1.SEGMENT30,'0')= nvl(jcc.SEGMENT30,'0')
1585: --BSV condition
1586: AND EXISTS (SELECT llbg.Bal_Seg_Value
1587: FROM ja_cn_ledger_le_bsv_gt llbg
1588: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(jcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
1589: AND llbg.Ledger_Id = p_ledger_id --parameter: p_ledger_id
1590: AND llbg.Legal_Entity_Id = p_legal_entity_id) --parameter: p_legal_entity_id
1591: GROUP BY jcc.company_segment