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.PA_YEAR_END_ROLLOVER_PKG dependencies on GL_PERIOD_STATUSES

Line 302: FROM GL_Period_Statuses A

298: AND BCBL.Start_Date BETWEEN l_Cur_Yr_First_Prd_Start_Dt
299: AND l_Cur_Yr_Last_Prd_Start_Dt
300: AND BCBL.Set_Of_Books_ID = l_Set_Of_Books_ID
301: AND BCBL.Start_Date IN ( SELECT A.Start_Date
302: FROM GL_Period_Statuses A
303: WHERE
304: A.application_id = 101
305: AND A.set_of_books_id = l_Set_Of_Books_ID
306: AND A.Period_Year = P_Closing_year

Line 1416: GL_Period_Statuses PSTS

1412: X_Cur_Yr_First_Prd_Start_Dt,
1413: X_Cur_Yr_Last_Prd_Start_Dt,
1414: X_Cur_Yr_Last_Prd_End_Dt
1415: FROM
1416: GL_Period_Statuses PSTS
1417: WHERE
1418: PSTS.application_id = 101
1419: AND PSTS.set_of_books_id = P_Set_Of_Books_ID
1420: AND PSTS.Period_Year = P_Fiscal_year

Line 1439: GL_Period_Statuses PSTS

1435: INTO
1436: X_Next_Yr_First_Prd_Start_Dt,
1437: X_Next_Yr_First_Prd_End_Dt
1438: FROM
1439: GL_Period_Statuses PSTS
1440: WHERE
1441: PSTS.application_id = 101 -- = 8721 ?
1442: AND PSTS.set_of_books_id = P_Set_Of_Books_ID
1443: AND PSTS.Period_Year = P_Fiscal_year + 1

Line 1460: GL_Period_Statuses GS

1456: GS.Period_Name
1457: INTO
1458: X_Cur_Yr_Last_Prd_Name
1459: FROM
1460: GL_Period_Statuses GS
1461: WHERE
1462: GS.Set_Of_Books_ID = P_Set_Of_Books_ID
1463: AND GS.Application_ID = 101
1464: AND GS.Closing_Status = 'O'

Line 1496: GL_Period_Statuses GS

1492: GS.Period_Name
1493: INTO
1494: X_Next_Yr_First_Prd_Name
1495: FROM
1496: GL_Period_Statuses GS
1497: WHERE
1498: GS.Set_Of_Books_ID = P_Set_Of_Books_ID
1499: AND GS.Application_ID = 101
1500: AND GS.Closing_Status IN ('O', 'F')