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_V

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