APPS.OKL_ACCOUNTING_UTIL dependencies on GL_PERIODS

Line 491: FROM gl_periods

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

Line 541: FROM gl_periods

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

Line 2762: l_period_name gl_periods.period_name%TYPE;

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