73:
74: CURSOR c_find_person_no
75: IS
76: SELECT party_number
77: FROM hz_parties
78: WHERE party_id=p_person_id;
79:
80: v_person_number igs_pe_person.person_number%TYPE;
81:
785: /** Cursor for Delete record from igs_en_su_attempt**/
786:
787: CURSOR c_find_person_no IS
788: SELECT party_number
789: FROM hz_parties
790: WHERE party_id=p_person_id;
791:
792: v_person_number igs_pe_person.person_number%TYPE;
793: CURSOR c_incl_org_wlst_cp is