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_FP_GEN_FCST_PG_PKG dependencies on GL_PERIOD_STATUSES

Line 128: FROM GL_PERIOD_STATUSES

124: l_fp_cols_rec.x_time_phased_code = 'G' THEN
125:
126: SELECT PERIOD_NAME, END_DATE
127: INTO x_period_name,l_end_date
128: FROM GL_PERIOD_STATUSES
129: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
130: AND SET_OF_BOOKS_ID = l_fp_cols_rec.x_set_of_books_id
131: AND ADJUSTMENT_PERIOD_FLAG = 'N'
132: AND CLOSING_STATUS = 'C'

Line 134: FROM GL_PERIOD_STATUSES

130: AND SET_OF_BOOKS_ID = l_fp_cols_rec.x_set_of_books_id
131: AND ADJUSTMENT_PERIOD_FLAG = 'N'
132: AND CLOSING_STATUS = 'C'
133: AND END_DATE = (SELECT MAX(END_DATE)
134: FROM GL_PERIOD_STATUSES
135: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
136: AND SET_OF_BOOKS_ID = l_fp_cols_rec.x_set_of_books_id
137: AND ADJUSTMENT_PERIOD_FLAG = 'N'
138: AND END_DATE < TRUNC(SYSDATE)

Line 163: FROM gl_period_statuses

159: l_fp_cols_rec.x_time_phased_code = 'G' THEN
160:
161: SELECT period_name, end_date
162: INTO x_period_name, l_end_date
163: FROM gl_period_statuses
164: WHERE end_date =
165: (SELECT max(end_date)
166: FROM gl_period_statuses
167: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id

Line 166: FROM gl_period_statuses

162: INTO x_period_name, l_end_date
163: FROM gl_period_statuses
164: WHERE end_date =
165: (SELECT max(end_date)
166: FROM gl_period_statuses
167: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
168: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
169: AND adjustment_period_flag = 'N'
170: AND end_date <

Line 172: FROM gl_period_statuses

168: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
169: AND adjustment_period_flag = 'N'
170: AND end_date <
171: (SELECT end_date
172: FROM gl_period_statuses
173: WHERE trunc(sysdate) between start_date and end_date
174: AND APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
175: AND SET_OF_BOOKS_ID = l_fp_cols_rec.x_set_of_books_id
176: AND ADJUSTMENT_PERIOD_FLAG = 'N'))

Line 196: FROM gl_period_statuses

192:
193: ELSIF ltrim(rtrim(l_fp_cols_rec.x_time_phased_code)) = 'G' THEN
194: SELECT period_name, end_date
195: INTO x_period_name, l_end_date2
196: FROM gl_period_statuses
197: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
198: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
199: AND adjustment_period_flag = 'N'
200: AND l_end_date between start_date and end_date;

Line 217: FROM gl_period_statuses

213: END IF;
214: l_end_date1 := l_end_date;
215: IF l_fp_cols_rec.x_time_phased_code = 'G' THEN
216: SELECT end_date into l_end_date1
217: FROM gl_period_statuses
218: WHERE l_end_date between start_date and end_date
219: AND APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
220: AND SET_OF_BOOKS_ID = l_fp_cols_rec.x_set_of_books_id
221: AND ADJUSTMENT_PERIOD_FLAG = 'N';

Line 257: FROM gl_period_statuses

253: AND trunc(sysdate) between start_date and end_date;
254: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN
255: SELECT end_date
256: INTO l_end_date
257: FROM gl_period_statuses
258: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
259: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
260: AND adjustment_period_flag = 'N'
261: AND trunc(sysdate) between start_date and end_date;

Line 350: FROM gl_period_statuses g, pa_projects_all proj

346: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN
347:
348: SELECT g.period_name
349: INTO l_period_name
350: FROM gl_period_statuses g, pa_projects_all proj
351: WHERE g.application_id = PA_PERIOD_PROCESS_PKG.Application_id
352: AND g.set_of_books_id = l_fp_cols_rec.x_set_of_books_id
353: AND g.adjustment_period_flag = 'N'
354: AND proj.project_id = l_fp_cols_rec.x_project_id

Line 452: FROM gl_period_statuses

448: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN
449: BEGIN
450: SELECT period_name
451: INTO l_act_to_period_name
452: FROM gl_period_statuses
453: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
454: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
455: AND adjustment_period_flag = 'N'
456: AND l_act_to_period_date BETWEEN start_date AND end_date

Line 457: AND start_date >= (SELECT start_date FROM gl_period_statuses -- bug6142328 added one more select query for comparing the start date of act_to_period with act_from_period

453: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
454: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
455: AND adjustment_period_flag = 'N'
456: AND l_act_to_period_date BETWEEN start_date AND end_date
457: AND start_date >= (SELECT start_date FROM gl_period_statuses -- bug6142328 added one more select query for comparing the start date of act_to_period with act_from_period
458: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
459: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
460: AND period_name = l_act_from_period_name);
461:

Line 561: FROM gl_period_statuses

557: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN
558:
559: SELECT period_name
560: INTO l_etc_from_period_name
561: FROM gl_period_statuses
562: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
563: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
564: AND adjustment_period_flag = 'N'
565: AND l_etc_from_period_date between start_date and end_date;

Line 685: FROM gl_period_statuses g, pa_projects_all proj

681: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN
682:
683: SELECT g.period_name, NVL(proj.completion_date, trunc(SYSDATE))
684: INTO l_etc_to_period, l_proj_comp_date
685: FROM gl_period_statuses g, pa_projects_all proj
686: WHERE g.application_id = PA_PERIOD_PROCESS_PKG.Application_id
687: AND g.set_of_books_id = l_fp_cols_rec.x_set_of_books_id
688: AND g.adjustment_period_flag = 'N'
689: AND proj.project_id = l_fp_cols_rec.x_project_id

Line 2131: FROM GL_PERIOD_STATUSES

2127:
2128: ELSIF P_FP_COLS_REC.X_TIME_PHASED_CODE = 'G' THEN
2129: SELECT END_DATE
2130: INTO X_END_DATE
2131: FROM GL_PERIOD_STATUSES
2132: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
2133: AND SET_OF_BOOKS_ID = p_fp_cols_rec.x_set_of_books_id
2134: AND ADJUSTMENT_PERIOD_FLAG = 'N'
2135: AND PERIOD_NAME = p_period_name;