APPS.IGS_FI_GET_SCAEH dependencies on IGS_AS_SCA_H_V

Line 452: p_scahv_rec IGS_AS_SCA_H_V%ROWTYPE)

448: END finpl_ins_scah_rec;
449: -------------------------------------------------------------------------------
450: PROCEDURE finpl_ins_scahv_rec (
451: p_hist_start_dt IGS_AS_SC_ATTEMPT_H.hist_start_dt%TYPE,
452: p_scahv_rec IGS_AS_SCA_H_V%ROWTYPE)
453: AS
454: BEGIN
455: gr_scaeh.r_scah.person_id := p_scahv_rec.person_id;
456: gr_scaeh.r_scah.course_cd := p_scahv_rec.course_cd;

Line 527: FROM IGS_AS_SCA_H_V scahv

523: BEGIN
524: DECLARE
525: CURSOR c_scahv_last_enr (cp_effective_dt DATE) IS
526: SELECT *
527: FROM IGS_AS_SCA_H_V scahv
528: WHERE scahv.person_id = p_person_id AND
529: scahv.course_cd = p_course_cd AND
530: scahv.course_attempt_status = 'ENROLLED' AND
531: cp_effective_dt <= scahv.hist_start_dt

Line 533: r_scahv IGS_AS_SCA_H_V%ROWTYPE;

529: scahv.course_cd = p_course_cd AND
530: scahv.course_attempt_status = 'ENROLLED' AND
531: cp_effective_dt <= scahv.hist_start_dt
532: ORDER BY scahv.hist_start_dt desc;
533: r_scahv IGS_AS_SCA_H_V%ROWTYPE;
534: BEGIN
535: -- check the last enrolled history for a match
536: OPEN c_scahv_last_enr(p_sca_rec.commencement_dt);
537: FETCH c_scahv_last_enr INTO r_scahv;