APPS.GL_BIS_ALERTS_PKG dependencies on GL_PERIODS

Line 90: FROM gl_periods p

86: SELECT p.period_num,
87: p.period_year
88: INTO g_period_num,
89: g_period_year
90: FROM gl_periods p
91: WHERE period_set_name = g_period_set_name
92: AND period_name = g_period_name;
93:
94: END get_period_info;

Line 792: gl_periods per

788: -- Get current period information
789: SELECT per.period_set_name || '+' || per.period_name
790: INTO l_period_id
791: FROM gl_sets_of_books sob,
792: gl_periods per
793: WHERE sob.set_of_books_id = p_sob_id
794: AND per.period_set_name = sob.period_set_name
795: AND per.period_type = sob.accounted_period_type
796: AND trunc(sysdate) between per.start_date and per.end_date

Line 941: gl_periods per

937: -- Get current period information
938: SELECT per.period_set_name || '+' || per.period_name
939: INTO l_period_id
940: FROM gl_sets_of_books sob,
941: gl_periods per
942: WHERE sob.set_of_books_id = to_number(p_target_rec.org_level_value_id)
943: AND per.period_set_name = sob.period_set_name
944: AND per.period_type = sob.accounted_period_type
945: AND trunc(sysdate) between per.start_date and per.end_date