APPS.IGS_GE_GEN_001 dependencies on IGS_GE_GEN_002

Line 400: SELECT SUBSTR(igs_ge_gen_002.genp_get_initials(person_first_name), 1, 10) || ' ' || person_last_name

396: WHERE padv.person_id = cp_person_id AND
397: padv.addr_type = cp_addr_type;
398:
399: CURSOR initial_name_cur(cp_person_id hz_parties.party_id%TYPE) IS
400: SELECT SUBSTR(igs_ge_gen_002.genp_get_initials(person_first_name), 1, 10) || ' ' || person_last_name
401: FROM hz_parties
402: WHERE party_id = cp_person_id;
403:
404: