APPS.IGS_DA_TRNS_IMP dependencies on IGS_PE_HZ_PARTIES

Line 97: FROM hz_parties p, igs_pe_hz_parties hp

93: AS
94: CURSOR c_val_inst_cd_non_uk_cur
95: IS
96: SELECT hp.ROWID row_id
97: FROM hz_parties p, igs_pe_hz_parties hp
98: WHERE hp.party_id = p.party_id
99: AND hp.inst_org_ind = 'I'
100: AND p.party_number = person_history_rec.prev_institution_code;
101:

Line 106: igs_pe_hz_parties hp,

102: CURSOR c_val_inst_cd_uk_cur
103: IS
104: SELECT hp.ROWID row_id
105: FROM hz_parties p,
106: igs_pe_hz_parties hp,
107: igs_or_org_inst_type_all oit
108: WHERE hp.party_id = p.party_id
109: AND hp.inst_org_ind = 'I'
110: AND p.party_number = person_history_rec.prev_institution_code

Line 1977: CURSOR c_ind (cp_party_id igs_pe_hz_parties.party_id%TYPE)

1973: /*
1974: check whether person is deceased or not
1975: */
1976: DECLARE
1977: CURSOR c_ind (cp_party_id igs_pe_hz_parties.party_id%TYPE)
1978: IS
1979: SELECT deceased_ind
1980: FROM igs_pe_hz_parties
1981: WHERE party_id = cp_party_id;

Line 1980: FROM igs_pe_hz_parties

1976: DECLARE
1977: CURSOR c_ind (cp_party_id igs_pe_hz_parties.party_id%TYPE)
1978: IS
1979: SELECT deceased_ind
1980: FROM igs_pe_hz_parties
1981: WHERE party_id = cp_party_id;
1982:
1983: l_ind igs_pe_hz_parties.deceased_ind%TYPE;
1984: BEGIN

Line 1983: l_ind igs_pe_hz_parties.deceased_ind%TYPE;

1979: SELECT deceased_ind
1980: FROM igs_pe_hz_parties
1981: WHERE party_id = cp_party_id;
1982:
1983: l_ind igs_pe_hz_parties.deceased_ind%TYPE;
1984: BEGIN
1985: OPEN c_ind (p_person_id);
1986: FETCH c_ind INTO l_ind;
1987: CLOSE c_ind;

Line 2019: FROM hz_parties hp, igs_pe_hz_parties ihp

2015: ihp.oss_org_unit_cd exemption_institution_cd, hp.party_name,
2016: ihp.oi_institution_status, 'INSTITUTION CODE' SOURCE, hp.created_by,
2017: hp.creation_date, hp.last_updated_by, hp.last_update_date,
2018: hp.last_update_login
2019: FROM hz_parties hp, igs_pe_hz_parties ihp
2020: WHERE hp.party_id = ihp.party_id
2021: AND ihp.inst_org_ind = 'I'
2022: AND ihp.oi_institution_status = 'ACTIVE'
2023: AND ihp.oss_org_unit_cd = cp_exemption_institution_cd;