APPS.IGS_EN_INS_CA_TRNSFR dependencies on IGS_RE_THS_EXAM_HIST

Line 677: FROM IGS_RE_THS_EXAM_HIST teh

673: cp_tex_creation_dt IGS_RE_THESIS_EXAM.creation_dt%TYPE) IS
674: SELECT teh.hist_start_dt,
675: teh.hist_end_dt,
676: teh.thesis_result_cd
677: FROM IGS_RE_THS_EXAM_HIST teh
678: WHERE teh.person_id = p_person_id AND
679: teh.ca_sequence_number = p_transfer_ca_sequence_number AND
680: teh.the_sequence_number = cp_tex_the_sequence_number AND
681: teh.creation_dt = cp_tex_creation_dt AND

Line 816: IGS_RE_THS_EXAM_HIST_PKG.INSERT_ROW (

812: l_rowid VARCHAR2(25);
813: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
814: BEGIN
815:
816: IGS_RE_THS_EXAM_HIST_PKG.INSERT_ROW (
817: x_rowid => l_rowid,
818: X_org_id => l_org_id,
819: x_person_id => p_person_id ,
820: x_ca_sequence_number => p_ca_sequence_number,