APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on GL_PERIODS

Line 491: FROM gl_periods

487: BEGIN
488:
489: SELECT start_date, end_date
490: INTO g_start_date,g_end_date
491: FROM gl_periods
492: WHERE period_name = p_period_name
493: AND period_set_name = g_period_set_name;
494:
495: g_period_name := p_period_name;

Line 526: FROM gl_periods

522: g_end_date := to_date(p_end_date,l_icx_format_mask);
523:
524: SELECT period_name
525: INTO g_period_name
526: FROM gl_periods
527: WHERE period_set_name = g_period_set_name
528: AND period_type = g_accounted_period_type
529: AND g_start_date BETWEEN start_date AND end_date
530: AND g_end_date BETWEEN start_date AND end_date;

Line 558: FROM gl_periods

554:
555: BEGIN
556: SELECT start_date, end_date
557: INTO g_adjustment_period_start_date,g_adjustment_period_end_date
558: FROM gl_periods
559: WHERE period_name = p_adjustment_period_name
560: AND period_set_name = g_period_set_name
561: AND adjustment_period_flag = 'Y';
562:

Line 7363: FROM gl_periods gp,

7359: IF g_special_situation_indicator IS NOT NULL THEN
7360:
7361: SELECT COUNT(*)
7362: INTO l_cnt
7363: FROM gl_periods gp,
7364: gl_ledgers gl
7365: WHERE gp.period_set_name = gl.period_set_name
7366: AND gl.ledger_id = g_ledger_id
7367: AND g_start_date >= gp.start_date