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 303: FROM GL_Period_Statuses A

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

Line 1473: GL_Period_Statuses PSTS

1469: X_Cur_Yr_First_Prd_Start_Dt,
1470: X_Cur_Yr_Last_Prd_Start_Dt,
1471: X_Cur_Yr_Last_Prd_End_Dt
1472: FROM
1473: GL_Period_Statuses PSTS
1474: WHERE
1475: PSTS.application_id = 101
1476: AND PSTS.set_of_books_id = P_Set_Of_Books_ID
1477: AND PSTS.Period_Year = P_Fiscal_year

Line 1496: GL_Period_Statuses PSTS

1492: INTO
1493: X_Next_Yr_First_Prd_Start_Dt,
1494: X_Next_Yr_First_Prd_End_Dt
1495: FROM
1496: GL_Period_Statuses PSTS
1497: WHERE
1498: PSTS.application_id = 101 -- = 8721 ?
1499: AND PSTS.set_of_books_id = P_Set_Of_Books_ID
1500: AND PSTS.Period_Year = P_Fiscal_year + 1

Line 1517: GL_Period_Statuses GS

1513: GS.Period_Name
1514: INTO
1515: X_Cur_Yr_Last_Prd_Name
1516: FROM
1517: GL_Period_Statuses GS
1518: WHERE
1519: GS.Set_Of_Books_ID = P_Set_Of_Books_ID
1520: AND GS.Application_ID = 101
1521: AND GS.Closing_Status = 'O'

Line 1553: GL_Period_Statuses GS

1549: GS.Period_Name
1550: INTO
1551: X_Next_Yr_First_Prd_Name
1552: FROM
1553: GL_Period_Statuses GS
1554: WHERE
1555: GS.Set_Of_Books_ID = P_Set_Of_Books_ID
1556: AND GS.Application_ID = 101
1557: AND GS.Closing_Status IN ('O', 'F')