DBA Data[Home] [Help]

APPS.PA_RATE_PVT_PKG dependencies on GL_DATE_PERIOD_MAP

Line 3498: FROM gl_date_period_map glmaps

3494: AND glpersts.period_year = glper.period_year
3495: AND glpersts.application_id = PA_Period_Process_Pkg.Application_ID
3496: AND p_completion_date BETWEEN glper.start_date AND glper.end_date
3497: AND EXISTS ( SELECT NULL
3498: FROM gl_date_period_map glmaps
3499: WHERE glmaps.period_type = glper.period_type
3500: AND glmaps.period_name = glper.period_name
3501: AND glmaps.period_set_name = glper.period_set_name )
3502: AND EXISTS ( SELECT NULL

Line 3575: gl_date_period_map glmaps

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
3579: AND glpersts.set_of_books_id = gl.set_of_books_id

Line 3629: gl_date_period_map glmaps

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
3633: AND glpersts.set_of_books_id = gl.set_of_books_id