DBA Data[Home] [Help]

APPS.PA_ACCUM_UTILS dependencies on PA_LOOKUPS

Line 256: PA_IMPLEMENTATIONS PAIMP, PA_LOOKUPS PAL

252: x_current_gl_start_date,
253: x_current_gl_end_date,
254: x_current_year
255: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,
256: PA_IMPLEMENTATIONS PAIMP, PA_LOOKUPS PAL
257: WHERE PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
258: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
259: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id
260: AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'

Line 1476: PA_IMPLEMENTATIONS PAIMP, PA_LOOKUPS PAL

1472: select decode(paimp.accumulation_period_type, 'PA', pap.end_date,
1473: 'GL', glp.end_date)
1474: into lcl_end_date
1475: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,
1476: PA_IMPLEMENTATIONS PAIMP, PA_LOOKUPS PAL
1477: WHERE PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
1478: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
1479: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id
1480: AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'