APPS.IGS_FI_GET_SUAEH dependencies on IGS_EN_SU_ATTEMPT_H

Line 69: FROM IGS_EN_SU_ATTEMPT_H suah

65: LAST_UPDATE_LOGIN ,
66: DCNT_REASON_CD ,
67: ORG_ID ,
68: UOO_ID
69: FROM IGS_EN_SU_ATTEMPT_H suah
70: WHERE suah.person_id = p_person_id AND
71: suah.course_cd = cp_course_cd AND
72: suah.unit_cd = cp_unit_cd AND
73: cp_effective_dt BETWEEN suah.hist_start_dt AND

Line 80: p_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE,

76: r_suah r_t_suaeh_dtl;-- record type
77: v_suah_found BOOLEAN;
78: -------------------------------------------------------------------------------
79: PROCEDURE finpl_ins_sua_rec(
80: p_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE,
81: p_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE,
82: p_sua_rec IGS_EN_SU_ATTEMPT%ROWTYPE)
83: AS
84: BEGIN

Line 81: p_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE,

77: v_suah_found BOOLEAN;
78: -------------------------------------------------------------------------------
79: PROCEDURE finpl_ins_sua_rec(
80: p_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE,
81: p_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE,
82: p_sua_rec IGS_EN_SU_ATTEMPT%ROWTYPE)
83: AS
84: BEGIN
85: DECLARE

Line 326: p_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE,

322: end if;
323: END finpl_ins_suah_rec;
324: -------------------------------------------------------------------------------
325: PROCEDURE finpl_ins_suahv_rec (
326: p_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE,
327: p_suahv_rec IGS_AS_SUA_H_V%ROWTYPE)
328: AS
329: BEGIN
330: DECLARE