APPS.IGS_EN_GEN_015 dependencies on IGS_AS_SC_ATTEMPT_H

Line 1661: CURSOR cur_sca_active_dt( p_person_id igs_as_sc_attempt_h_all.person_id%TYPE,

1657: cur_ca_inst_rec cur_ca_inst%ROWTYPE;
1658:
1659:
1660: -- Cursor find the Date at which the Student Program Attempt became 'ACTIVE'
1661: CURSOR cur_sca_active_dt( p_person_id igs_as_sc_attempt_h_all.person_id%TYPE,
1662: p_course_cd igs_as_sc_attempt_h_all.course_cd%TYPE ) IS
1663: SELECT NVL(SCAH1.hist_start_dt,SCA1.last_update_date) hist_start_dt
1664: FROM IGS_AS_SC_ATTEMPT_H scah1, IGS_EN_STDNT_PS_ATT_ALL SCA1
1665: WHERE SCA1.person_id = SCAH1.person_id(+)

Line 1662: p_course_cd igs_as_sc_attempt_h_all.course_cd%TYPE ) IS

1658:
1659:
1660: -- Cursor find the Date at which the Student Program Attempt became 'ACTIVE'
1661: CURSOR cur_sca_active_dt( p_person_id igs_as_sc_attempt_h_all.person_id%TYPE,
1662: p_course_cd igs_as_sc_attempt_h_all.course_cd%TYPE ) IS
1663: SELECT NVL(SCAH1.hist_start_dt,SCA1.last_update_date) hist_start_dt
1664: FROM IGS_AS_SC_ATTEMPT_H scah1, IGS_EN_STDNT_PS_ATT_ALL SCA1
1665: WHERE SCA1.person_id = SCAH1.person_id(+)
1666: AND SCA1.course_cd = SCAH1.course_cd(+)

Line 1664: FROM IGS_AS_SC_ATTEMPT_H scah1, IGS_EN_STDNT_PS_ATT_ALL SCA1

1660: -- Cursor find the Date at which the Student Program Attempt became 'ACTIVE'
1661: CURSOR cur_sca_active_dt( p_person_id igs_as_sc_attempt_h_all.person_id%TYPE,
1662: p_course_cd igs_as_sc_attempt_h_all.course_cd%TYPE ) IS
1663: SELECT NVL(SCAH1.hist_start_dt,SCA1.last_update_date) hist_start_dt
1664: FROM IGS_AS_SC_ATTEMPT_H scah1, IGS_EN_STDNT_PS_ATT_ALL SCA1
1665: WHERE SCA1.person_id = SCAH1.person_id(+)
1666: AND SCA1.course_cd = SCAH1.course_cd(+)
1667: AND SCA1.person_id = p_person_id
1668: AND SCA1.course_cd = p_course_cd