DBA Data[Home] [Help]

APPS.JL_CO_GL_MG_MEDIA_PKG dependencies on GL_PERIOD_SETS

Line 460: gl_period_sets ps,

456: AND sob1.set_of_books_id = p_set_of_books_id
457: AND t.period_name IN (SELECT p.period_name
458: FROM gl_periods p,
459: gl_period_types pt,
460: gl_period_sets ps,
461: gl_sets_of_books sob2
462: WHERE p.period_year = p_reported_year
463: AND p.period_num BETWEEN p_period_start
464: AND p_period_end

Line 550: gl_period_sets ps,

546: AND b.period_name IN
547: (SELECT p.period_name
548: FROM gl_periods p,
549: gl_period_types pt,
550: gl_period_sets ps,
551: gl_sets_of_books sob2
552: WHERE p.period_year = p_reported_year
553: AND p.period_num BETWEEN p_period_start
554: AND p_period_end

Line 1788: gl_period_sets ps,

1784: FROM gl_period_statuses stat,
1785: gl_periods p,
1786: gl_sets_of_books sob,
1787: gl_period_types pt,
1788: gl_period_sets ps,
1789: fnd_application a
1790: WHERE a.application_short_name = 'SQLGL'
1791: AND stat.application_id = a.application_id
1792: AND stat.closing_status = 'P'