APPS.PA_RATE_PVT_PKG dependencies on GL_LOOKUPS

Line 3503: FROM gl_lookups prsts

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
3503: FROM gl_lookups prsts
3504: WHERE prsts.lookup_code IN('C','F','N','O','P')
3505: AND prsts.lookup_type ='CLOSING_STATUS'
3506: AND glpersts.closing_status = prsts.lookup_code);
3507:

Line 3588: FROM gl_lookups prsts

3584: AND glmaps.period_name = glper.period_name
3585: AND glmaps.period_set_name = glper.period_set_name
3586: AND glpersts.application_id = PA_Period_Process_Pkg.Application_ID
3587: AND EXISTS (SELECT null
3588: FROM gl_lookups prsts
3589: WHERE prsts.lookup_code IN('C','F','N','O','P')
3590: AND prsts.lookup_type ='CLOSING_STATUS'
3591: AND glpersts.closing_status = prsts.lookup_code)
3592: GROUP BY glper.period_year,

Line 3642: FROM gl_lookups prsts

3638: AND glmaps.period_name = glper.period_name
3639: AND glmaps.period_set_name = glper.period_set_name
3640: AND glpersts.application_id = PA_Period_Process_Pkg.Application_ID
3641: AND EXISTS (SELECT null
3642: FROM gl_lookups prsts
3643: WHERE prsts.lookup_code IN('C','F','N','O','P')
3644: AND prsts.lookup_type ='CLOSING_STATUS'
3645: AND glpersts.closing_status = prsts.lookup_code)
3646: GROUP BY glper.period_year