eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RATE_PVT_PKG dependencies on PA_PERIOD_PROCESS_PKG

Line 3495: AND glpersts.application_id = PA_Period_Process_Pkg.Application_ID

3491: AND glpersts.set_of_books_id = gl.set_of_books_id
3492: AND glpersts.period_type = glper.period_type
3493: AND glpersts.period_name = glper.period_name
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

Line 3535: AND glp.application_id = Pa_Period_Process_Pkg.Application_id

3531: gl_period_statuses glp,
3532: pa_implementations paimp
3533: WHERE pap.gl_period_name = glp.period_name
3534: AND glp.set_of_books_id = paimp.set_of_books_id
3535: AND glp.application_id = Pa_Period_Process_Pkg.Application_id
3536: AND glp.adjustment_period_flag = 'N'
3537: AND p_completion_date BETWEEN pap.start_date and pap.end_date
3538: AND EXISTS (SELECT NULL
3539: FROM pa_lookups pal

Line 3586: AND glpersts.application_id = PA_Period_Process_Pkg.Application_ID

3582: AND glpersts.period_year = glper.period_year
3583: AND glmaps.period_type = glper.period_type
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'

Line 3640: AND glpersts.application_id = PA_Period_Process_Pkg.Application_ID

3636: AND glpersts.period_year = glper.period_year
3637: AND 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 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'