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 1444: from PA_PERIODS_V pav, pa_implementations pai

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

Line 1462: --Replaced the pa_periods_v with the view definition

1458: -- return the current reporting period
1459: IF pa_accum_utils.g_check_reporting_end_date is null
1460: THEN
1461: /* Bug 2634995 begins */
1462: --Replaced the pa_periods_v with the view definition
1463: -- select decode( pai.accumulation_period_type, 'PA', pav.pa_end_date,
1464: -- 'GL', pav.gl_end_date )
1465: -- into lcl_end_date
1466: -- from PA_PERIODS_V pav, pa_implementations pai

Line 1466: -- from PA_PERIODS_V pav, pa_implementations pai

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

Line 1796: PA_PERIODS_V

1792: x_prev_pa_year,
1793: x_prev_pa_start_date,
1794: x_prev_pa_end_date
1795: FROM
1796: PA_PERIODS_V
1797: WHERE pa_start_date =
1798: (SELECT max(start_date)
1799: FROM
1800: pa_periods

Line 1832: pa_periods_v

1828: x_prev_gl_year,
1829: x_prev_gl_start_date,
1830: x_prev_gl_end_date
1831: FROM
1832: pa_periods_v
1833: WHERE
1834: gl_start_date =
1835: (SELECT max(gl_start_date)
1836: FROM pa_periods_v

Line 1836: FROM pa_periods_v

1832: pa_periods_v
1833: WHERE
1834: gl_start_date =
1835: (SELECT max(gl_start_date)
1836: FROM pa_periods_v
1837: WHERE
1838: gl_start_date < x_current_gl_start_date);
1839:
1840: EXCEPTION

Line 1890: PA_PERIODS_V WHERE Period_name = x_prev_accum_period;

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

Line 1896: PA_PERIODS_V WHERE Gl_Period_name = x_prev_accum_period;

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

Line 1915: pa_periods_v

1911: If x_impl_opt = 'PA' Then
1912: SELECT DISTINCT PERIOD_NAME
1913: INTO x_prev_prev_accum_period
1914: FROM
1915: pa_periods_v
1916: WHERE
1917: pa_start_date =
1918: (SELECT max(pa_start_date)
1919: FROM pa_periods_v

Line 1919: FROM pa_periods_v

1915: pa_periods_v
1916: WHERE
1917: pa_start_date =
1918: (SELECT max(pa_start_date)
1919: FROM pa_periods_v
1920: WHERE pa_start_date < x_prev_accum_start_date);
1921: Elsif
1922: x_impl_opt = 'GL' Then
1923: SELECT DISTINCT GL_PERIOD_NAME

Line 1926: pa_periods_v

1922: x_impl_opt = 'GL' Then
1923: SELECT DISTINCT GL_PERIOD_NAME
1924: INTO x_prev_prev_accum_period
1925: FROM
1926: pa_periods_v
1927: WHERE gl_start_date =
1928: (SELECT max(gl_start_date)
1929: FROM pa_periods_v
1930: WHERE gl_start_date < x_prev_accum_start_date);

Line 1929: FROM pa_periods_v

1925: FROM
1926: pa_periods_v
1927: WHERE gl_start_date =
1928: (SELECT max(gl_start_date)
1929: FROM pa_periods_v
1930: WHERE gl_start_date < x_prev_accum_start_date);
1931: End If;
1932:
1933: EXCEPTION