APPS.IGS_EN_GEN_LEGACY dependencies on IGS_GE_S_GEN_CAL_CON

Line 1736: FROM igs_ge_s_gen_cal_con

1732: ***********************************************************************************************/
1733:
1734: CURSOR c_s_gen_cal_conf IS
1735: SELECT census_dt_alias
1736: FROM igs_ge_s_gen_cal_con
1737: WHERE s_control_num = 1;
1738:
1739: -- Cursor to check whether intermission period overlaps enrolled/completed unit attempt
1740: -- teaching period census dates.

Line 1742: CURSOR c_intm_census_ovrlp(l_census_dt_alias igs_ge_s_gen_cal_con.census_dt_alias%TYPE) IS

1738:
1739: -- Cursor to check whether intermission period overlaps enrolled/completed unit attempt
1740: -- teaching period census dates.
1741:
1742: CURSOR c_intm_census_ovrlp(l_census_dt_alias igs_ge_s_gen_cal_con.census_dt_alias%TYPE) IS
1743: SELECT 'x'
1744: FROM igs_en_su_attempt sua,
1745: igs_ca_da_inst_v da
1746: WHERE sua.person_id = p_person_id

Line 1756: l_census_dt_alias igs_ge_s_gen_cal_con.census_dt_alias%TYPE;

1752: AND da.alias_val IS NOT NULL
1753: AND da.alias_val BETWEEN p_start_dt AND p_end_dt ;
1754:
1755: l_interm_perd VARCHAR2(1);
1756: l_census_dt_alias igs_ge_s_gen_cal_con.census_dt_alias%TYPE;
1757:
1758: BEGIN
1759:
1760: OPEN c_s_gen_cal_conf;