eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_GE_GEN_001 dependencies on HZ_PARTIES

Line 349: Instead the direct logic to retrieve it from hz_parties was introduced.

345: /* change history
346: WHO WHEN WHAT
347: pkpatel 17-APR-2003 Bug 2261717
348: Removed selection of initial_last_name, initial_name from igs_pe_person_v.
349: Instead the direct logic to retrieve it from hz_parties was introduced.
350: skpandey 13-JAN-2006 Bug#4937960
351: Changed c_per_name cursor definition to optimize query
352: */
353: BEGIN

Line 358: CURSOR c_per_name (cp_person_id hz_parties.party_id%TYPE)IS

354: DECLARE
355: -- Local Cursors
356: -- cursor for selection of the person name in seperate parts to allow
357: -- construction based on the user preferences
358: CURSOR c_per_name (cp_person_id hz_parties.party_id%TYPE)IS
359: SELECT p.PERSON_TITLE per_title,
360: p.PERSON_LAST_NAME per_surname,
361: NVL(P.KNOWN_AS,p.PERSON_FIRST_NAME) per_first_name,
362: NVL(P.KNOWN_AS, SUBSTR (P.PERSON_FIRST_NAME, 1, DECODE(INSTR(P.PERSON_FIRST_NAME, ' '), 0, LENGTH(P.PERSON_FIRST_NAME), (INSTR(P.PERSON_FIRST_NAME, ' ')-1)))) || ' ' || P.PERSON_LAST_NAME per_preferred_name ,

Line 365: FROM hz_parties p

361: NVL(P.KNOWN_AS,p.PERSON_FIRST_NAME) per_first_name,
362: NVL(P.KNOWN_AS, SUBSTR (P.PERSON_FIRST_NAME, 1, DECODE(INSTR(P.PERSON_FIRST_NAME, ' '), 0, LENGTH(P.PERSON_FIRST_NAME), (INSTR(P.PERSON_FIRST_NAME, ' ')-1)))) || ' ' || P.PERSON_LAST_NAME per_preferred_name ,
363: P.PERSON_TITLE || ' ' || p.PERSON_FIRST_NAME || ' ' || P.PERSON_LAST_NAME per_title_name ,
364: p.PERSON_LAST_NAME || ', ' || p.PERSON_TITLE || ' ' || NVL(p.KNOWN_AS,p.PERSON_FIRST_NAME) per_context_block_name
365: FROM hz_parties p
366: WHERE p.party_id = cp_person_id;
367:
368:
369: -- cursor for selection of the person address when

Line 399: CURSOR initial_name_cur(cp_person_id hz_parties.party_id%TYPE) IS

395: FROM IGS_PE_PERSON_ADDR_V padv
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:

Line 401: FROM hz_parties

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:
405: CURSOR initial_last_name_cur(cp_person_id hz_parties.party_id%TYPE) IS

Line 405: CURSOR initial_last_name_cur(cp_person_id hz_parties.party_id%TYPE) IS

401: FROM hz_parties
402: WHERE party_id = cp_person_id;
403:
404:
405: CURSOR initial_last_name_cur(cp_person_id hz_parties.party_id%TYPE) IS
406: SELECT RTRIM(DECODE(person_last_name,null,'',DECODE(person_first_name,null,person_last_name,person_last_name
407: || ', ' ) ) || NVL(person_first_name,'')|| ' '||person_middle_name,' ')
408: FROM hz_parties
409: WHERE party_id = cp_person_id;

Line 408: FROM hz_parties

404:
405: CURSOR initial_last_name_cur(cp_person_id hz_parties.party_id%TYPE) IS
406: SELECT RTRIM(DECODE(person_last_name,null,'',DECODE(person_first_name,null,person_last_name,person_last_name
407: || ', ' ) ) || NVL(person_first_name,'')|| ' '||person_middle_name,' ')
408: FROM hz_parties
409: WHERE party_id = cp_person_id;
410:
411:
412: -- Local Variables