APPS.PA_ACCUM_UTILS dependencies on PA_IMPLEMENTATIONS

Line 160: -- in PA_IMPLEMENTATIONS table . Returns whether

156: RAISE ;
157: End proj_level_record;
158:
159: -- Get_Impl_Option - This returns the Accumulation option as specified
160: -- in PA_IMPLEMENTATIONS table . Returns whether
161: -- accumulation is maintained by PA_PERIOD or GL_PERIOD
162:
163: Procedure Get_Impl_Option (x_impl_option Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
164: x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895

Line 182: FROM pa_implementations;

178: END IF;
179:
180: SELECT accumulation_period_type
181: INTO x_impl_option
182: FROM pa_implementations;
183:
184: -- Restore the old x_err_stack;
185: x_err_stack := V_Old_Stack;
186:

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 487: GL_PERIOD_STATUSES gps, pa_implementations imp

483: DISTINCT YEAR_START_DATE
484: INTO
485: x_period_yr_start_date
486: FROM
487: GL_PERIOD_STATUSES gps, pa_implementations imp
488: WHERE gps.application_id = pa_period_process_pkg.application_id
489: and gps.set_of_books_id = imp.set_of_books_id
490: and gps.period_name = x_current_gl_period;
491:

Line 1258: , PA_IMPLEMENTATIONS PAIMP

1254: FROM PA_TXN_ACCUM PTA
1255: , PA_RESOURCE_ACCUM_DETAILS PRAD
1256: , PA_PERIODS PAP
1257: , GL_PERIOD_STATUSES GLP
1258: , PA_IMPLEMENTATIONS PAIMP
1259: WHERE PRAD.PROJECT_ID = x_project_id
1260: AND PRAD.RESOURCE_LIST_ID = x_resource_list_id
1261: AND PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
1262: AND PRAD.PROJECT_ID = PTA.PROJECT_ID

Line 1284: , PA_IMPLEMENTATIONS PAIMP

1280: ,PTA.TOT_REVENUE tot_revenue
1281: FROM PA_TXN_ACCUM PTA
1282: , PA_RESOURCE_ACCUM_DETAILS PRAD
1283: , GL_PERIOD_STATUSES GLP
1284: , PA_IMPLEMENTATIONS PAIMP
1285: WHERE PRAD.PROJECT_ID = x_project_id
1286: AND PRAD.RESOURCE_LIST_ID = x_resource_list_id
1287: AND PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
1288: AND PRAD.PROJECT_ID = PTA.PROJECT_ID

Line 1308: , PA_IMPLEMENTATIONS PAIMP

1304: FROM PA_TXN_ACCUM PTA
1305: , PA_RESOURCE_ACCUM_DETAILS PRAD
1306: , PA_PERIODS PAP
1307: , GL_PERIOD_STATUSES GLP
1308: , PA_IMPLEMENTATIONS PAIMP
1309: WHERE PRAD.PROJECT_ID = x_project_id
1310: AND PRAD.RESOURCE_LIST_ID = x_resource_list_id
1311: AND PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
1312: AND PRAD.PROJECT_ID = PTA.PROJECT_ID

Line 1448: from PA_PERIODS_V pav, pa_implementations pai

1444: -- Return the end date of the passed period and set the global variable
1445: select decode( pai.accumulation_period_type, 'PA', pav.pa_end_date,
1446: 'GL', pav.gl_end_date )
1447: into lcl_end_date
1448: from PA_PERIODS_V pav, pa_implementations pai
1449: where period_name = x_period_name;
1450:
1451: pa_accum_utils.g_check_reporting_end_date := lcl_end_date;
1452:

Line 1470: -- from PA_PERIODS_V pav, pa_implementations pai

1466: --Replaced the pa_periods_v with the view definition
1467: -- select decode( pai.accumulation_period_type, 'PA', pav.pa_end_date,
1468: -- 'GL', pav.gl_end_date )
1469: -- into lcl_end_date
1470: -- from PA_PERIODS_V pav, pa_implementations pai
1471: -- where current_pa_period_flag = 'Y';
1472: select decode(paimp.accumulation_period_type, 'PA', pap.end_date,
1473: 'GL', glp.end_date)
1474: into lcl_end_date

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'