APPS.IGS_AD_LOCVENUE_ADDR_PKG dependencies on HZ_LOCATIONS

Line 122: FROM HZ_LOCATIONS

118: PROCEDURE check_parent_existance
119: AS
120: CURSOR cur_rowid IS
121: SELECT rowid
122: FROM HZ_LOCATIONS
123: WHERE LOCATION_ID = new_references.LOCATION_ID ;
124: lv_rowid cur_rowid%RowType;
125: /*
126: || Created By : [email protected]

Line 213: PROCEDURE get_fk_igs_pe_hz_locations (

209:
210: END get_pk_for_validation;
211:
212:
213: PROCEDURE get_fk_igs_pe_hz_locations (
214: x_location_id IN NUMBER
215: ) AS
216: /*
217: || Created By : [email protected]

Line 245: END get_fk_igs_pe_hz_locations;

241: RETURN;
242: END IF;
243: CLOSE cur_rowid;
244:
245: END get_fk_igs_pe_hz_locations;
246:
247:
248: PROCEDURE before_dml (
249: p_action IN VARCHAR2,