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_REPORT_UTIL dependencies on PA_PERIODS_V

Line 343: FROM pa_periods_v paperiod,

339: SELECT paperiod.period_name,
340: paperiod.period_year,
341: paperiod.status_meaning
342: INTO l_prd_name,l_prd_yr,l_meaning
343: FROM pa_periods_v paperiod,
344: pa_implementations imp,
345: gl_period_statuses glpersts
346: WHERE glpersts.period_type = imp.pa_period_type
347: AND imp.set_of_books_id = paperiod.set_of_books_id

Line 360: FROM pa_periods_v paperiod

356: SELECT paperiod.period_name,
357: paperiod.period_year,
358: paperiod.status_meaning
359: INTO l_prd_name,l_prd_yr,l_meaning
360: FROM pa_periods_v paperiod
361: WHERE l_default_date BETWEEN paperiod.pa_start_date AND paperiod.pa_end_date
362: AND ROWNUM=1
363: ORDER BY paperiod.period_year;
364:

Line 1026: remove gl_period_statuses and pa_periods_v. */

1022: ORDER BY glper.period_year;*/
1023:
1024: /* Bug #4255100: Not modifying these cursors as these are not being used. If this
1025: cursor has to be modified then, this cursor will have to be modified to
1026: remove gl_period_statuses and pa_periods_v. */
1027: CURSOR C1 IS SELECT
1028: paperiod.period_name,
1029: paperiod.period_year,
1030: paperiod.status,

Line 1034: FROM pa_periods_v paperiod,

1030: paperiod.status,
1031: paperiod.quarter_num,
1032: glpersts.effective_period_num,
1033: paperiod.status_meaning
1034: FROM pa_periods_v paperiod,
1035: pa_implementations imp,
1036: gl_period_statuses glpersts
1037: WHERE glpersts.period_type = imp.pa_period_type
1038: AND imp.set_of_books_id = paperiod.set_of_books_id

Line 1307: FROM pa_periods_v paperiod,

1303: paperiod.quarter_num,
1304: glpersts.effective_period_num,
1305: paperiod.status_meaning
1306: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1307: FROM pa_periods_v paperiod,
1308: pa_implementations imp,
1309: gl_period_statuses glpersts
1310: WHERE glpersts.period_type = imp.pa_period_type
1311: AND imp.set_of_books_id = paperiod.set_of_books_id

Line 1329: FROM pa_periods_v paperiod

1325: paperiod.quarter_num,
1326: 0 effective_period_num,
1327: paperiod.status_meaning
1328: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1329: FROM pa_periods_v paperiod
1330: WHERE l_default_date BETWEEN paperiod.pa_start_date AND paperiod.pa_end_date
1331: ORDER BY paperiod.period_year;
1332:
1333: x_def_period_name := l_prd_name;

Line 1508: FROM pa_periods_v paperiod,

1504: paperiod.quarter_num,
1505: glpersts.effective_period_num,
1506: paperiod.status_meaning
1507: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1508: FROM pa_periods_v paperiod,
1509: pa_implementations imp,
1510: gl_period_statuses glpersts
1511: WHERE glpersts.period_type = imp.pa_period_type
1512: AND imp.set_of_books_id = paperiod.set_of_books_id

Line 1532: FROM pa_periods_v paperiod

1528: paperiod.quarter_num,
1529: 0 effective_period_num,
1530: paperiod.status_meaning
1531: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1532: FROM pa_periods_v paperiod
1533: WHERE paperiod.period_name = x_def_period_name
1534: AND paperiod.period_year = x_def_period_yr
1535: ORDER BY paperiod.period_year;
1536: