APPS.IGS_FI_GET_SUAEH dependencies on IGS_AS_SUA_H_V

Line 327: p_suahv_rec IGS_AS_SUA_H_V%ROWTYPE)

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
331: v_suah_rec r_t_suaeh_dtl;

Line 398: FROM IGS_AS_SUA_H_V suahv

394: cp_course_cd IGS_PS_COURSE.course_cd%TYPE,
395: cp_unit_cd IGS_PS_UNIT.unit_cd%TYPE,
396: cp_effective_dt DATE) IS
397: SELECT *
398: FROM IGS_AS_SUA_H_V suahv
399: WHERE suahv.person_id = p_person_id AND
400: suahv.course_cd = cp_course_cd AND
401: suahv.unit_cd = cp_unit_cd AND
402: suahv.unit_attempt_status = 'ENROLLED' AND

Line 405: r_suahv IGS_AS_SUA_H_V%ROWTYPE;

401: suahv.unit_cd = cp_unit_cd AND
402: suahv.unit_attempt_status = 'ENROLLED' AND
403: cp_effective_dt <= suahv.hist_start_dt
404: ORDER BY suahv.hist_start_dt desc;
405: r_suahv IGS_AS_SUA_H_V%ROWTYPE;
406: BEGIN
407: -- check the last enrolled history for a match
408: --commented by syam to avoid adchkdrv errors -dbms_output.put_line(' IN PROCEDURE (DECLARE) START : IGS_FI_GET_SUAEH.finpl_prc_sua_enrhist');
409: