APPS.PA_BUDGET_ACCOUNT_PKG dependencies on GL_PERIOD_STATUSES

Line 1425: GL_Period_Statuses GLPRD,

1421: GLPRD.Period_Name PERIOD_NAME,
1422: GLPRD.Start_Date START_DATE,
1423: GLPRD.End_Date END_DATE
1424: FROM
1425: GL_Period_Statuses GLPRD,
1426: PA_Implementations IMP,
1427: PA_Resource_Assignments RA1
1428: WHERE
1429: GLPRD.Application_ID = PA_Period_Process_Pkg.Application_ID -- 101

Line 1449: GL_Period_Statuses GLPRD2,

1445: BL2.End_Date END_DATE
1446: FROM
1447: PA_Budget_Lines BL2,
1448: PA_Resource_Assignments RA2,
1449: GL_Period_Statuses GLPRD2,
1450: PA_Implementations IMP2
1451: WHERE
1452: RA2.Resource_Assignment_ID = BL2.Resource_Assignment_ID
1453: AND RA2.Project_ID = P_Project_ID

Line 1503: FROM gl_period_statuses gps

1499: SELECT gps.year_start_date,
1500: ADD_MONTHS (gps.year_start_date, 12 ) - 1
1501: INTO t_GL_Start_Date,
1502: t_GL_End_Date
1503: FROM gl_period_statuses gps
1504: WHERE gps.application_id = PA_Period_Process_Pkg.Application_ID
1505: AND gps.set_of_books_id = l_set_of_books_id
1506: AND l_BL_Max_Date BETWEEN gps.start_date AND gps.end_date
1507: AND gps.adjustment_period_flag = 'N';