APPS.IGS_PS_USO_INSTRCTRS_PKG dependencies on HZ_PARTIES

Line 109: FROM hz_parties

105: || (reverse chronological order - newest change first)
106: */
107: CURSOR cur_rowid IS
108: SELECT rowid
109: FROM hz_parties
110: WHERE party_id = new_references.instructor_id
111: FOR UPDATE NOWAIT;
112:
113: lv_rowid cur_rowid%RowType;

Line 254: PROCEDURE get_fk_hz_parties (

250:
251: END get_fk_igs_ps_usec_occurs;
252:
253:
254: PROCEDURE get_fk_hz_parties (
255: x_party_id IN NUMBER
256: ) AS
257: /*
258: || Created By : [email protected]

Line 286: END get_fk_hz_parties;

282: RETURN;
283: END IF;
284: CLOSE cur_rowid;
285:
286: END get_fk_hz_parties;
287:
288:
289: PROCEDURE before_dml (
290: p_action IN VARCHAR2,