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 GL_PERIOD_STATUSES

Line 345: gl_period_statuses glpersts

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
348: AND glpersts.set_of_books_id = imp.set_of_books_id
349: AND glpersts.period_name = paperiod.period_name

Line 407: gl_period_statuses glst,

403: INTO l_prd_name,l_prd_yr,l_meaning
404: FROM pa_implementations imp,
405: gl_sets_of_books gl,
406: gl_periods glper,
407: gl_period_statuses glst,
408: gl_lookups gllkups
409: WHERE imp.set_of_books_id = gl.set_of_books_id
410: AND gl.period_set_name = glper.period_set_name
411: AND gl.accounted_period_type = glper.period_type

Line 519: gl_period_statuses glst

515: INTO l_quarter_num
516: FROM pa_implementations imp,
517: gl_sets_of_books gl,
518: gl_periods glper,
519: gl_period_statuses glst
520: WHERE imp.set_of_books_id = gl.set_of_books_id
521: AND gl.period_set_name = glper.period_set_name
522: AND gl.accounted_period_type = glper.period_type
523: AND glper.period_name = glst.period_name

Line 1013: gl_period_statuses glst

1009: /* CURSOR C1 IS SELECT glper.period_name,glper.period_year,glst.closing_status,glper.quarter_num,glst.effective_period_num
1010: FROM pa_implementations imp,
1011: gl_sets_of_books gl,
1012: gl_periods glper,
1013: gl_period_statuses glst
1014: WHERE imp.set_of_books_id = gl.set_of_books_id
1015: AND gl.period_set_name = glper.period_set_name
1016: AND imp.pa_period_type = glper.period_type
1017: AND glper.period_name = glst.period_name

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 1036: gl_period_statuses glpersts

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
1039: AND glpersts.set_of_books_id = imp.set_of_books_id
1040: AND glpersts.period_name = paperiod.period_name

Line 1056: gl_period_statuses glst,

1052: ,gllkups.meaning
1053: FROM pa_implementations imp,
1054: gl_sets_of_books gl,
1055: gl_periods glper,
1056: gl_period_statuses glst,
1057: gl_lookups gllkups
1058: WHERE imp.set_of_books_id = gl.set_of_books_id
1059: AND gl.period_set_name = glper.period_set_name
1060: AND gl.accounted_period_type = glper.period_type

Line 1081: l_sts gl_period_statuses.closing_status%TYPE;

1077: l_forecast_thru_date DATE;
1078:
1079: l_prd_name gl_periods.period_name%TYPE;
1080: l_prd_yr gl_periods.period_year%TYPE;
1081: l_sts gl_period_statuses.closing_status%TYPE;
1082: l_mon_qtr gl_periods.quarter_num%TYPE;
1083:
1084: l_mon NUMBER;
1085:

Line 1089: l_period_num gl_period_statuses.effective_period_num%TYPE;

1085:
1086: l_period_type gl_periods.period_type%TYPE;
1087: l_week_ending_date DATE;
1088:
1089: l_period_num gl_period_statuses.effective_period_num%TYPE;
1090: l_sts_meaning gl_lookups.meaning%TYPE;
1091: l_use_default_logic VARCHAR2(1) := 'Y';
1092: l_date_format VARCHAR2(100); -- Added for Bug 2091182 and 2387429
1093: /* NPE Changes Begin*/

Line 1309: gl_period_statuses glpersts

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
1312: AND glpersts.set_of_books_id = imp.set_of_books_id
1313: AND glpersts.period_name = paperiod.period_name

Line 1380: gl_period_statuses glst,

1376: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1377: FROM pa_implementations imp,
1378: gl_sets_of_books gl,
1379: gl_periods glper,
1380: gl_period_statuses glst,
1381: gl_lookups gllkups
1382: WHERE imp.set_of_books_id = gl.set_of_books_id
1383: AND gl.period_set_name = glper.period_set_name
1384: AND gl.accounted_period_type = glper.period_type

Line 1510: gl_period_statuses glpersts

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
1513: AND glpersts.set_of_books_id = imp.set_of_books_id
1514: AND glpersts.period_name = paperiod.period_name

Line 1554: gl_period_statuses glst,

1550: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1551: FROM pa_implementations imp,
1552: gl_sets_of_books gl,
1553: gl_periods glper,
1554: gl_period_statuses glst,
1555: gl_lookups gllkups
1556: WHERE imp.set_of_books_id = gl.set_of_books_id
1557: AND gl.period_set_name = glper.period_set_name
1558: AND gl.accounted_period_type = glper.period_type