APPS.PA_RATE_PVT_PKG dependencies on GL_PERIODS

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

3441: PROCEDURE get_rep_period_dates(
3442: p_period_type IN VARCHAR2 ,
3443: p_completion_date IN DATE,
3444: x_period_year OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3445: x_period_name OUT NOCOPY gl_periods.period_name%TYPE, --File.Sql.39 bug 4440895
3446: x_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
3447: x_end_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
3448: x_error_value OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3449: )

Line 3453: l_period_name gl_periods.period_name%TYPE;

3449: )
3450: IS
3451:
3452: l_period_year NUMBER;
3453: l_period_name gl_periods.period_name%TYPE;
3454: l_start_date DATE;
3455: l_end_date DATE;
3456:
3457: BEGIN

Line 3486: gl_periods glper,

3482: l_start_date,
3483: l_end_date
3484: FROM pa_implementations imp,
3485: gl_sets_of_books gl,
3486: gl_periods glper,
3487: gl_period_statuses glpersts
3488: WHERE imp.set_of_books_id = gl.set_of_books_id
3489: AND gl.period_set_name = glper.period_set_name
3490: AND gl.accounted_period_type = glper.period_type

Line 3573: gl_periods glper,

3569: MIN(glper.start_date) start_dt,
3570: MAX(glper.end_date) end_dt
3571: FROM pa_implementations imp,
3572: gl_sets_of_books gl,
3573: gl_periods glper,
3574: gl_period_statuses glpersts,
3575: gl_date_period_map glmaps
3576: WHERE imp.set_of_books_id = gl.set_of_books_id
3577: AND gl.period_set_name = glper.period_set_name

Line 3627: gl_periods glper,

3623: MIN(glper.start_date) start_dt,
3624: MAX(glper.end_date) end_dt
3625: FROM pa_implementations imp,
3626: gl_sets_of_books gl,
3627: gl_periods glper,
3628: gl_period_statuses glpersts,
3629: gl_date_period_map glmaps
3630: WHERE imp.set_of_books_id = gl.set_of_books_id
3631: AND gl.period_set_name = glper.period_set_name