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_ST_GEN_002 dependencies on IGS_ST_CITIZENSHP_CD

Line 355: FROM IGS_ST_CITIZENSHP_CD cic

351: FROM IGS_PE_ABORG_TORESCD atc
352: WHERE atc.aborig_torres_cd = v_aborig_torres_cd;
353: CURSOR c_cic IS
354: SELECT cic.govt_citizenship_cd
355: FROM IGS_ST_CITIZENSHP_CD cic
356: WHERE cic.citizenship_cd = v_citizenship_cd;
357: CURSOR c_cnc IS
358: SELECT cnc.govt_country_cd
359: FROM IGS_PE_COUNTRY_CD cnc

Line 578: FROM IGS_ST_CITIZENSHP_CD ccd

574: FROM IGS_PE_ABORG_TORESCD atcd
575: WHERE atcd.aborig_torres_cd = v_aborig_torres_cd;
576: CURSOR c_citz IS
577: SELECT ccd.govt_citizenship_cd
578: FROM IGS_ST_CITIZENSHP_CD ccd
579: WHERE ccd.citizenship_cd = v_citizenship_cd;
580: CURSOR c_perm_res (
581: cp_perm_res_cd IGS_PE_PERM_RES_CD.perm_resident_cd%TYPE) IS
582: SELECT prcd.govt_perm_resident_cd