APPS.PN_CREATE_ACC dependencies on GL_PERIODS

Line 212: FROM gl_periods

208: WHERE ledger_id = l_ledger_id;
209:
210: CURSOR prd_name_csr (l_period_set_name VARCHAR2, l_user_period_type VARCHAR2) IS
211: SELECT period_name, start_date, end_date
212: FROM gl_periods
213: WHERE TRUNC(start_date) <= TRUNC(p_date)
214: AND TRUNC(end_date) >= TRUNC(p_date)
215: AND period_set_name = l_period_set_name
216: AND period_type = l_user_period_type

Line 316: l_period_name gl_periods.period_name%TYPE;

312: AND closing_status IN ('F','O')
313: AND TRUNC(start_date) >= TRUNC(p_gl_date)
314: AND adjustment_period_flag = 'N' ;
315:
316: l_period_name gl_periods.period_name%TYPE;
317: l_start_date DATE;
318: l_end_date DATE;
319: l_dummy_date DATE := NULL;
320: l_period_status gl_period_statuses.closing_status%TYPE;