[Home] [Help]
3629: AND glpersts.set_of_books_id = gl.set_of_books_id
3630: AND glpersts.period_type = glper.period_type
3631: AND glpersts.period_name = glper.period_name
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
3669: gl_period_statuses glp,
3670: pa_implementations paimp
3671: WHERE pap.gl_period_name = glp.period_name
3672: AND glp.set_of_books_id = paimp.set_of_books_id
3673: AND glp.application_id = Pa_Period_Process_Pkg.Application_id
3674: AND glp.adjustment_period_flag = 'N'
3675: AND p_completion_date BETWEEN pap.start_date and pap.end_date
3676: AND EXISTS (SELECT NULL
3677: FROM pa_lookups pal
3720: AND glpersts.period_year = glper.period_year
3721: AND glmaps.period_type = glper.period_type
3722: AND glmaps.period_name = glper.period_name
3723: AND glmaps.period_set_name = glper.period_set_name
3724: AND glpersts.application_id = PA_Period_Process_Pkg.Application_ID
3725: AND EXISTS (SELECT null
3726: FROM gl_lookups prsts
3727: WHERE prsts.lookup_code IN('C','F','N','O','P')
3728: AND prsts.lookup_type ='CLOSING_STATUS'
3774: AND glpersts.period_year = glper.period_year
3775: AND glmaps.period_type = glper.period_type
3776: AND glmaps.period_name = glper.period_name
3777: AND glmaps.period_set_name = glper.period_set_name
3778: AND glpersts.application_id = PA_Period_Process_Pkg.Application_ID
3779: AND EXISTS (SELECT null
3780: FROM gl_lookups prsts
3781: WHERE prsts.lookup_code IN('C','F','N','O','P')
3782: AND prsts.lookup_type ='CLOSING_STATUS'