DBA Data[Home] [Help]

APPS.PA_FI_AMT_CALC_PKG dependencies on GL_PERIODS

Line 950: SELECT Start_Date INTO l_curr_process_start_date FROM Gl_Periods

946: FOR opt_rec IN Fcst_Options LOOP
947: IF opt_rec.ORG_FCST_PERIOD_TYPE = 'PA' AND
948: opt_rec.START_PERIOD_NAME IS NOT NULL THEN
949: BEGIN
950: SELECT Start_Date INTO l_curr_process_start_date FROM Gl_Periods
951: WHERE Period_Set_Name = opt_rec.Period_Set_Name AND
952: Period_Type = opt_rec.Pa_Period_Type AND
953: Period_Name = opt_rec.START_PERIOD_NAME AND
954: ADJUSTMENT_PERIOD_FLAG = 'N';

Line 972: SELECT Start_Date INTO l_curr_process_start_date FROM Gl_Periods

968: END;
969: ELSIF opt_rec.ORG_FCST_PERIOD_TYPE = 'GL' AND
970: opt_rec.START_PERIOD_NAME IS NOT NULL THEN
971: BEGIN
972: SELECT Start_Date INTO l_curr_process_start_date FROM Gl_Periods
973: WHERE Period_Set_Name = opt_rec.Period_Set_Name AND
974: Period_Type = opt_rec.Accounted_Period_Type AND
975: Period_Name = opt_rec.START_PERIOD_NAME AND
976: ADJUSTMENT_PERIOD_FLAG = 'N';