DBA Data[Home] [Help]

APPS.IGS_HE_UCAS_TARIFF_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 57: FROM igs_pe_person_base_v

53:
54: -- get the person number for the person id
55: CURSOR c_person_number (cp_person_id igs_pe_person.person_id%TYPE ) IS
56: SELECT person_number
57: FROM igs_pe_person_base_v
58: WHERE person_id = cp_person_id ;
59: l_person_number igs_pe_person.person_number%TYPE ;
60:
61: -- cursor to validate that the course is attached to the program group

Line 880: FROM igs_pe_person_base_v

876:
877: -- get the person number for the person id for logging user message
878: CURSOR person_number_cur (cp_person_id igs_pe_person.person_id%TYPE ) IS
879: SELECT person_number
880: FROM igs_pe_person_base_v
881: WHERE person_id = cp_person_id;
882:
883: l_person_number igs_pe_person.person_number%TYPE ;
884: