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_UTILITY dependencies on GL_PERIOD_STATUSES

Line 1207: FROM Gl_Period_Statuses

1203:
1204: -- l_Sob_Id := Ja_Cn_Utility.Get_Sob(p_Legal_Entity_Id);--updated by lyb
1205: SELECT Start_Date
1206: INTO l_Start_Date
1207: FROM Gl_Period_Statuses
1208: WHERE ledger_id=p_ledger_id--Set_Of_Books_Id = l_Sob_Id,--updated by lyb
1209: AND Application_Id = 101
1210: AND Period_Name = p_Start_Period_Name;
1211:

Line 1214: FROM Gl_Period_Statuses

1210: AND Period_Name = p_Start_Period_Name;
1211:
1212: SELECT End_Date
1213: INTO l_End_Date
1214: FROM Gl_Period_Statuses
1215: WHERE ledger_id=p_ledger_id--Set_Of_Books_Id = l_Sob_Id--updated by lyb
1216: AND Application_Id = 101
1217: AND Period_Name = p_End_Period_Name;
1218:

Line 1221: FROM Gl_Period_Statuses

1217: AND Period_Name = p_End_Period_Name;
1218:
1219: SELECT COUNT(*)
1220: INTO l_All_Period_Number
1221: FROM Gl_Period_Statuses
1222: WHERE ledger_id=p_ledger_id--Set_Of_Books_Id = l_Sob_Id--updated by lyb
1223: AND Application_Id = 101
1224: AND ((Start_Date BETWEEN l_Start_Date AND l_End_Date) AND
1225: (End_Date BETWEEN l_Start_Date AND l_End_Date));

Line 1229: FROM Gl_Period_Statuses

1225: (End_Date BETWEEN l_Start_Date AND l_End_Date));
1226:
1227: SELECT COUNT(*)
1228: INTO l_Closed_Period_Number
1229: FROM Gl_Period_Statuses
1230: WHERE ledger_id=p_ledger_id--Set_Of_Books_Id = l_Sob_Id,--updated by lyb
1231: AND Application_Id = 101
1232: AND ((Start_Date BETWEEN l_Start_Date AND l_End_Date) AND
1233: (End_Date BETWEEN l_Start_Date AND l_End_Date))

Line 2154: -- this cursor is to get from month from gl_period_statuses

2150: AND flv.view_application_Id = 0
2151: AND flv.security_group_id = 0
2152: AND flv.lookup_code = pv_module_name;
2153:
2154: -- this cursor is to get from month from gl_period_statuses
2155: CURSOR from_month_cur IS
2156: SELECT
2157: gps.period_num
2158: FROM

Line 2159: gl_period_statuses gps

2155: CURSOR from_month_cur IS
2156: SELECT
2157: gps.period_num
2158: FROM
2159: gl_period_statuses gps
2160: WHERE gps.ledger_id = pv_ledger_id
2161: AND gps.period_name = pv_from_period
2162: AND gps.application_id = 200;
2163:

Line 2164: -- this cursor is to get to month from gl_period_statuses

2160: WHERE gps.ledger_id = pv_ledger_id
2161: AND gps.period_name = pv_from_period
2162: AND gps.application_id = 200;
2163:
2164: -- this cursor is to get to month from gl_period_statuses
2165: CURSOR to_month_cur IS
2166: SELECT
2167: gps.period_num
2168: FROM

Line 2169: gl_period_statuses gps

2165: CURSOR to_month_cur IS
2166: SELECT
2167: gps.period_num
2168: FROM
2169: gl_period_statuses gps
2170: WHERE gps.ledger_id = pv_ledger_id
2171: AND gps.period_name = pv_to_period
2172: AND gps.application_id = 200;
2173: