APPS.IGF_GR_GEN_XML dependencies on IGF_GR_REPORT_PELL

Line 337: cp_source_entity_id igf_gr_report_pell.rep_entity_id_txt%TYPE) IS

333:
334: -- To get source entity id from Pell ID/Entity ID relationships.
335: CURSOR cur_source_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,
336: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
337: cp_source_entity_id igf_gr_report_pell.rep_entity_id_txt%TYPE) IS
338: SELECT 'x'
339: FROM IGF_GR_REPORT_PELL rep
340: WHERE rep.ci_cal_type = cp_cal_type
341: AND rep.ci_sequence_number = cp_sequence_number

Line 339: FROM IGF_GR_REPORT_PELL rep

335: CURSOR cur_source_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,
336: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
337: cp_source_entity_id igf_gr_report_pell.rep_entity_id_txt%TYPE) IS
338: SELECT 'x'
339: FROM IGF_GR_REPORT_PELL rep
340: WHERE rep.ci_cal_type = cp_cal_type
341: AND rep.ci_sequence_number = cp_sequence_number
342: AND rep.rep_entity_id_txt = cp_source_entity_id;
343:

Line 1137: CURSOR cur_attending_entity ( cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,

1133: Who When What
1134: (reverse chronological order - newest change first)
1135: ***************************************************************/
1136:
1137: CURSOR cur_attending_entity ( cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,
1138: cp_ci_sequence_number igf_gr_report_pell.ci_sequence_number%TYPE,
1139: cp_rep_entity_id_txt igf_gr_report_pell.rep_entity_id_txt%TYPE,
1140: cp_atd_entity_id_txt igf_gr_attend_pell.atd_entity_id_txt%TYPE) IS
1141: SELECT 'Y'

Line 1138: cp_ci_sequence_number igf_gr_report_pell.ci_sequence_number%TYPE,

1134: (reverse chronological order - newest change first)
1135: ***************************************************************/
1136:
1137: CURSOR cur_attending_entity ( cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,
1138: cp_ci_sequence_number igf_gr_report_pell.ci_sequence_number%TYPE,
1139: cp_rep_entity_id_txt igf_gr_report_pell.rep_entity_id_txt%TYPE,
1140: cp_atd_entity_id_txt igf_gr_attend_pell.atd_entity_id_txt%TYPE) IS
1141: SELECT 'Y'
1142: FROM IGF_GR_REPORT_PELL rep, IGF_GR_ATTEND_PELL atd

Line 1139: cp_rep_entity_id_txt igf_gr_report_pell.rep_entity_id_txt%TYPE,

1135: ***************************************************************/
1136:
1137: CURSOR cur_attending_entity ( cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,
1138: cp_ci_sequence_number igf_gr_report_pell.ci_sequence_number%TYPE,
1139: cp_rep_entity_id_txt igf_gr_report_pell.rep_entity_id_txt%TYPE,
1140: cp_atd_entity_id_txt igf_gr_attend_pell.atd_entity_id_txt%TYPE) IS
1141: SELECT 'Y'
1142: FROM IGF_GR_REPORT_PELL rep, IGF_GR_ATTEND_PELL atd
1143: WHERE rep.rcampus_id = atd.rcampus_id

Line 1142: FROM IGF_GR_REPORT_PELL rep, IGF_GR_ATTEND_PELL atd

1138: cp_ci_sequence_number igf_gr_report_pell.ci_sequence_number%TYPE,
1139: cp_rep_entity_id_txt igf_gr_report_pell.rep_entity_id_txt%TYPE,
1140: cp_atd_entity_id_txt igf_gr_attend_pell.atd_entity_id_txt%TYPE) IS
1141: SELECT 'Y'
1142: FROM IGF_GR_REPORT_PELL rep, IGF_GR_ATTEND_PELL atd
1143: WHERE rep.rcampus_id = atd.rcampus_id
1144: AND rep.ci_cal_type = cp_ci_cal_type
1145: AND rep.ci_sequence_number = cp_ci_sequence_number
1146: AND rep.rep_entity_id_txt = cp_rep_entity_id_txt