APPS.IGS_PE_PERSON_SS_PKG dependencies on HZ_PERSON_PROFILES

Line 289: hz_person_profiles pp

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
293: AND SYSDATE BETWEEN pp.effective_start_date AND NVL(pp.effective_end_date,SYSDATE);

Line 1407: v_party_last_update_date hz_person_profiles.last_update_date%TYPE;

1403: ) IS
1404:
1405: l_person_rec_type Hz_Party_V2Pub.PERSON_REC_TYPE;
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.*

Line 1408: lv_perosn_profile_id hz_person_profiles.person_profile_id%TYPE;

1404:
1405: l_person_rec_type Hz_Party_V2Pub.PERSON_REC_TYPE;
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

Line 1498: hz_person_profiles pp,

1494: pp.content_source_number,
1495: p.object_version_number object_version_number,
1496: sd.birth_cntry_resn_code
1497: FROM
1498: hz_person_profiles pp,
1499: igs_pe_stat_details sd,
1500: hz_parties p
1501: WHERE
1502: sd.person_id(+) = p.party_id AND

Line 2266: hz_person_profiles pp

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
2270: AND SYSDATE BETWEEN pp.effective_start_date AND NVL(pp.effective_end_date,SYSDATE);