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_004 dependencies on IGS_PE_PERM_RES_CD

Line 883: cp_perm_res_cd IGS_PE_PERM_RES_CD.perm_resident_cd%TYPE) IS

879: SELECT ccd.govt_citizenship_cd
880: FROM IGS_ST_CITIZENSHP_CD ccd
881: WHERE ccd.citizenship_cd = p_citizenship_cd;
882: CURSOR c_perm_res (
883: cp_perm_res_cd IGS_PE_PERM_RES_CD.perm_resident_cd%TYPE) IS
884: SELECT prcd.govt_perm_resident_cd
885: FROM IGS_PE_PERM_RES_CD prcd
886: WHERE prcd.perm_resident_cd = cp_perm_res_cd;
887: BEGIN

Line 885: FROM IGS_PE_PERM_RES_CD prcd

881: WHERE ccd.citizenship_cd = p_citizenship_cd;
882: CURSOR c_perm_res (
883: cp_perm_res_cd IGS_PE_PERM_RES_CD.perm_resident_cd%TYPE) IS
884: SELECT prcd.govt_perm_resident_cd
885: FROM IGS_PE_PERM_RES_CD prcd
886: WHERE prcd.perm_resident_cd = cp_perm_res_cd;
887: BEGIN
888: -- only get the IGS_PE_PERSON data if the IGS_PE_PERSON has changed
889: IF p_old_person_id IS NULL OR