APPS.OKL_ACCOUNTING_UTIL dependencies on GL_PERIODS

Line 490: FROM gl_periods

486: WHERE ledger_id = l_ledger_id;
487:
488: CURSOR prd_name_csr (l_period_set_name VARCHAR2, l_user_period_type VARCHAR2) IS
489: SELECT period_name, start_date, end_date
490: FROM gl_periods
491: WHERE TRUNC(start_date) <= TRUNC(p_date)
492: AND TRUNC(end_date) >= TRUNC(p_date)
493: AND period_set_name = l_period_set_name
494: AND period_type = l_user_period_type

Line 540: FROM gl_periods

536: WHERE ledger_id = l_ledger_id;
537:
538: CURSOR perd_dt_csr (l_period_set_name VARCHAR2, l_user_period_type VARCHAR2) IS
539: SELECT start_date, end_date
540: FROM gl_periods
541: WHERE period_name = p_period_name
542: AND period_set_name = l_period_set_name
543: AND period_type = l_user_period_type;
544:

Line 2760: l_period_name gl_periods.period_name%TYPE;

2756: AND closing_status IN ('F','O')
2757: AND TRUNC(start_date) >= TRUNC(p_gl_date)
2758: AND adjustment_period_flag = 'N' ;
2759:
2760: l_period_name gl_periods.period_name%TYPE;
2761: l_start_date DATE;
2762: l_end_date DATE;
2763: l_dummy_date DATE := NULL;
2764: l_period_status gl_period_statuses.closing_status%TYPE;