172: || (reverse chronological order - newest change first)
173: */
174: CURSOR cur_rowid IS
175: SELECT rowid
176: FROM hz_parties
177: WHERE party_id = new_references.instructor_id
178: FOR UPDATE NOWAIT;
179:
180: lv_rowid cur_rowid%RowType;
464:
465: END get_ufk_igs_ps_unit_ofr_opt;
466:
467:
468: PROCEDURE get_fk_hz_parties (
469: x_party_id IN NUMBER
470: ) AS
471: /*
472: || Created By : [email protected]
496: RETURN;
497: END IF;
498: CLOSE cur_rowid;
499:
500: END get_fk_hz_parties;
501:
502: PROCEDURE get_fk_igs_ps_usec_act_type (
503: x_activity_type_id IN NUMBER
504: ) AS