APPS.IGS_AU_GEN_003 dependencies on IGS_AS_SC_ATTEMPT_H

Line 434: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,

430:
431:
432: FUNCTION Audp_Get_Scah_Col(
433: p_column_name IN user_tab_columns.column_name%TYPE ,
434: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
436: p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )
437: RETURN VARCHAR2 AS
438: BEGIN -- audp_get_scah_col

Line 435: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,

431:
432: FUNCTION Audp_Get_Scah_Col(
433: p_column_name IN user_tab_columns.column_name%TYPE ,
434: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
436: p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )
437: RETURN VARCHAR2 AS
438: BEGIN -- audp_get_scah_col
439: -- get the oldest column value (after a given date) for the

Line 436: p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )

432: FUNCTION Audp_Get_Scah_Col(
433: p_column_name IN user_tab_columns.column_name%TYPE ,
434: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
436: p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )
437: RETURN VARCHAR2 AS
438: BEGIN -- audp_get_scah_col
439: -- get the oldest column value (after a given date) for the
440: -- student course attempt history table

Line 548: FROM IGS_AS_SC_ATTEMPT_H scah

544: cst_override_cmpl_dt, IGS_GE_DATE.igscharDT(scah.override_cmpl_dt),
545: cst_coo_id, TO_CHAR(scah.coo_id),
546: cst_IGS_PR_CLASS_STD_ID, TO_CHAR(scah.IGS_PR_CLASS_STD_ID)
547: )
548: FROM IGS_AS_SC_ATTEMPT_H scah
549: WHERE scah.person_id = p_person_id AND
550: scah.course_cd = p_course_cd AND
551: scah.hist_start_dt >= p_hist_end_dt AND
552: DECODE (p_column_name,