DBA Data[Home] [Help]

APPS.IGS_PE_PERSON_ALIAS_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 100: FROM igs_pe_person_base_v

96:
97: CURSOR get_dob_dt_cur(cp_person_id igs_pe_passport.person_id%TYPE)
98: IS
99: SELECT birth_date
100: FROM igs_pe_person_base_v
101: WHERE person_id = cp_person_id;
102: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
103: v_message_name varchar2(30);
104: BEGIN

Line 102: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;

98: IS
99: SELECT birth_date
100: FROM igs_pe_person_base_v
101: WHERE person_id = cp_person_id;
102: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
103: v_message_name varchar2(30);
104: BEGIN
105: -- If trigger has not been disabled, perform required processing
106: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_PE_PERSON_ALIAS') THEN