APPS.IGF_DB_DISB dependencies on IGS_EN_ATD_TYPE_ALL

Line 1844: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE,

1840:
1841: FUNCTION chk_att_result(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1842: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1843: p_ld_seq_number igs_ca_inst_all.sequence_number%TYPE,
1844: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE,
1845: p_result OUT NOCOPY VARCHAR2
1846: )
1847: RETURN BOOLEAN
1848: AS

Line 1858: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE)

1854: --
1855: --------------------------------------------------------------------------------------------
1856:
1857: CURSOR cur_get_rng(p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1858: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE)
1859: IS
1860: SELECT
1861: upper_enr_load_range
1862: FROM

Line 1870: ln_min_range igs_en_atd_type_all.upper_enr_load_range%TYPE;

1866: attendance_type = p_min_att_type;
1867:
1868: get_rng_rec cur_get_rng%ROWTYPE;
1869:
1870: ln_min_range igs_en_atd_type_all.upper_enr_load_range%TYPE;
1871: ln_key_range igs_en_atd_type_all.upper_enr_load_range%TYPE;
1872: lv_key_att_type igs_en_atd_type_all.attendance_type%TYPE;
1873: l_credit_pts NUMBER;
1874: l_fte VARCHAR2(10);

Line 1871: ln_key_range igs_en_atd_type_all.upper_enr_load_range%TYPE;

1867:
1868: get_rng_rec cur_get_rng%ROWTYPE;
1869:
1870: ln_min_range igs_en_atd_type_all.upper_enr_load_range%TYPE;
1871: ln_key_range igs_en_atd_type_all.upper_enr_load_range%TYPE;
1872: lv_key_att_type igs_en_atd_type_all.attendance_type%TYPE;
1873: l_credit_pts NUMBER;
1874: l_fte VARCHAR2(10);
1875:

Line 1872: lv_key_att_type igs_en_atd_type_all.attendance_type%TYPE;

1868: get_rng_rec cur_get_rng%ROWTYPE;
1869:
1870: ln_min_range igs_en_atd_type_all.upper_enr_load_range%TYPE;
1871: ln_key_range igs_en_atd_type_all.upper_enr_load_range%TYPE;
1872: lv_key_att_type igs_en_atd_type_all.attendance_type%TYPE;
1873: l_credit_pts NUMBER;
1874: l_fte VARCHAR2(10);
1875:
1876: BEGIN