DBA Data[Home] [Help]

APPS.IGI_BUD dependencies on GL_PERIODS

Line 248: FROM GL_PERIODS gp

244: INTO p_start_period_number
245: , p_period_year
246: , p_period_set_name
247: , p_period_type
248: FROM GL_PERIODS gp
249: , GL_SETS_OF_BOOKS gsob
250: WHERE gsob.SET_OF_BOOKS_ID = p_sob_id
251: AND gp.PERIOD_SET_NAME = gsob.PERIOD_SET_NAME
252: AND gp.PERIOD_NAME = p_start_period;

Line 257: FROM GL_PERIODS gp

253:
254: FOR period IN periods LOOP
255: SELECT gp.PERIOD_NAME
256: INTO p_period_name
257: FROM GL_PERIODS gp
258: WHERE gp.PERIOD_SET_NAME = p_period_set_name
259: AND gp.PERIOD_YEAR = p_period_year
260: AND gp.PERIOD_TYPE = p_period_type
261: AND gp.PERIOD_NUM = period.period_number;