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 GL_CODE_COMBINATIONS

Line 88: lv_bea_cursor_sql := lv_bea_cursor_sql || ' gl_code_combinations gcc,';

84: --Cursor for getting budget related amount
85: lv_bea_cursor_sql := 'SELECT SUM(NVL(Jel.Accounted_Dr,0) - NVL(Jel.Accounted_Cr,0)) Budget_Related_Amount';
86: lv_bea_cursor_sql := lv_bea_cursor_sql || ' FROM gl_je_lines jel,';
87: lv_bea_cursor_sql := lv_bea_cursor_sql || ' gl_je_headers jeh,';
88: lv_bea_cursor_sql := lv_bea_cursor_sql || ' gl_code_combinations gcc,';
89: lv_bea_cursor_sql := lv_bea_cursor_sql || ' Gl_Periods Gp,';
90: lv_bea_cursor_sql := lv_bea_cursor_sql || ' Gl_Ledgers Gle';
91: lv_bea_cursor_sql := lv_bea_cursor_sql || ' WHERE jeh.ledger_id = ' || pn_ledger_id; --parameter: pn_ledger_id
92: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND jel.Code_Combination_ID = gcc.Code_Combination_ID';

Line 220: lv_exp_fun_cat GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

216: lv_budget_type_segment_column VARCHAR2(30);
217: lv_budget_type_value VARCHAR2(25);
218:
219: ln_accounting_period_num NUMBER;
220: lv_exp_fun_cat GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
221: lv_exp_eco_cat GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
222: lv_project GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
223: lv_period_name GL_PERIODS.PERIOD_NAME%TYPE;
224:

Line 221: lv_exp_eco_cat GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

217: lv_budget_type_value VARCHAR2(25);
218:
219: ln_accounting_period_num NUMBER;
220: lv_exp_fun_cat GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
221: lv_exp_eco_cat GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
222: lv_project GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
223: lv_period_name GL_PERIODS.PERIOD_NAME%TYPE;
224:
225: lv_fun_nature_code VARCHAR2(100);

Line 222: lv_project GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

218:
219: ln_accounting_period_num NUMBER;
220: lv_exp_fun_cat GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
221: lv_exp_eco_cat GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
222: lv_project GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
223: lv_period_name GL_PERIODS.PERIOD_NAME%TYPE;
224:
225: lv_fun_nature_code VARCHAR2(100);
226: lv_bud_source_code VARCHAR2(100);

Line 326: lv_bi_cursor_sql := lv_bi_cursor_sql || ' gl_code_combinations gcc,';

322: lv_bi_cursor_sql := lv_bi_cursor_sql || ' gcc.'|| lv_exp_eco_cat_segment_column ||' Exp_Eco_Category_Code,';
323: lv_bi_cursor_sql := lv_bi_cursor_sql || ' gcc.'|| lv_project_segment_column ||' Project_Id';
324: lv_bi_cursor_sql := lv_bi_cursor_sql || ' FROM gl_je_lines jel,';
325: lv_bi_cursor_sql := lv_bi_cursor_sql || ' gl_je_headers jeh,';
326: lv_bi_cursor_sql := lv_bi_cursor_sql || ' gl_code_combinations gcc,';
327: lv_bi_cursor_sql := lv_bi_cursor_sql || ' Gl_Periods Gp,';
328: lv_bi_cursor_sql := lv_bi_cursor_sql || ' Gl_Ledgers Gle';
329: lv_bi_cursor_sql := lv_bi_cursor_sql || ' WHERE jeh.ledger_id = ' || pn_ledger_id; --parameter: pn_ledger_id
330: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND jel.Code_Combination_ID = gcc.Code_Combination_ID';