APPS.IGS_AV_UNT_LGCY_PUB dependencies on HZ_PARTIES

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

610: /*
611: check whether person is deceased or not
612: */
613: DECLARE
614: CURSOR c_ind (cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
615: SELECT deceased_ind
616: FROM igs_pe_hz_parties
617: WHERE party_id = cp_party_id;
618: l_ind igs_pe_hz_parties.deceased_ind%TYPE;

Line 616: FROM igs_pe_hz_parties

612: */
613: DECLARE
614: CURSOR c_ind (cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
615: SELECT deceased_ind
616: FROM igs_pe_hz_parties
617: WHERE party_id = cp_party_id;
618: l_ind igs_pe_hz_parties.deceased_ind%TYPE;
619: BEGIN
620: OPEN c_ind (p_person_id);

Line 618: l_ind igs_pe_hz_parties.deceased_ind%TYPE;

614: CURSOR c_ind (cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
615: SELECT deceased_ind
616: FROM igs_pe_hz_parties
617: WHERE party_id = cp_party_id;
618: l_ind igs_pe_hz_parties.deceased_ind%TYPE;
619: BEGIN
620: OPEN c_ind (p_person_id);
621: FETCH c_ind INTO l_ind;
622: CLOSE c_ind;

Line 636: FROM hz_parties hp, igs_pe_hz_parties ihp

632: */
633: DECLARE
634: CURSOR c_validate_inst(cp_exemption_institution_cd p_lgcy_adstunt_rec.exemption_institution_cd%TYPE) IS
635: SELECT 'x'
636: FROM hz_parties hp, igs_pe_hz_parties ihp
637: WHERE hp.party_id = ihp.party_id
638: AND ihp.inst_org_ind = 'I'
639: AND ihp.oi_govt_institution_cd IS NOT NULL
640: AND ihp.oi_institution_status = 'ACTIVE'