DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on PA_PERIOD_PROCESS_PKG

Line 2218: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id

2214: PA_LOOKUPS PAL
2215: WHERE PAP.period_name = p_period_name
2216: AND PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
2217: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
2218: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id
2219: AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'
2220: AND GLP.CLOSING_STATUS = PAL.LOOKUP_CODE /*Added for bug 5484203*/
2221: AND PAL.LOOKUP_TYPE = 'CLOSING STATUS';
2222:

Line 2377: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id

2373: PA_LOOKUPS PAL
2374: WHERE PAP.period_name = p_period_name
2375: AND PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
2376: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
2377: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id
2378: AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'
2379: AND PAL.LOOKUP_TYPE = 'CLOSING STATUS';
2380:
2381: ELSIF (p_period_type = 'YR') THEN