APPS.PA_RATE_PVT_PKG dependencies on GL_PERIODS

Line 3583: x_period_name OUT NOCOPY gl_periods.period_name%TYPE, --File.Sql.39 bug 4440895

3579: PROCEDURE get_rep_period_dates(
3580: p_period_type IN VARCHAR2 ,
3581: p_completion_date IN DATE,
3582: x_period_year OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3583: x_period_name OUT NOCOPY gl_periods.period_name%TYPE, --File.Sql.39 bug 4440895
3584: x_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
3585: x_end_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
3586: x_error_value OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3587: )

Line 3591: l_period_name gl_periods.period_name%TYPE;

3587: )
3588: IS
3589:
3590: l_period_year NUMBER;
3591: l_period_name gl_periods.period_name%TYPE;
3592: l_start_date DATE;
3593: l_end_date DATE;
3594:
3595: BEGIN

Line 3624: gl_periods glper,

3620: l_start_date,
3621: l_end_date
3622: FROM pa_implementations imp,
3623: gl_sets_of_books gl,
3624: gl_periods glper,
3625: gl_period_statuses glpersts
3626: WHERE imp.set_of_books_id = gl.set_of_books_id
3627: AND gl.period_set_name = glper.period_set_name
3628: AND gl.accounted_period_type = glper.period_type

Line 3711: gl_periods glper,

3707: MIN(glper.start_date) start_dt,
3708: MAX(glper.end_date) end_dt
3709: FROM pa_implementations imp,
3710: gl_sets_of_books gl,
3711: gl_periods glper,
3712: gl_period_statuses glpersts,
3713: gl_date_period_map glmaps
3714: WHERE imp.set_of_books_id = gl.set_of_books_id
3715: AND gl.period_set_name = glper.period_set_name

Line 3765: gl_periods glper,

3761: MIN(glper.start_date) start_dt,
3762: MAX(glper.end_date) end_dt
3763: FROM pa_implementations imp,
3764: gl_sets_of_books gl,
3765: gl_periods glper,
3766: gl_period_statuses glpersts,
3767: gl_date_period_map glmaps
3768: WHERE imp.set_of_books_id = gl.set_of_books_id
3769: AND gl.period_set_name = glper.period_set_name