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

317: paperiod.status_meaning
318: INTO l_prd_name,l_prd_yr,l_meaning
319: FROM pa_periods_v paperiod,
320: pa_implementations imp,
321: gl_period_statuses glpersts
322: WHERE glpersts.period_type = imp.pa_period_type
323: AND imp.set_of_books_id = paperiod.set_of_books_id
324: AND glpersts.set_of_books_id = imp.set_of_books_id
325: AND glpersts.period_name = paperiod.period_name

Line 374: gl_period_statuses glst,

370: INTO l_prd_name,l_prd_yr,l_meaning
371: FROM pa_implementations imp,
372: gl_sets_of_books gl,
373: gl_periods glper,
374: gl_period_statuses glst,
375: gl_lookups gllkups
376: WHERE imp.set_of_books_id = gl.set_of_books_id
377: AND gl.period_set_name = glper.period_set_name
378: AND gl.accounted_period_type = glper.period_type

Line 486: gl_period_statuses glst

482: INTO l_quarter_num
483: FROM pa_implementations imp,
484: gl_sets_of_books gl,
485: gl_periods glper,
486: gl_period_statuses glst
487: WHERE imp.set_of_books_id = gl.set_of_books_id
488: AND gl.period_set_name = glper.period_set_name
489: AND gl.accounted_period_type = glper.period_type
490: AND glper.period_name = glst.period_name

Line 980: gl_period_statuses glst

976: /* CURSOR C1 IS SELECT glper.period_name,glper.period_year,glst.closing_status,glper.quarter_num,glst.effective_period_num
977: FROM pa_implementations imp,
978: gl_sets_of_books gl,
979: gl_periods glper,
980: gl_period_statuses glst
981: WHERE imp.set_of_books_id = gl.set_of_books_id
982: AND gl.period_set_name = glper.period_set_name
983: AND imp.pa_period_type = glper.period_type
984: AND glper.period_name = glst.period_name

Line 1000: gl_period_statuses glpersts

996: glpersts.effective_period_num,
997: paperiod.status_meaning
998: FROM pa_periods_v paperiod,
999: pa_implementations imp,
1000: gl_period_statuses glpersts
1001: WHERE glpersts.period_type = imp.pa_period_type
1002: AND imp.set_of_books_id = paperiod.set_of_books_id
1003: AND glpersts.set_of_books_id = imp.set_of_books_id
1004: AND glpersts.period_name = paperiod.period_name

Line 1020: gl_period_statuses glst,

1016: ,gllkups.meaning
1017: FROM pa_implementations imp,
1018: gl_sets_of_books gl,
1019: gl_periods glper,
1020: gl_period_statuses glst,
1021: gl_lookups gllkups
1022: WHERE imp.set_of_books_id = gl.set_of_books_id
1023: AND gl.period_set_name = glper.period_set_name
1024: AND gl.accounted_period_type = glper.period_type

Line 1045: l_sts gl_period_statuses.closing_status%TYPE;

1041: l_forecast_thru_date DATE;
1042:
1043: l_prd_name gl_periods.period_name%TYPE;
1044: l_prd_yr gl_periods.period_year%TYPE;
1045: l_sts gl_period_statuses.closing_status%TYPE;
1046: l_mon_qtr gl_periods.quarter_num%TYPE;
1047:
1048: l_mon NUMBER;
1049:

Line 1053: l_period_num gl_period_statuses.effective_period_num%TYPE;

1049:
1050: l_period_type gl_periods.period_type%TYPE;
1051: l_week_ending_date DATE;
1052:
1053: l_period_num gl_period_statuses.effective_period_num%TYPE;
1054: l_sts_meaning gl_lookups.meaning%TYPE;
1055: l_use_default_logic VARCHAR2(1) := 'Y';
1056: l_date_format VARCHAR2(100); -- Added for Bug 2091182 and 2387429
1057: /* NPE Changes Begin*/

Line 1272: gl_period_statuses glpersts

1268: paperiod.status_meaning
1269: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1270: FROM pa_periods_v paperiod,
1271: pa_implementations imp,
1272: gl_period_statuses glpersts
1273: WHERE glpersts.period_type = imp.pa_period_type
1274: AND imp.set_of_books_id = paperiod.set_of_books_id
1275: AND glpersts.set_of_books_id = imp.set_of_books_id
1276: AND glpersts.period_name = paperiod.period_name

Line 1332: gl_period_statuses glst,

1328: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1329: FROM pa_implementations imp,
1330: gl_sets_of_books gl,
1331: gl_periods glper,
1332: gl_period_statuses glst,
1333: gl_lookups gllkups
1334: WHERE imp.set_of_books_id = gl.set_of_books_id
1335: AND gl.period_set_name = glper.period_set_name
1336: AND gl.accounted_period_type = glper.period_type

Line 1460: gl_period_statuses glpersts

1456: paperiod.status_meaning
1457: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1458: FROM pa_periods_v paperiod,
1459: pa_implementations imp,
1460: gl_period_statuses glpersts
1461: WHERE glpersts.period_type = imp.pa_period_type
1462: AND imp.set_of_books_id = paperiod.set_of_books_id
1463: AND glpersts.set_of_books_id = imp.set_of_books_id
1464: AND glpersts.period_name = paperiod.period_name

Line 1491: gl_period_statuses glst,

1487: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1488: FROM pa_implementations imp,
1489: gl_sets_of_books gl,
1490: gl_periods glper,
1491: gl_period_statuses glst,
1492: gl_lookups gllkups
1493: WHERE imp.set_of_books_id = gl.set_of_books_id
1494: AND gl.period_set_name = glper.period_set_name
1495: AND gl.accounted_period_type = glper.period_type