DBA Data[Home] [Help]

APPS.IGF_GR_PELL dependencies on IGF_GR_ATTEND_PELL

Line 365: igf_gr_attend_pell gap,

361: CURSOR c_get_rep_pell_id(cp_cal_type VARCHAR2,cp_seq_num NUMBER,cp_att_pell_id VARCHAR2)
362: IS
363: SELECT rep.reporting_pell_cd
364: FROM
365: igf_gr_attend_pell gap,
366: igf_gr_report_pell rep
367: WHERE
368: gap.ci_cal_type = cp_cal_type AND
369: gap.ci_sequence_number = cp_seq_num AND

Line 379: FROM igf_gr_attend_pell att,

375: CURSOR c_get_rep_entity_id(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
376: cp_seq_num igs_ca_inst_all.sequence_number%TYPE,
377: cp_atd_entity_id igf_gr_rfms_all.atd_entity_id_txt%TYPE) IS
378: SELECT rep.rep_entity_id_txt
379: FROM igf_gr_attend_pell att,
380: igf_gr_report_pell rep
381: WHERE att.rcampus_id = rep.rcampus_id
382: AND att.ci_cal_type = cp_cal_type
383: AND att.ci_sequence_number = cp_seq_num