APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on IGS_PE_HZ_REL

Line 4592: FROM igs_pe_hz_rel_v hz

4588: WHERE person_id = p_id;
4589:
4590: CURSOR c_spouse_of_rel IS
4591: SELECT COUNT(1)
4592: FROM igs_pe_hz_rel_v hz
4593: WHERE hz.subject_id = p_person_rec.person_id AND
4594: hz.relationship_code= 'SPOUSE_OF' and
4595: sysdate BETWEEN hz.start_date AND NVL(hz.end_date, sysdate+1)
4596: AND EXISTS (SELECT 1 FROM igs_pe_depd_active pdep

Line 10585: FROM igs_pe_hz_rel_v hz, igs_pe_depd_active pdep

10581: l_rel_type_count NUMBER := 0;
10582:
10583: /* CURSOR c_spouse_of_rel IS
10584: SELECT COUNT(1)
10585: FROM igs_pe_hz_rel_v hz, igs_pe_depd_active pdep
10586: WHERE hz.subject_id = p_person_rec.person_id AND
10587: hz.relationship_code= 'SPOUSE_OF' and
10588: pdep.relationship_id = hz.relationship_id
10589: and pdep.action_code <> 'T'

Line 13846: FROM igs_pe_hz_rel

13842:
13843: CURSOR c_old_rel_values(cp_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE, cp_dir_flag HZ_RELATIONSHIPS.DIRECTIONAL_FLAG%TYPE) IS
13844: SELECT directional_flag, primary, secondary, joint_salutation, next_to_kin, rep_faculty, rep_staff,
13845: rep_student, rep_alumni, emergency_contact_flag
13846: FROM igs_pe_hz_rel
13847: WHERE relationship_id = cp_rel_id
13848: AND directional_flag = cp_dir_flag; -- fix for bug 5258405
13849:
13850: CURSOR c_get_person_num(cp_person_id hz_parties.party_id%TYPE) IS