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 IGS_PE_PERSON_ADDR_V

Line 379: FROM IGS_PE_PERSON_ADDR_V padv

375: padv.addr_line_2 padv_addr_line_2,
376: padv.addr_line_3 padv_addr_line_3,
377: padv.addr_line_4 padv_addr_line_4,
378: padv.city padv_city
379: FROM IGS_PE_PERSON_ADDR_V padv
380: WHERE padv.person_id = cp_person_id AND
381: padv.correspondence_ind = 'Y';
382:
383: -- cursor for selection of the person address when

Line 395: FROM IGS_PE_PERSON_ADDR_V padv

391: padv.addr_line_2 padv_addr_line_2,
392: padv.addr_line_3 padv_addr_line_3,
393: padv.addr_line_4 padv_addr_line_4,
394: padv.city padv_city
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