1490: SELECT start_date,
1491: end_date
1492: INTO beg_date,
1493: close_date
1494: FROM gl_period_statuses
1495: WHERE period_year = g_period_year
1496: AND period_num = g_period_num
1497: AND application_id =101
1498: AND set_of_books_id = g_ledger_id;
3059: WHERE set_of_books_id = g_ledger_id
3060: AND period_year = g_period_year
3061: AND period_num = g_period_num;
3062: -- Getting the
3063: /*select period_name into l_period_name from gl_period_statuses
3064: where period_name = p_rep_fiscal_yr and period_num = p_period_num
3065: and application_id=101 and set_of_books_id = p_ledger_id;*/
3066: --fnd_file.put_line(fnd_file.log , '**********************l_rec_exists ::'||l_rec_exists);
3067: IF (l_rec_exists = 1) THEN