APPS.JL_CO_GL_MG_MEDIA_PKG dependencies on GL_PERIODS

Line 452: p_period_start IN gl_periods.period_num%TYPE,

448: (ERRBUF OUT NOCOPY VARCHAR2,
449: RETCODE OUT NOCOPY VARCHAR2,
450: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
451: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
452: p_period_start IN gl_periods.period_num%TYPE,
453: p_period_end IN gl_periods.period_num%TYPE,
454: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,
455: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE
456: ) IS

Line 453: p_period_end IN gl_periods.period_num%TYPE,

449: RETCODE OUT NOCOPY VARCHAR2,
450: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
451: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
452: p_period_start IN gl_periods.period_num%TYPE,
453: p_period_end IN gl_periods.period_num%TYPE,
454: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,
455: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE
456: ) IS
457:

Line 515: FROM gl_periods p,

511: WHERE NIT.NIT_ID = T.NIT_ID)
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

Line 605: FROM gl_periods p,

601: AND b1.period_year = p_reported_year
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

Line 1892: gl_periods p,

1888: WHERE reported_year = p_reported_year
1889: AND set_of_books_id = p_set_of_books_id
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