DBA Data[Home] [Help]

APPS.PA_RATE_PVT_PKG dependencies on GL_DATE_PERIOD_MAP

Line 3636: FROM gl_date_period_map glmaps

3632: AND glpersts.period_year = glper.period_year
3633: AND glpersts.application_id = PA_Period_Process_Pkg.Application_ID
3634: AND p_completion_date BETWEEN glper.start_date AND glper.end_date
3635: AND EXISTS ( SELECT NULL
3636: FROM gl_date_period_map glmaps
3637: WHERE glmaps.period_type = glper.period_type
3638: AND glmaps.period_name = glper.period_name
3639: AND glmaps.period_set_name = glper.period_set_name )
3640: AND EXISTS ( SELECT NULL

Line 3713: gl_date_period_map glmaps

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
3716: AND gl.accounted_period_type = glper.period_type
3717: AND glpersts.set_of_books_id = gl.set_of_books_id

Line 3767: gl_date_period_map glmaps

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
3770: AND gl.accounted_period_type = glper.period_type
3771: AND glpersts.set_of_books_id = gl.set_of_books_id