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_PE_PERSID_GROUP_PKG dependencies on IGS_PE_HZ_PARTIES

Line 527: CURSOR is_creator_deceased IS SELECT deceased_ind FROM igs_pe_hz_parties WHERE party_id = x_creator_person_id;

523:
524: x_last_update_login IN NUMBER DEFAULT NULL
525:
526: ) AS
527: CURSOR is_creator_deceased IS SELECT deceased_ind FROM igs_pe_hz_parties WHERE party_id = x_creator_person_id;
528: CURSOR is_creator_too_young IS SELECT date_of_birth FROM HZ_PERSON_PROFILES where party_id = x_creator_person_id AND effective_end_date IS NULL;
529:
530: l_deceased_ind IGS_PE_HZ_PARTIES.deceased_ind%TYPE;
531: l_date_of_birth HZ_PERSON_PROFILES.date_of_birth%TYPE;

Line 530: l_deceased_ind IGS_PE_HZ_PARTIES.deceased_ind%TYPE;

526: ) AS
527: CURSOR is_creator_deceased IS SELECT deceased_ind FROM igs_pe_hz_parties WHERE party_id = x_creator_person_id;
528: CURSOR is_creator_too_young IS SELECT date_of_birth FROM HZ_PERSON_PROFILES where party_id = x_creator_person_id AND effective_end_date IS NULL;
529:
530: l_deceased_ind IGS_PE_HZ_PARTIES.deceased_ind%TYPE;
531: l_date_of_birth HZ_PERSON_PROFILES.date_of_birth%TYPE;
532:
533: BEGIN
534: Set_Column_Values (