APPS.IGS_HE_UCAS_TARIFF_PKG dependencies on IGS_PE_PERSON

Line 55: CURSOR c_person_number (cp_person_id igs_pe_person.person_id%TYPE ) IS

51: -- jchakrab 04-May-06 Modified for 5203018 - closed cursor created using DBMS_SQL
52: --------------------------------------------------------------------------*/
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 ;

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 59: l_person_number igs_pe_person.person_number%TYPE ;

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
62: CURSOR prg_group_mem_cur (cp_course_cd igs_ps_grp_mbr.course_cd%TYPE,
63: cp_version igs_ps_grp_mbr.version_number%TYPE) IS

Line 878: CURSOR person_number_cur (cp_person_id igs_pe_person.person_id%TYPE ) IS

874: CONNECT BY PRIOR parent_award_cd=award_cd
875: AND tariff_calc_type_cd = cp_tariff_calc_type;
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:

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:

Line 883: l_person_number igs_pe_person.person_number%TYPE ;

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:
885: -- check whether person + calculation type already exists.
886: CURSOR check_prsn_tariff_exists_cur (cp_person_id igs_he_ut_prs_calcs.person_id%TYPE,
887: cp_calc_type igs_he_ut_prs_calcs.tariff_calc_type_cd%TYPE) IS