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

Line 288: igs_pe_hz_parties pd,

284: pd.military_service_reg ,
285: pd.veteran ,
286: p.object_version_number
287: FROM hz_parties p,
288: igs_pe_hz_parties pd,
289: hz_person_profiles pp
290: WHERE p.party_id = cp_person_id
291: AND p.party_id = pd.party_id (+)
292: AND p.party_id = pp.party_id

Line 1410: CURSOR pehz_cur (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS

1406: l_party_rec_type Hz_Party_V2Pub.PARTY_REC_TYPE;
1407: v_party_last_update_date hz_person_profiles.last_update_date%TYPE;
1408: lv_perosn_profile_id hz_person_profiles.person_profile_id%TYPE;
1409:
1410: CURSOR pehz_cur (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
1411: SELECT pehz.ROWID, pehz.*
1412: FROM IGS_PE_HZ_PARTIES pehz
1413: WHERE party_id = cp_person_id;
1414:

Line 1412: FROM IGS_PE_HZ_PARTIES pehz

1408: lv_perosn_profile_id hz_person_profiles.person_profile_id%TYPE;
1409:
1410: CURSOR pehz_cur (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
1411: SELECT pehz.ROWID, pehz.*
1412: FROM IGS_PE_HZ_PARTIES pehz
1413: WHERE party_id = cp_person_id;
1414:
1415: tlinfo2 pehz_cur%ROWTYPE;
1416:

Line 1417: CURSOR c_pe_stat (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS

1413: WHERE party_id = cp_person_id;
1414:
1415: tlinfo2 pehz_cur%ROWTYPE;
1416:
1417: CURSOR c_pe_stat (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
1418: SELECT
1419: p.rowid row_id,
1420: pp.person_profile_id,
1421: p.party_id person_id,

Line 1682: IGS_PE_HZ_PARTIES_PKG.ADD_ROW(

1678: FETCH pehz_cur INTO tlinfo2;
1679:
1680: -- PRBHARDW replaced update_row with add_row as part of BUG 5248350
1681:
1682: IGS_PE_HZ_PARTIES_PKG.ADD_ROW(
1683: X_ROWID => tlinfo2.ROWID,
1684: X_PARTY_ID => P_PERSON_ID,
1685: X_DECEASED_IND => tlinfo2.deceased_ind,
1686: X_ARCHIVE_EXCLUSION_IND => tlinfo2.archive_exclusion_ind,

Line 2265: igs_pe_hz_parties pd,

2261: pd.felony_convicted_flag,
2262: p.last_update_date
2263: FROM
2264: hz_parties p,
2265: igs_pe_hz_parties pd,
2266: hz_person_profiles pp
2267: WHERE p.party_id = cp_object_id
2268: AND p.party_id = pd.party_id (+)
2269: AND p.party_id = pp.party_id