DBA Data[Home] [Help]

APPS.JL_CO_GL_MG_MEDIA_PKG dependencies on GL_PERIOD_SETS

Line 517: gl_period_sets ps,

513: AND sob1.set_of_books_id = p_set_of_books_id
514: AND t.period_name IN (SELECT p.period_name
515: FROM gl_periods p,
516: gl_period_types pt,
517: gl_period_sets ps,
518: gl_sets_of_books sob2
519: WHERE p.period_year = p_reported_year
520: AND p.period_num BETWEEN p_period_start
521: AND p_period_end

Line 607: gl_period_sets ps,

603: AND b.period_name IN
604: (SELECT p.period_name
605: FROM gl_periods p,
606: gl_period_types pt,
607: gl_period_sets ps,
608: gl_sets_of_books sob2
609: WHERE p.period_year = p_reported_year
610: AND p.period_num BETWEEN p_period_start
611: AND p_period_end

Line 1895: gl_period_sets ps,

1891: FROM gl_period_statuses stat,
1892: gl_periods p,
1893: gl_sets_of_books sob,
1894: gl_period_types pt,
1895: gl_period_sets ps,
1896: fnd_application a
1897: WHERE a.application_short_name = 'SQLGL'
1898: AND stat.application_id = a.application_id
1899: AND stat.closing_status = 'P'