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_UC_EXP_APPLICANT_DTLS dependencies on FND_TERRITORIES_VL

Line 2794: CURSOR cur_short_name ( p_short_name FND_TERRITORIES_VL.territory_short_name%TYPE ) IS

2790: WHO WHEN WHAT
2791: ***************************************************************** */
2792:
2793: -- Fetch the Territory Code for the Address4 or HomeAddress4
2794: CURSOR cur_short_name ( p_short_name FND_TERRITORIES_VL.territory_short_name%TYPE ) IS
2795: SELECT territory_code
2796: FROM FND_TERRITORIES_VL
2797: WHERE territory_short_name = p_short_name ;
2798: cur_short_name_rec cur_short_name%ROWTYPE ;

Line 2796: FROM FND_TERRITORIES_VL

2792:
2793: -- Fetch the Territory Code for the Address4 or HomeAddress4
2794: CURSOR cur_short_name ( p_short_name FND_TERRITORIES_VL.territory_short_name%TYPE ) IS
2795: SELECT territory_code
2796: FROM FND_TERRITORIES_VL
2797: WHERE territory_short_name = p_short_name ;
2798: cur_short_name_rec cur_short_name%ROWTYPE ;
2799:
2800: -- Fetch the OSS Nationality Code mapped to Domicile APR