DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on PA_PERIOD_PROCESS_PKG

Line 2101: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id

2097: PA_LOOKUPS PAL
2098: WHERE PAP.period_name = p_period_name
2099: AND PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
2100: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
2101: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id
2102: AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'
2103: AND GLP.CLOSING_STATUS = PAL.LOOKUP_CODE /*Added for bug 5484203*/
2104: AND PAL.LOOKUP_TYPE = 'CLOSING STATUS';
2105:

Line 2260: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id

2256: PA_LOOKUPS PAL
2257: WHERE PAP.period_name = p_period_name
2258: AND PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
2259: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
2260: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id
2261: AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'
2262: AND PAL.LOOKUP_TYPE = 'CLOSING STATUS';
2263:
2264: ELSIF (p_period_type = 'YR') THEN