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.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_UNIT_OFR_OPT_V

Line 72: sommukhe 24-Jan-2006 Bug #4926548,replaced igs_ps_unit_ofr_opt_v with igs_ps_unit_ofr_opt_all for cursor c_end_dt

68:
69: Change History
70:
71: Who When What
72: sommukhe 24-Jan-2006 Bug #4926548,replaced igs_ps_unit_ofr_opt_v with igs_ps_unit_ofr_opt_all for cursor c_end_dt
73: sarakshi 12-Jan-2005 Bug#4926548, modified cursor uoo_cur to remove the two outer joins with two tables and included them in the place of open cursor .Also
74: modified the cursor usec_occur to use its base table rather than the view IGS_PS_USEC_OCCURS_V
75: sarakshi 06-Dec-2005 Bug#4863051,modified cursor pat_cur such that it excludes the inactive units for processing.
76: sarakshi 19-Sep-2005 Bug#4588504, modified cursor uoo_cur such it picks the subtitle correctly.

Line 141: CURSOR c_end_dt (cp_uoo_id IGS_PS_UNIT_OFR_OPT_V.UOO_ID%TYPE) IS

137: );
138:
139:
140: -- Get the calendar end date for the particular unit section for Bug # 2383553
141: CURSOR c_end_dt (cp_uoo_id IGS_PS_UNIT_OFR_OPT_V.UOO_ID%TYPE) IS
142: SELECT ci.end_dt cal_end_dt
143: FROM igs_ps_unit_ofr_opt_all uoo, igs_ca_inst_all ci
144: WHERE UOO_ID =cp_uoo_id
145: AND uoo.cal_type = ci.cal_type