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_GE_GEN_002 dependencies on IGS_OR_INST_ADDR

Line 712: FROM IGS_OR_INST_ADDR iadv

708: iadv.addr_line_2 iadv_addr_line_2,
709: iadv.addr_line_3 iadv_addr_line_3,
710: iadv.addr_line_4 iadv_addr_line_4,
711: iadv.city iadv_city
712: FROM IGS_OR_INST_ADDR iadv
713: WHERE iadv.institution_cd = cp_institution_cd AND
714: iadv.correspondence_ind = 'Y';
715:
716: -- cursor for selection of the IGS_OR_INSTITUTION address when

Line 728: FROM IGS_OR_INST_ADDR iadv

724: iadv.addr_line_2 iadv_addr_line_2,
725: iadv.addr_line_3 iadv_addr_line_3,
726: iadv.addr_line_4 iadv_addr_line_4,
727: iadv.city iadv_city
728: FROM IGS_OR_INST_ADDR iadv
729: WHERE iadv.institution_cd = cp_institution_cd AND
730: iadv.addr_type = cp_addr_type;
731:
732: -- Local Variables