DBA Data[Home] [Help]

APPS.PA_BUDGET_ACCOUNT_PKG dependencies on PA_PERIOD_PROCESS_PKG

Line 1429: GLPRD.Application_ID = PA_Period_Process_Pkg.Application_ID -- 101

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
1430: AND GLPRD.Set_Of_Books_ID = IMP.Set_Of_Books_ID
1431: AND GLPRD.Closing_status IN ('O','F')
1432: AND ( l_GL_Start_Date BETWEEN GLPRD.Start_Date AND GLPRD.End_Date OR
1433: l_GL_End_Date BETWEEN GLPRD.Start_Date AND GLPRD.End_Date OR

Line 1456: AND GLPRD2.Application_ID = PA_Period_Process_Pkg.Application_ID -- 101

1452: RA2.Resource_Assignment_ID = BL2.Resource_Assignment_ID
1453: AND RA2.Project_ID = P_Project_ID
1454: AND RA2.Budget_Version_ID = p_Budget_Version_ID
1455: AND GLPRD2.Period_Name = BL2.Period_Name
1456: AND GLPRD2.Application_ID = PA_Period_Process_Pkg.Application_ID -- 101
1457: AND GLPRD2.Closing_status IN ('O','F')
1458: AND GLPRD2.Adjustment_Period_Flag <> 'Y' -- Bug #1891179
1459: AND GLPRD2.Set_Of_Books_ID = IMP2.Set_Of_Books_ID ;
1460:

Line 1504: WHERE gps.application_id = PA_Period_Process_Pkg.Application_ID

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';
1508: