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_PERIODS

Line 89: lv_bea_cursor_sql := lv_bea_cursor_sql || ' Gl_Periods Gp,';

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';
93: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND jel.je_header_id = jeh.je_header_id';

Line 122: lv_bea_cursor_sql := lv_bea_cursor_sql || ' FROM Gl_Periods Gp1';

118: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND Gle.Ledger_Id = jeh.ledger_id';
119: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND Gp.Period_Name = Jeh.Period_Name';
120: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND jeh.Default_Effective_Date BETWEEN';
121: lv_bea_cursor_sql := lv_bea_cursor_sql || ' (SELECT MIN(Gp1.Start_Date)';
122: lv_bea_cursor_sql := lv_bea_cursor_sql || ' FROM Gl_Periods Gp1';
123: lv_bea_cursor_sql := lv_bea_cursor_sql || ' WHERE Gle.period_set_name = Gp1.period_set_name';
124: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND Gle.accounted_period_type = Gp1.period_type';
125: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND Gp1.period_year = '''|| pv_accounting_year ||''')'; --parameter: pv_accounting_year
126: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND (SELECT MAX(Gp2.End_Date)';

Line 127: lv_bea_cursor_sql := lv_bea_cursor_sql || ' FROM Gl_Periods Gp2';

123: lv_bea_cursor_sql := lv_bea_cursor_sql || ' WHERE Gle.period_set_name = Gp1.period_set_name';
124: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND Gle.accounted_period_type = Gp1.period_type';
125: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND Gp1.period_year = '''|| pv_accounting_year ||''')'; --parameter: pv_accounting_year
126: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND (SELECT MAX(Gp2.End_Date)';
127: lv_bea_cursor_sql := lv_bea_cursor_sql || ' FROM Gl_Periods Gp2';
128: lv_bea_cursor_sql := lv_bea_cursor_sql || ' WHERE Gle.period_set_name = Gp2.period_set_name';
129: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND Gle.accounted_period_type = Gp2.period_type';
130: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND (('''|| pv_period_to ||''' IS NULL '; --parameter: pv_period_to
131: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND Gp2.period_year = '''|| pv_accounting_year ||''')'; --parameter: pv_accounting_year

Line 223: lv_period_name GL_PERIODS.PERIOD_NAME%TYPE;

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);
227:

Line 288: lv_pi_cursor_sql := lv_pi_cursor_sql || ' FROM Gl_Periods Gp , ';

284: );
285:
286: --fixed bug 10316565 by ChuanLing Shao
287: lv_pi_cursor_sql := ' SELECT DISTINCT Gp.Period_Num Accounting_Period_Num, Gp.Period_Name Accounting_Period ';
288: lv_pi_cursor_sql := lv_pi_cursor_sql || ' FROM Gl_Periods Gp , ';
289: lv_pi_cursor_sql := lv_pi_cursor_sql || ' Gl_Ledgers Gle ';
290: lv_pi_cursor_sql := lv_pi_cursor_sql || ' WHERE ' ;
291: lv_pi_cursor_sql := lv_pi_cursor_sql || ' Gle.period_set_name = Gp.period_set_name ';
292: lv_pi_cursor_sql := lv_pi_cursor_sql || ' AND Gle.accounted_period_type = Gp.period_type ';

Line 298: lv_pi_cursor_sql := lv_pi_cursor_sql || ' FROM Gl_Periods Gp1 ';

294: lv_pi_cursor_sql := lv_pi_cursor_sql || ' AND ';
295: lv_pi_cursor_sql := lv_pi_cursor_sql || ' Gp.Start_date BETWEEN ' ;
296: lv_pi_cursor_sql := lv_pi_cursor_sql || ' ( ';
297: lv_pi_cursor_sql := lv_pi_cursor_sql || ' SELECT MIN(Gp1.Start_Date) ';
298: lv_pi_cursor_sql := lv_pi_cursor_sql || ' FROM Gl_Periods Gp1 ';
299: lv_pi_cursor_sql := lv_pi_cursor_sql || ' WHERE Gle.period_set_name = Gp1.period_set_name ';
300: lv_pi_cursor_sql := lv_pi_cursor_sql || ' AND Gle.accounted_period_type = Gp1.period_type ';
301: lv_pi_cursor_sql := lv_pi_cursor_sql || ' AND Gp1.period_name = '''||pv_period_from||'''';
302: lv_pi_cursor_sql := lv_pi_cursor_sql || ' ) ';

Line 306: lv_pi_cursor_sql := lv_pi_cursor_sql || ' FROM Gl_Periods Gp2 ';

302: lv_pi_cursor_sql := lv_pi_cursor_sql || ' ) ';
303: lv_pi_cursor_sql := lv_pi_cursor_sql || ' AND ';
304: lv_pi_cursor_sql := lv_pi_cursor_sql || ' ( ';
305: lv_pi_cursor_sql := lv_pi_cursor_sql || ' SELECT MAX(Gp2.End_Date) ';
306: lv_pi_cursor_sql := lv_pi_cursor_sql || ' FROM Gl_Periods Gp2 ';
307: lv_pi_cursor_sql := lv_pi_cursor_sql || ' WHERE Gle.period_set_name = Gp2.period_set_name ';
308: lv_pi_cursor_sql := lv_pi_cursor_sql || ' AND Gle.accounted_period_type = Gp2.period_type ';
309: lv_pi_cursor_sql := lv_pi_cursor_sql || ' AND Gp2.period_name = '''||pv_period_to||'''';
310: lv_pi_cursor_sql := lv_pi_cursor_sql || ' ) ';

Line 327: lv_bi_cursor_sql := lv_bi_cursor_sql || ' Gl_Periods Gp,';

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';
331: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND jel.Je_Header_Id = jeh.Je_Header_Id';

Line 360: lv_bi_cursor_sql := lv_bi_cursor_sql || ' FROM Gl_Periods Gp1';

356: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gle.Ledger_Id = jeh.ledger_id';
357: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gp.Period_Name = Jeh.Period_Name';
358: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND jeh.Default_Effective_Date BETWEEN';
359: lv_bi_cursor_sql := lv_bi_cursor_sql || ' (SELECT MIN(Gp1.Start_Date)';
360: lv_bi_cursor_sql := lv_bi_cursor_sql || ' FROM Gl_Periods Gp1';
361: lv_bi_cursor_sql := lv_bi_cursor_sql || ' WHERE Gle.period_set_name = Gp1.period_set_name';
362: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gle.accounted_period_type = Gp1.period_type';
363: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gp1.period_year = '''||pv_accounting_year||''')'; --parameter: pv_period_from
364: --lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gp1.period_name = '''||pv_period_from||''')'; --parameter: pv_period_from

Line 366: lv_bi_cursor_sql := lv_bi_cursor_sql || ' FROM Gl_Periods Gp2';

362: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gle.accounted_period_type = Gp1.period_type';
363: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gp1.period_year = '''||pv_accounting_year||''')'; --parameter: pv_period_from
364: --lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gp1.period_name = '''||pv_period_from||''')'; --parameter: pv_period_from
365: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND (SELECT MAX(Gp2.End_Date)';
366: lv_bi_cursor_sql := lv_bi_cursor_sql || ' FROM Gl_Periods Gp2';
367: lv_bi_cursor_sql := lv_bi_cursor_sql || ' WHERE Gle.period_set_name = Gp2.period_set_name';
368: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gle.accounted_period_type = Gp2.period_type';
369: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gp2.period_year = '''||pv_accounting_year||'''))'; --parameter: pv_period_to
370: --lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gp2.period_name = '''||pv_period_to||'''))'; --parameter: pv_period_to