APPS.IGS_GE_GEN_002 dependencies on IGS_GE_GEN_002

Line 1: PACKAGE BODY IGS_GE_GEN_002 AS

1: PACKAGE BODY IGS_GE_GEN_002 AS
2: /* $Header: IGSGE02B.pls 120.3 2006/01/25 09:13:08 skpandey ship $ */
3:
4: -------------------------------------------------------------------------------------------
5: -- Change History

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

271: WHERE padv.person_id = cp_person_id AND
272: padv.addr_type = cp_addr_type;
273:
274: CURSOR initial_name_cur(cp_person_id hz_parties.party_id%TYPE) IS
275: SELECT SUBSTR(igs_ge_gen_002.genp_get_initials(person_first_name), 1, 10) || ' ' || person_last_name
276: FROM hz_parties
277: WHERE party_id = cp_person_id;
278:
279:

Line 1261: END IGS_GE_GEN_002 ;

1257:
1258: END genp_get_prsn_names;
1259:
1260:
1261: END IGS_GE_GEN_002 ;