APPS.IGS_PS_RSV_ORGUN_PRF_PKG dependencies on IGS_PS_RSV_OGPRI_ALL

Line 126: from IGS_PS_RSV_OGPRI_ALL PRI

122: cur_rec_hz_exists c_check_hz_exists%ROWTYPE;
123:
124: CURSOR c_priority is
125: Select priority_value
126: from IGS_PS_RSV_OGPRI_ALL PRI
127: Where PRI.RSV_ORG_UNIT_PRI_ID = new_references.rsv_org_unit_pri_id;
128: priority_value1 VARCHAR2(30);
129:
130: /*

Line 292: PROCEDURE get_fk_igs_ps_rsv_ogpri_all (

288:
289: END get_uk_for_validation ;
290:
291:
292: PROCEDURE get_fk_igs_ps_rsv_ogpri_all (
293: x_rsv_org_unit_pri_id IN NUMBER
294: ) AS
295: /*
296: || Created By : apelleti

Line 324: END get_fk_igs_ps_rsv_ogpri_all;

320: RETURN;
321: END IF;
322: CLOSE cur_rowid;
323:
324: END get_fk_igs_ps_rsv_ogpri_all;
325: PROCEDURE get_fk_igs_ps_ver_all (
326: x_preference_code IN VARCHAR2,
327: x_preference_version IN NUMBER
328: ) AS