DBA Data[Home] [Help]

APPS.IGF_GR_PELL_CALC dependencies on IGF_AP_FA_ANT_DATA

Line 913: FROM igf_ap_fa_ant_data ant,

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

Line 2167: igf_ap_fa_ant_data ant_data,

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

Line 3226: igf_ap_fa_ant_data ant_data,

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

Line 3519: igf_ap_fa_ant_data ant_data,

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