APPS.IGS_PE_PERSON_SS_PKG dependencies on HZ_RELATIONSHIPS

Line 2193: FROM hz_parties hp, hz_relationships hr

2189: P_COPY_PRIMARY_ADDR IN VARCHAR2
2190: ) IS
2191: CURSOR c_existing_rel(cp_first_name VARCHAR2, cp_last_name VARCHAR2,cp_subject_id NUMBER,cp_rel_code VARCHAR2)IS
2192: SELECT hr.object_id, hr.relationship_id
2193: FROM hz_parties hp, hz_relationships hr
2194: WHERE UPPER(hp.person_first_name) = UPPER(cp_first_name)
2195: AND UPPER(hp.person_last_name) = UPPER(cp_last_name)
2196: AND hp.party_id = hr.object_id
2197: AND hr.subject_id = cp_subject_id

Line 2299: FROM hz_relationships

2295: object_version_number ,
2296: direction_code ,
2297: percentage_ownership ,
2298: actual_content_source
2299: FROM hz_relationships
2300: WHERE relationship_id = cp_relationship_id
2301: AND directional_flag = cp_directional_flag;
2302:
2303: CURSOR c_rel_code(cp_rel_code VARCHAR2) IS

Line 2310: FROM hz_relationships hrel,igs_pe_hz_rel prel

2306: WHERE forward_rel_code = cp_rel_code;
2307:
2308: CURSOR c_primary(cp_subject_id NUMBER) IS
2309: SELECT 'X' ,prel.LAST_UPDATE_DATE
2310: FROM hz_relationships hrel,igs_pe_hz_rel prel
2311: WHERE hrel.relationship_id = prel.relationship_id
2312: AND hrel.directional_flag = prel.directional_flag
2313: AND hrel.subject_id = cp_subject_id
2314: AND prel.primary = 'Y';

Line 2318: FROM hz_relationships hrel,igs_pe_hz_rel prel

2314: AND prel.primary = 'Y';
2315:
2316: CURSOR c_secondary(cp_subject_id NUMBER) IS
2317: SELECT 'X' ,prel.LAST_UPDATE_DATE
2318: FROM hz_relationships hrel,igs_pe_hz_rel prel
2319: WHERE hrel.relationship_id = prel.relationship_id
2320: AND hrel.directional_flag = prel.directional_flag
2321: AND hrel.subject_id = cp_subject_id
2322: AND prel.secondary = 'Y';

Line 2393: l_hz_rel_ovn hz_relationships.object_version_number%TYPE;

2389: l_loc_rowid VARCHAR2(25);
2390: rec_student_addr c_location%ROWTYPE;
2391: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
2392: l_location_ovn hz_locations.object_version_number%TYPE;
2393: l_hz_rel_ovn hz_relationships.object_version_number%TYPE;
2394: l_party_site_id NUMBER;
2395: l_last_update_date DATE;
2396: l_party_site_use_rowid VARCHAR2(25);
2397: l_party_site_use_id NUMBER;