DBA Data[Home] [Help]

APPS.IGF_SL_LAR_CREATION dependencies on IGF_GR_ATTEND_PELL

Line 532: p_atd_entity_id igf_gr_attend_pell.atd_entity_id_txt%TYPE

528: IS
529: CURSOR c_get_rep_entity_id_txt(
530: p_cal_type igs_ca_inst.cal_type%TYPE,
531: p_seq_num igs_ca_inst.sequence_number%TYPE,
532: p_atd_entity_id igf_gr_attend_pell.atd_entity_id_txt%TYPE
533: )
534: IS
535: SELECT rep.rep_entity_id_txt
536: FROM igf_gr_attend_pell gap, igf_gr_report_pell rep

Line 536: FROM igf_gr_attend_pell gap, igf_gr_report_pell rep

532: p_atd_entity_id igf_gr_attend_pell.atd_entity_id_txt%TYPE
533: )
534: IS
535: SELECT rep.rep_entity_id_txt
536: FROM igf_gr_attend_pell gap, igf_gr_report_pell rep
537: WHERE gap.ci_cal_type = p_cal_type
538: AND gap.ci_sequence_number = p_seq_num
539: AND gap.atd_entity_id_txt = p_atd_entity_id
540: AND gap.rcampus_id = rep.rcampus_id;