APPS.IGF_GR_PELL_CALC dependencies on IGS_PS_VER

Line 66: FROM igs_ps_ver_all

62:
63: CURSOR cur_get_anl_instr_time
64: IS
65: SELECT annual_instruction_time
66: FROM igs_ps_ver_all
67: WHERE course_cd = p_course_cd
68: AND version_number = p_version_number;
69:
70: get_anl_instr_time_rec cur_get_anl_instr_time%ROWTYPE;

Line 209: p_key_prog_cd OUT NOCOPY igs_ps_ver.course_cd%TYPE,

205: END get_pm_3_acad_term_wks;
206:
207: PROCEDURE get_key_prog_ver_frm_adm(
208: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
209: p_key_prog_cd OUT NOCOPY igs_ps_ver.course_cd%TYPE,
210: p_key_prog_ver OUT NOCOPY igs_ps_ver.version_number%TYPE
211: )
212: IS
213: /*

Line 210: p_key_prog_ver OUT NOCOPY igs_ps_ver.version_number%TYPE

206:
207: PROCEDURE get_key_prog_ver_frm_adm(
208: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
209: p_key_prog_cd OUT NOCOPY igs_ps_ver.course_cd%TYPE,
210: p_key_prog_ver OUT NOCOPY igs_ps_ver.version_number%TYPE
211: )
212: IS
213: /*
214: || Created By : museshad

Line 2142: igs_ps_ver pver,

2138: SELECT ptype.fin_aid_program_type prog_type
2139: FROM
2140: igs_en_stdnt_ps_att en,
2141: igf_ap_fa_base_rec fa,
2142: igs_ps_ver pver,
2143: igs_ps_type_v ptype
2144: WHERE
2145: fa.base_id = l_base_id AND
2146: en.person_id = fa.person_id AND

Line 2168: igs_ps_ver prog

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
2172: ant_data.ld_cal_type = terms.ld_cal_type AND

Line 3086: igs_ps_ver pver,

3082: SELECT ptype.FIN_AID_PROGRAM_TYPE prog_type
3083: FROM
3084: igs_en_stdnt_ps_att en,
3085: igf_ap_fa_base_rec fa,
3086: igs_ps_ver pver,
3087: igs_ps_type_v ptype
3088: WHERE
3089: fa.base_id = l_base_id AND
3090: en.person_id = fa.person_id AND

Line 3227: igs_ps_ver prog

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
3231: ant_data.base_id = cp_base_id AND

Line 3520: igs_ps_ver 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
3524: ant_data.base_id = cp_base_id and