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_ACCUM_UTILS dependencies on PA_PERIODS

Line 234: FROM pa_periods_v

230: x_current_pa_end_date,
231: x_current_gl_start_date,
232: x_current_gl_end_date,
233: x_current_year
234: FROM pa_periods_v
235: WHERE
236: current_pa_period_flag = 'Y';
237: */
238:

Line 239: /* Replaced the query from pa_periods_v with the view definition Bug #2634995*/

235: WHERE
236: current_pa_period_flag = 'Y';
237: */
238:
239: /* Replaced the query from pa_periods_v with the view definition Bug #2634995*/
240: SELECT pap.period_name,
241: pap.gl_period_name,
242: pap.start_date,
243: pap.end_date,

Line 255: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,

251: x_current_pa_end_date,
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

Line 339: PA_PERIODS_V

335: x_prev_pa_year,
336: x_prev_pa_start_date,
337: x_prev_pa_end_date
338: FROM
339: PA_PERIODS_V
340: WHERE pa_start_date =
341: (SELECT max(start_date)
342: FROM
343: pa_periods

Line 343: pa_periods

339: PA_PERIODS_V
340: WHERE pa_start_date =
341: (SELECT max(start_date)
342: FROM
343: pa_periods
344: WHERE start_date < x_current_pa_start_date);
345:
346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN

Line 375: pa_periods_v

371: x_prev_gl_year,
372: x_prev_gl_start_date,
373: x_prev_gl_end_date
374: FROM
375: pa_periods_v
376: WHERE
377: gl_start_date =
378: (SELECT max(gl_start_date)
379: FROM pa_periods_v

Line 379: FROM pa_periods_v

375: pa_periods_v
376: WHERE
377: gl_start_date =
378: (SELECT max(gl_start_date)
379: FROM pa_periods_v
380: WHERE
381: gl_start_date < x_current_gl_start_date);
382:
383: EXCEPTION

Line 405: PA_PERIODS_V WHERE Period_name = x_prev_accum_period;

401: If x_impl_opt = 'PA' Then
402: Select PERIOD_YEAR,PA_START_DATE,PA_END_DATE
403: into x_prev_accum_year,x_prev_accum_start_date,
404: x_prev_accum_end_date from
405: PA_PERIODS_V WHERE Period_name = x_prev_accum_period;
406: Elsif
407: x_impl_opt = 'GL' Then
408: Select Distinct PERIOD_YEAR,GL_START_DATE,GL_END_DATE
409: into x_prev_accum_year,x_prev_accum_start_date,

Line 411: PA_PERIODS_V WHERE Gl_Period_name = x_prev_accum_period;

407: x_impl_opt = 'GL' Then
408: Select Distinct PERIOD_YEAR,GL_START_DATE,GL_END_DATE
409: into x_prev_accum_year,x_prev_accum_start_date,
410: x_prev_accum_end_date from
411: PA_PERIODS_V WHERE Gl_Period_name = x_prev_accum_period;
412: End If;
413:
414: EXCEPTION
415: WHEN NO_DATA_FOUND THEN

Line 430: pa_periods_v

426: SELECT DISTINCT
427: DECODE(x_impl_opt,'PA',PERIOD_NAME,'GL',GL_PERIOD_NAME,PERIOD_NAME)
428: INTO x_prev_prev_accum_period
429: FROM
430: pa_periods_v
431: WHERE
432: DECODE(x_impl_opt,
433: 'PA',pa_start_date,'GL',gl_start_date,pa_start_date) =
434: (SELECT max(DECODE(

Line 437: FROM pa_periods_v

433: 'PA',pa_start_date,'GL',gl_start_date,pa_start_date) =
434: (SELECT max(DECODE(
435: x_impl_opt,'PA',pa_start_date,
436: 'GL',gl_start_date,pa_start_date))
437: FROM pa_periods_v
438: WHERE
439: DECODE(x_impl_opt,
440: 'PA',pa_start_date,'GL',gl_start_date,pa_start_date)
441: < x_prev_accum_start_date);

Line 1220: -- 2) decomposed pa_periods_v; removed pa_lookup

1216: -- 01-FEB-01 jwhite Bug 1614284: Performance Fix for
1217: -- CURSOR selresaccums:
1218: -- 1) Added the following join
1219: -- AND PRAD.PROJECT_ID = PTA.PROJECT_ID
1220: -- 2) decomposed pa_periods_v; removed pa_lookup
1221: -- join.
1222: -- 24-JUL-02 rravipat Bug 2331201: Extended the procedure to use it for
1223: -- Financial Planning.Included fnctionality forthe case
1224: -- x_amount_type = 'A' which corresponds to a finplan

Line 1256: , PA_PERIODS PAP

1252: ,PTA.TOT_QUANTITY tot_quantity
1253: ,PTA.TOT_REVENUE tot_revenue
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

Line 1306: , PA_PERIODS PAP

1302: ,PTA.TOT_QUANTITY tot_quantity
1303: ,PTA.TOT_REVENUE tot_revenue
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

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 1466: --Replaced the pa_periods_v with the view definition

1462: -- return the current reporting period
1463: IF pa_accum_utils.g_check_reporting_end_date is null
1464: THEN
1465: /* Bug 2634995 begins */
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

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 1475: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,

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
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

Line 1508: FROM pa_periods

1504: gl_period_name
1505: INTO
1506: g_current_pa_period,
1507: g_current_gl_period
1508: FROM pa_periods
1509: WHERE
1510: current_pa_period_flag = 'Y';
1511:
1512: Exception

Line 1540: FROM pa_periods

1536: SELECT
1537: period_name
1538: INTO
1539: l_current_pa_period
1540: FROM pa_periods
1541: WHERE
1542: current_pa_period_flag = 'Y';
1543: ELSE
1544: l_current_pa_period := pa_accum_utils.g_current_pa_period;

Line 1571: FROM pa_periods

1567: SELECT
1568: gl_period_name
1569: INTO
1570: l_current_gl_period
1571: FROM pa_periods
1572: WHERE
1573: current_pa_period_flag = 'Y';
1574: ELSE
1575: l_current_gl_period := pa_accum_utils.g_current_gl_period;

Line 1800: PA_PERIODS_V

1796: x_prev_pa_year,
1797: x_prev_pa_start_date,
1798: x_prev_pa_end_date
1799: FROM
1800: PA_PERIODS_V
1801: WHERE pa_start_date =
1802: (SELECT max(start_date)
1803: FROM
1804: pa_periods

Line 1804: pa_periods

1800: PA_PERIODS_V
1801: WHERE pa_start_date =
1802: (SELECT max(start_date)
1803: FROM
1804: pa_periods
1805: WHERE start_date < x_current_pa_start_date);
1806:
1807: EXCEPTION
1808: WHEN NO_DATA_FOUND THEN

Line 1836: pa_periods_v

1832: x_prev_gl_year,
1833: x_prev_gl_start_date,
1834: x_prev_gl_end_date
1835: FROM
1836: pa_periods_v
1837: WHERE
1838: gl_start_date =
1839: (SELECT max(gl_start_date)
1840: FROM pa_periods_v

Line 1840: FROM pa_periods_v

1836: pa_periods_v
1837: WHERE
1838: gl_start_date =
1839: (SELECT max(gl_start_date)
1840: FROM pa_periods_v
1841: WHERE
1842: gl_start_date < x_current_gl_start_date);
1843:
1844: EXCEPTION

Line 1894: PA_PERIODS_V WHERE Period_name = x_prev_accum_period;

1890: If x_impl_opt = 'PA' Then
1891: Select PERIOD_YEAR,PA_START_DATE,PA_END_DATE
1892: into x_prev_accum_year,x_prev_accum_start_date,
1893: x_prev_accum_end_date from
1894: PA_PERIODS_V WHERE Period_name = x_prev_accum_period;
1895: Elsif
1896: x_impl_opt = 'GL' Then
1897: Select Distinct PERIOD_YEAR,GL_START_DATE,GL_END_DATE
1898: into x_prev_accum_year,x_prev_accum_start_date,

Line 1900: PA_PERIODS_V WHERE Gl_Period_name = x_prev_accum_period;

1896: x_impl_opt = 'GL' Then
1897: Select Distinct PERIOD_YEAR,GL_START_DATE,GL_END_DATE
1898: into x_prev_accum_year,x_prev_accum_start_date,
1899: x_prev_accum_end_date from
1900: PA_PERIODS_V WHERE Gl_Period_name = x_prev_accum_period;
1901: End If;
1902:
1903: EXCEPTION
1904: WHEN NO_DATA_FOUND THEN

Line 1919: pa_periods_v

1915: If x_impl_opt = 'PA' Then
1916: SELECT DISTINCT PERIOD_NAME
1917: INTO x_prev_prev_accum_period
1918: FROM
1919: pa_periods_v
1920: WHERE
1921: pa_start_date =
1922: (SELECT max(pa_start_date)
1923: FROM pa_periods_v

Line 1923: FROM pa_periods_v

1919: pa_periods_v
1920: WHERE
1921: pa_start_date =
1922: (SELECT max(pa_start_date)
1923: FROM pa_periods_v
1924: WHERE pa_start_date < x_prev_accum_start_date);
1925: Elsif
1926: x_impl_opt = 'GL' Then
1927: SELECT DISTINCT GL_PERIOD_NAME

Line 1930: pa_periods_v

1926: x_impl_opt = 'GL' Then
1927: SELECT DISTINCT GL_PERIOD_NAME
1928: INTO x_prev_prev_accum_period
1929: FROM
1930: pa_periods_v
1931: WHERE gl_start_date =
1932: (SELECT max(gl_start_date)
1933: FROM pa_periods_v
1934: WHERE gl_start_date < x_prev_accum_start_date);

Line 1933: FROM pa_periods_v

1929: FROM
1930: pa_periods_v
1931: WHERE gl_start_date =
1932: (SELECT max(gl_start_date)
1933: FROM pa_periods_v
1934: WHERE gl_start_date < x_prev_accum_start_date);
1935: End If;
1936:
1937: EXCEPTION