APPS.IGS_AD_HZ_EXTRACURR_ACT_PKG dependencies on HZ_PERSON_INTEREST

Line 81: FROM hz_person_interest

77:
78: PROCEDURE check_parent_existance AS
79: CURSOR cur_rowid IS
80: SELECT ROWID
81: FROM hz_person_interest
82: WHERE person_interest_id = new_references.person_interest_id ;
83: lv_rowid cur_rowid%ROWTYPE;
84: /*
85: || Created By : [email protected]

Line 158: PROCEDURE get_fk_hz_person_interest (

154: END IF;
155:
156: END get_pk_for_validation;
157:
158: PROCEDURE get_fk_hz_person_interest (
159: x_person_interest_id IN NUMBER
160: ) AS
161: /*
162: || Created By : [email protected]

Line 190: END get_fk_hz_person_interest;

186: RETURN;
187: END IF;
188: CLOSE cur_rowid;
189:
190: END get_fk_hz_person_interest;
191:
192:
193: PROCEDURE before_dml (
194: p_action IN VARCHAR2,

Line 717: anymore (start_date removed but present in HZ_PERSON_INTEREST)

713: Purpose : This has been added during the ID prospective applicant
714: part 2 of build. This peice of code was missing and has been
715: copied from an older version of the TBH and slighlty modidifed
716: to remove the reference to the item that do not exist in the table
717: anymore (start_date removed but present in HZ_PERSON_INTEREST)
718: The validation for end_date with out NOCOPY the start_date is not possible
719: hence removed that too.
720:
721: Know limitations, enhancements or remarks