APPS.PA_RATE_PVT_PKG dependencies on GL_LOOKUPS

Line 3641: FROM gl_lookups prsts

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
3641: FROM gl_lookups prsts
3642: WHERE prsts.lookup_code IN('C','F','N','O','P')
3643: AND prsts.lookup_type ='CLOSING_STATUS'
3644: AND glpersts.closing_status = prsts.lookup_code);
3645:

Line 3726: FROM gl_lookups prsts

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'
3729: AND glpersts.closing_status = prsts.lookup_code)
3730: GROUP BY glper.period_year,

Line 3780: FROM gl_lookups prsts

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'
3783: AND glpersts.closing_status = prsts.lookup_code)
3784: GROUP BY glper.period_year