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 1085: FROM Gl_Period_Statuses

1081:
1082: -- l_Sob_Id := Ja_Cn_Utility.Get_Sob(p_Legal_Entity_Id);--updated by lyb
1083: SELECT Start_Date
1084: INTO l_Start_Date
1085: FROM Gl_Period_Statuses
1086: WHERE ledger_id=p_ledger_id--Set_Of_Books_Id = l_Sob_Id,--updated by lyb
1087: AND Application_Id = 101
1088: AND Period_Name = p_Start_Period_Name;
1089:

Line 1092: FROM Gl_Period_Statuses

1088: AND Period_Name = p_Start_Period_Name;
1089:
1090: SELECT End_Date
1091: INTO l_End_Date
1092: FROM Gl_Period_Statuses
1093: WHERE ledger_id=p_ledger_id--Set_Of_Books_Id = l_Sob_Id--updated by lyb
1094: AND Application_Id = 101
1095: AND Period_Name = p_End_Period_Name;
1096:

Line 1099: FROM Gl_Period_Statuses

1095: AND Period_Name = p_End_Period_Name;
1096:
1097: SELECT COUNT(*)
1098: INTO l_All_Period_Number
1099: FROM Gl_Period_Statuses
1100: WHERE ledger_id=p_ledger_id--Set_Of_Books_Id = l_Sob_Id--updated by lyb
1101: AND Application_Id = 101
1102: AND ((Start_Date BETWEEN l_Start_Date AND l_End_Date) AND
1103: (End_Date BETWEEN l_Start_Date AND l_End_Date));

Line 1107: FROM Gl_Period_Statuses

1103: (End_Date BETWEEN l_Start_Date AND l_End_Date));
1104:
1105: SELECT COUNT(*)
1106: INTO l_Closed_Period_Number
1107: FROM Gl_Period_Statuses
1108: WHERE ledger_id=p_ledger_id--Set_Of_Books_Id = l_Sob_Id,--updated by lyb
1109: AND Application_Id = 101
1110: AND ((Start_Date BETWEEN l_Start_Date AND l_End_Date) AND
1111: (End_Date BETWEEN l_Start_Date AND l_End_Date))