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 195: FROM gl_period_statuses

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

Line 216: FROM gl_period_statuses

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

Line 256: FROM gl_period_statuses

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

Line 349: FROM gl_period_statuses g, pa_projects_all proj

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

Line 451: FROM gl_period_statuses

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

Line 456: 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

452: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
453: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
454: AND adjustment_period_flag = 'N'
455: AND l_act_to_period_date BETWEEN start_date AND end_date
456: 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
457: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
458: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
459: AND period_name = l_act_from_period_name);
460:

Line 560: FROM gl_period_statuses

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

Line 684: FROM gl_period_statuses g, pa_projects_all proj

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

Line 1850: FROM GL_PERIOD_STATUSES

1846:
1847: ELSIF P_FP_COLS_REC.X_TIME_PHASED_CODE = 'G' THEN
1848: SELECT END_DATE
1849: INTO X_END_DATE
1850: FROM GL_PERIOD_STATUSES
1851: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
1852: AND SET_OF_BOOKS_ID = p_fp_cols_rec.x_set_of_books_id
1853: AND ADJUSTMENT_PERIOD_FLAG = 'N'
1854: AND PERIOD_NAME = p_period_name;