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.

[Home] [Help]

APPS.IGS_ST_GEN_002 dependencies on IGS_PE_PERM_RES_CD

Line 581: cp_perm_res_cd IGS_PE_PERM_RES_CD.perm_resident_cd%TYPE) 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
583: FROM IGS_PE_PERM_RES_CD prcd
584: WHERE prcd.perm_resident_cd = cp_perm_res_cd;
585: CURSOR c_country_dtls (

Line 583: FROM IGS_PE_PERM_RES_CD prcd

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
583: FROM IGS_PE_PERM_RES_CD prcd
584: WHERE prcd.perm_resident_cd = cp_perm_res_cd;
585: CURSOR c_country_dtls (
586: cp_country_cd IGS_PE_COUNTRY_CD.country_cd%TYPE) IS
587: SELECT ccd.govt_country_cd