APPS.IGS_AV_LVL_LGCY_PUB dependencies on HZ_PARTIES

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

1172: /*
1173: check whether person is deceased or not
1174: */
1175: DECLARE
1176: CURSOR c_ind (cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
1177: SELECT deceased_ind
1178: FROM igs_pe_hz_parties
1179: WHERE party_id = cp_party_id;
1180: l_ind igs_pe_hz_parties.deceased_ind%TYPE;

Line 1178: FROM igs_pe_hz_parties

1174: */
1175: DECLARE
1176: CURSOR c_ind (cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
1177: SELECT deceased_ind
1178: FROM igs_pe_hz_parties
1179: WHERE party_id = cp_party_id;
1180: l_ind igs_pe_hz_parties.deceased_ind%TYPE;
1181: BEGIN
1182: OPEN c_ind (p_person_id);

Line 1180: l_ind igs_pe_hz_parties.deceased_ind%TYPE;

1176: CURSOR c_ind (cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
1177: SELECT deceased_ind
1178: FROM igs_pe_hz_parties
1179: WHERE party_id = cp_party_id;
1180: l_ind igs_pe_hz_parties.deceased_ind%TYPE;
1181: BEGIN
1182: OPEN c_ind (p_person_id);
1183: FETCH c_ind INTO l_ind;
1184: CLOSE c_ind;

Line 1197: FROM hz_parties hp, igs_pe_hz_parties ihp

1193: */
1194: DECLARE
1195: CURSOR c_exists (cp_exemption_institution_cd igs_or_inst_exempt_v.exemption_institution_cd%TYPE) IS
1196: SELECT 'x'
1197: FROM hz_parties hp, igs_pe_hz_parties ihp
1198: WHERE hp.party_id = ihp.party_id
1199: AND ihp.inst_org_ind = 'I'
1200: AND ihp.oi_govt_institution_cd IS NOT NULL
1201: AND ihp.oi_institution_status = 'ACTIVE'