APPS.IGS_EN_PRC_LOAD dependencies on IGS_PE_PERSON

Line 1093: cp_person_id IGS_PE_PERSON.person_id%TYPE,

1089: -- CI.cal_type,
1090: -- CI.sequence_number,
1091: -- 'N') = 'Y');
1092: CURSOR c_stu_unit_atmpt(
1093: cp_person_id IGS_PE_PERSON.person_id%TYPE,
1094: cp_course_cd IGS_PS_COURSE.course_cd%TYPE,
1095: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1096: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1097: SELECT SUA.unit_cd,

Line 1812: CURSOR c_spa(cp_person_id IGS_PE_PERSON.person_id%TYPE,

1808: WHERE party_id=p_person_id;
1809:
1810: l_person hz_parties.party_number%TYPE;
1811:
1812: CURSOR c_spa(cp_person_id IGS_PE_PERSON.person_id%TYPE,
1813: cp_load_cal_type IGS_EN_SPA_TERMS.term_cal_type%TYPE,
1814: cp_load_seq_number IGS_EN_SPA_TERMS.term_sequence_number%TYPE) IS
1815: Select sca.course_cd
1816: From igs_en_stdnt_ps_att_all sca,