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

Line 80: FROM gl_period_statuses

76: RETURN NUMBER
77: IS
78: CURSOR c_effnum IS
79: SELECT effective_period_num
80: FROM gl_period_statuses
81: WHERE application_id = AP_APPLICATION_ID
82: AND set_of_books_id = fp_sob_id
83: AND period_name = fp_period_name
84: ;

Line 99: FROM gl_period_statuses gps

95: RETURN VARCHAR2
96: IS
97: CURSOR c_ap_periods ( cp_eff_period_num in number) IS
98: SELECT gps.effective_period_num, gps.period_name
99: FROM gl_period_statuses gps
100: WHERE gps.application_id = AP_APPLICATION_ID
101: AND gps.set_of_books_id = fp_sob_id
102: AND gps.adjustment_period_flag <> 'Y'
103: AND gps.effective_period_num >= cp_eff_period_num

Line 252: FROM gl_period_statuses

248: )
249: RETURN varchar2 IS
250: CURSOR c_period IS
251: SELECT period_name
252: FROM gl_period_statuses
253: where application_id = AP_APPLICATION_ID
254: and set_of_books_id = fp_sob_id
255: and adjustment_period_flag = 'N'
256: and fp_date between start_date and end_date