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
3491: AND glpersts.set_of_books_id = gl.set_of_books_id
3527: l_period_name,
3528: l_start_date,
3529: l_end_date
3530: FROM pa_periods pap,
3531: gl_period_statuses glp,
3532: pa_implementations paimp
3533: WHERE pap.gl_period_name = glp.period_name
3534: AND glp.set_of_books_id = paimp.set_of_books_id
3535: AND glp.application_id = Pa_Period_Process_Pkg.Application_id
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
3578: AND gl.accounted_period_type = glper.period_type
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
3632: AND gl.accounted_period_type = glper.period_type