APPS.IGS_EN_GEN_010 dependencies on HZ_PARTIES

Line 8642: IS SELECT party_number FROM hz_parties

8638: AND ci_sequence_number = p_teach_seq_num
8639: AND location_cd = p_location_cd
8640: AND unit_class = p_unit_class;
8641: CURSOR c_per_num
8642: IS SELECT party_number FROM hz_parties
8643: WHERE party_id = p_person_id;
8644:
8645: CURSOR cur_course_type (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
8646: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

Line 9149: supervisor_id HZ_PARTIES.PARTY_ID%TYPE);

9145: l_sup_exists BOOLEAN;
9146: l_fac_exists BOOLEAN;
9147:
9148: TYPE r_sup_rec_type IS RECORD (
9149: supervisor_id HZ_PARTIES.PARTY_ID%TYPE);
9150: TYPE t_sup_tab IS TABLE of r_sup_rec_type INDEX BY BINARY_INTEGER;
9151:
9152: v_sup_tab t_sup_tab;
9153: v_sup_index BINARY_INTEGER;

Line 9156: faculty_id HZ_PARTIES.PARTY_ID%TYPE);

9152: v_sup_tab t_sup_tab;
9153: v_sup_index BINARY_INTEGER;
9154:
9155: TYPE r_fac_rec_type IS RECORD (
9156: faculty_id HZ_PARTIES.PARTY_ID%TYPE);
9157: TYPE t_fac_tab IS TABLE of r_fac_rec_type INDEX BY BINARY_INTEGER;
9158:
9159: v_fac_tab t_fac_tab;
9160: v_fac_index BINARY_INTEGER;