APPS.IGS_OR_INST_IMP_003_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 394: CURSOR check_person_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

390: AND view_application_id = 222
391: AND security_group_id = 0
392: AND language = userenv('LANG');
393:
394: CURSOR check_person_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
395: SELECT 'X'
396: FROM igs_pe_person_base_v
397: WHERE person_id = cp_person_id;
398:

Line 396: FROM igs_pe_person_base_v

392: AND language = userenv('LANG');
393:
394: CURSOR check_person_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
395: SELECT 'X'
396: FROM igs_pe_person_base_v
397: WHERE person_id = cp_person_id;
398:
399: oss_cont_rec cur_get_oss_contacts%ROWTYPE;
400: c_val_contact_title_rec c_val_contact_title%ROWTYPE;