APPS.IGS_EN_GEN_009 dependencies on IGS_AD_LOCATION

Line 1740: v_elo_description IGS_AD_LOCATION.description%TYPE;

1736: DECLARE
1737: r_scah IGS_AS_SC_ATTEMPT_H%ROWTYPE;
1738: v_create_history BOOLEAN :=FALSE;
1739: v_fs_description IGS_FI_FUND_SRC.description%TYPE;
1740: v_elo_description IGS_AD_LOCATION.description%TYPE;
1741: v_fc_description IGS_FI_FEE_CAT.description%TYPE;
1742: v_cc_description IGS_CO_CAT.description%TYPE;
1743:
1744: CURSOR c_find_fs_desc IS

Line 1750: FROM IGS_AD_LOCATION

1746: FROM IGS_FI_FUND_SRC
1747: WHERE funding_source = r_scah.funding_source;
1748: CURSOR c_find_elo_desc IS
1749: SELECT description
1750: FROM IGS_AD_LOCATION
1751: WHERE location_cd = r_scah.exam_location_cd;
1752: CURSOR c_find_fc_desc IS
1753: SELECT description
1754: FROM IGS_FI_FEE_CAT

Line 1846: -- get the exam IGS_AD_LOCATION description

1842: IF NVL(p_new_exam_location_cd, 'NULL') <>
1843: NVL(p_old_exam_location_cd, 'NULL') THEN
1844: r_scah.exam_location_cd := p_old_exam_location_cd;
1845: IF NVL(p_old_exam_location_cd, 'NULL') <> 'NULL' THEN
1846: -- get the exam IGS_AD_LOCATION description
1847: OPEN c_find_elo_desc;
1848: FETCH c_find_elo_desc INTO r_scah.elo_description;
1849: CLOSE c_find_elo_desc;
1850: END IF;