APPS.IGS_EN_GEN_016 dependencies on IGS_PE_PERSON_BASE_V

Line 54: FROM igs_pe_person_base_v pe

50: -- cursor to fetch person_id
51: --
52: CURSOR get_person_number (p_person_number IN VARCHAR2 ) IS
53: SELECT pe.person_id
54: FROM igs_pe_person_base_v pe
55: WHERE pe.person_number = p_person_number;
56:
57: -- cursor to validate course_cd
58: --

Line 889: FROM igs_pe_person_base_v

885: --
886: -- get the person details
887: CURSOR cur_person_dtl(p_person_number VARCHAR2) IS
888: SELECT person_id,full_name
889: FROM igs_pe_person_base_v
890: WHERE person_number = p_person_number;
891:
892: --
893: -- cursor to fetch value for prefered person id type.

Line 917: l_person_id igs_pe_person_base_v.person_id%TYPE;

913: WHERE int.batch_id = p_batch_id ;
914:
915: l_batch_desc igs_en_reg_btch_int.batch_description%TYPE;
916: l_pref_per_type igs_pe_person_id_typ.person_id_type%TYPE;
917: l_person_id igs_pe_person_base_v.person_id%TYPE;
918: l_full_name igs_pe_person_base_v.full_name%TYPE;
919: l_alt_pers_id igs_pe_alt_pers_id.api_person_id%TYPE;
920: l_batch_id_label VARCHAR2(200);
921: l_batch_desc_label VARCHAR2(200);

Line 918: l_full_name igs_pe_person_base_v.full_name%TYPE;

914:
915: l_batch_desc igs_en_reg_btch_int.batch_description%TYPE;
916: l_pref_per_type igs_pe_person_id_typ.person_id_type%TYPE;
917: l_person_id igs_pe_person_base_v.person_id%TYPE;
918: l_full_name igs_pe_person_base_v.full_name%TYPE;
919: l_alt_pers_id igs_pe_alt_pers_id.api_person_id%TYPE;
920: l_batch_id_label VARCHAR2(200);
921: l_batch_desc_label VARCHAR2(200);
922: l_error_rec VARCHAR2(1):= 'N' ;