APPS.JL_CO_GL_MG_MEDIA_PKG dependencies on GL_PERIODS

Line 398: p_period_start IN gl_periods.period_num%TYPE,

394: (ERRBUF OUT NOCOPY VARCHAR2,
395: RETCODE OUT NOCOPY VARCHAR2,
396: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
397: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
398: p_period_start IN gl_periods.period_num%TYPE,
399: p_period_end IN gl_periods.period_num%TYPE,
400: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,
401: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE
402: ) IS

Line 399: p_period_end IN gl_periods.period_num%TYPE,

395: RETCODE OUT NOCOPY VARCHAR2,
396: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
397: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
398: p_period_start IN gl_periods.period_num%TYPE,
399: p_period_end IN gl_periods.period_num%TYPE,
400: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,
401: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE
402: ) IS
403:

Line 458: FROM gl_periods p,

454: WHERE t.set_of_books_id = sob1.set_of_books_id
455: AND nit.nit_id = t.nit_id
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

Line 548: FROM gl_periods p,

544: AND b1.period_year = p_reported_year
545: )
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

Line 1785: gl_periods p,

1781: WHERE reported_year = p_reported_year
1782: AND set_of_books_id = p_set_of_books_id
1783: AND EXISTS (SELECT 1
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