DBA Data[Home] [Help]

APPS.JL_CO_GL_MG_MEDIA_PKG dependencies on GL_PERIOD_TYPES

Line 516: gl_period_types pt,

512: -- bug 9384107
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

Line 606: gl_period_types pt,

602: )
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

Line 1894: gl_period_types pt,

1890: AND EXISTS (SELECT 1
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