909: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
910: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
911: ) IS
912: SELECT pell.pell_att_code attendance_type
913: FROM igf_ap_fa_ant_data ant,
914: igf_ap_attend_map pell,
915: igf_ap_fa_base_rec_all fa
916: WHERE fa.base_id = cp_base_id
917: AND ant.ld_cal_type = cp_ld_cal_type
2163: prog.version_number key_prog_ver
2164: FROM
2165: igf_aw_dp_terms terms,
2166: igf_aw_dp_teach_prds_v teach,
2167: igf_ap_fa_ant_data ant_data,
2168: igs_ps_ver prog
2169: WHERE
2170: terms.adplans_id = cp_plan_id AND
2171: teach.adterms_id = terms.adterms_id AND
3222: SELECT
3223: ant_data.program_cd key_prog,
3224: prog.version_number key_prog_ver
3225: FROM
3226: igf_ap_fa_ant_data ant_data,
3227: igs_ps_ver prog
3228: WHERE
3229: ant_data.ld_cal_type = cp_ld_cal_type AND
3230: ant_data.ld_sequence_number = cp_ld_sequence_number AND
3515: ant_data.program_cd key_prog,
3516: prog.version_number key_prog_ver
3517: FROM
3518: igf_aw_awd_ld_cal_v awd_year_terms,
3519: igf_ap_fa_ant_data ant_data,
3520: igs_ps_ver prog
3521: WHERE
3522: ant_data.ld_cal_type = awd_year_terms.ld_cal_type AND
3523: ant_data.ld_sequence_number = awd_year_terms.ld_sequence_number AND