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_PS_CYB_EXPORT_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 111: lv_bea_cursor_sql := lv_bea_cursor_sql || ' FROM ja_cn_ledger_le_bsv_gt llbg';

107: END IF;
108:
109: --3) BSV condition
110: lv_bea_cursor_sql:= lv_bea_cursor_sql || ' AND EXISTS (SELECT llbg.Bal_Seg_Value ';
111: lv_bea_cursor_sql := lv_bea_cursor_sql || ' FROM ja_cn_ledger_le_bsv_gt llbg';
112: lv_bea_cursor_sql := lv_bea_cursor_sql || ' WHERE JA_CN_UTILITY.get_balancing_segment(gcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value';
113: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND llbg.Ledger_Id = ' || pn_ledger_id; --parameter: pn_ledger_id
114: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND llbg.Legal_Entity_Id =' || pn_legal_entity_id || ')'; --parameter: pn_legal_entity_id;
115: --4) Period condition

Line 260: --Step0: Populate balancing segment values to table ja_cn_ledger_le_bsv_gt

256: -- 'pv_accounting_year=' || pv_accounting_year || ',' ||
257: -- 'pv_period_from=' || pv_period_from || ',' ||
258: -- 'pv_period_to=' || pv_period_to);
259:
260: --Step0: Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
261: DELETE
262: FROM JA_CN_LEDGER_LE_BSV_GT;
263: COMMIT ;
264: IF ja_cn_utility.populate_ledger_le_bsv_gt(pn_ledger_id, pn_legal_entity_id) <> 'S'

Line 262: FROM JA_CN_LEDGER_LE_BSV_GT;

258: -- 'pv_period_to=' || pv_period_to);
259:
260: --Step0: Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
261: DELETE
262: FROM JA_CN_LEDGER_LE_BSV_GT;
263: COMMIT ;
264: IF ja_cn_utility.populate_ledger_le_bsv_gt(pn_ledger_id, pn_legal_entity_id) <> 'S'
265: THEN
266: RETURN;

Line 349: lv_bi_cursor_sql := lv_bi_cursor_sql || ' FROM ja_cn_ledger_le_bsv_gt llbg';

345: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND gcc.'|| lv_budget_type_segment_column ||' <> ''' || lv_budget_type_value || '''';
346: END IF;
347: --3) BSV condition
348: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND EXISTS (SELECT llbg.Bal_Seg_Value ';
349: lv_bi_cursor_sql := lv_bi_cursor_sql || ' FROM ja_cn_ledger_le_bsv_gt llbg';
350: lv_bi_cursor_sql := lv_bi_cursor_sql || ' WHERE JA_CN_UTILITY.get_balancing_segment(gcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value';
351: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND llbg.Ledger_Id = ' || pn_ledger_id; --parameter: pn_ledger_id
352: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND llbg.Legal_Entity_Id =' || pn_legal_entity_id || ')'; --parameter: pn_legal_entity_id;
353: --4) Period condition