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.IGC_CC_YEP_PROCESS_PKG dependencies on GL_PERIOD_STATUSES

Line 117: FROM gl_period_statuses gps,

113:
114:
115: SELECT min(gp.period_num)
116: INTO l_min_period_num
117: FROM gl_period_statuses gps,
118: gl_periods gp,
119: gl_sets_of_books gb
120: WHERE
121: gb.set_of_books_id = p_SOB_ID AND

Line 133: FROM gl_period_statuses gps,

129:
130:
131: SELECT gps.start_date INTO
132: l_next_yr_start_date
133: FROM gl_period_statuses gps,
134: gl_periods gp,
135: gl_sets_of_books gb
136: WHERE gb.set_of_books_id = p_SOB_ID AND
137: gp.period_set_name = gb.period_set_name AND

Line 1026: FROM GL_PERIOD_STATUSES

1022: -- This makes cursor C9 redundant.
1023: CURSOR C8 (p_year NUMBER,
1024: p_period_num NUMBER) IS
1025: SELECT PERIOD_NAME, PERIOD_NUM, CLOSING_STATUS
1026: FROM GL_PERIOD_STATUSES
1027: WHERE APPLICATION_ID = (SELECT APPLICATION_ID
1028: FROM FND_APPLICATION
1029: WHERE APPLICATION_SHORT_NAME = 'SQLGL')
1030: -- Bug No : 6341012. MOAC Uptake. p_sob_id is changed to l_sob_id

Line 1042: FROM GL_PERIOD_STATUSES

1038:
1039: /*
1040: CURSOR C9 IS
1041: SELECT PERIOD_NAME, PERIOD_NUM, CLOSING_STATUS
1042: FROM GL_PERIOD_STATUSES
1043: WHERE APPLICATION_ID = (SELECT APPLICATION_ID
1044: FROM FND_APPLICATION
1045: WHERE APPLICATION_SHORT_NAME = 'SQLGL')
1046:

Line 1352: FROM gl_period_statuses gps,

1348: l_COUNTER := 0;
1349:
1350: SELECT min(gp.period_num)
1351: INTO l_min_period_num
1352: FROM gl_period_statuses gps,
1353: gl_periods gp,
1354: gl_sets_of_books gb
1355: WHERE
1356: gb.set_of_books_id = l_sob_id AND /*p_sob_id => l_sob_id by Bug 6341012 */

Line 1368: FROM gl_period_statuses gps,

1364:
1365:
1366: SELECT max(gp.period_num)
1367: INTO l_max_period_num
1368: FROM gl_period_statuses gps,
1369: gl_periods gp,
1370: gl_sets_of_books gb
1371: WHERE
1372: gb.set_of_books_id = l_sob_id AND /* p_sob_id => l_sob_id by Bug 6341012 */

Line 1385: FROM gl_period_statuses gps,

1381:
1382:
1383: SELECT gps.end_date,gps.end_date INTO
1384: l_yr_end_cr_date,l_yr_end_date
1385: FROM gl_period_statuses gps,
1386: gl_periods gp,
1387: gl_sets_of_books gb
1388: WHERE
1389: gb.set_of_books_id = l_sob_id AND /* p_sob_id => l_sob_id by Bug 6341012 */

Line 1401: FROM gl_period_statuses gps,

1397:
1398:
1399: SELECT gps.start_date, gps.start_date INTO
1400: l_yr_end_dr_date, l_yr_start_date_next
1401: FROM gl_period_statuses gps,
1402: gl_periods gp,
1403: gl_sets_of_books gb
1404: WHERE
1405: gb.set_of_books_id = l_sob_id AND /* p_sob_id => l_sob_id by Bug 6341012 */

Line 1417: FROM gl_period_statuses gps,

1413:
1414:
1415: SELECT gps.start_date INTO
1416: l_yr_start_date
1417: FROM gl_period_statuses gps,
1418: gl_periods gp,
1419: gl_sets_of_books gb
1420: WHERE
1421: gb.set_of_books_id = l_sob_id AND /* p_sob_id => l_sob_id by Bug 6341012 */