APPS.IGS_AU_GEN_003 dependencies on IGS_AS_SU_SETATMPT_H

Line 894: -- for IGS_AS_SU_SETATMPT_H table

890: RETURN VARCHAR2 AS
891: BEGIN -- audp_get_susah_col
892: -- get the oldest column value (after a given date) for a
893: -- specified column, person_id, course_cd, unit_set_cd, sequence_number
894: -- for IGS_AS_SU_SETATMPT_H table
895: DECLARE
896: cst_us_version_number VARCHAR2(17) := 'US_VERSION_NUMBER';
897: cst_selection_dt VARCHAR2(12) := 'SELECTION_DT';
898: cst_student_confirmed_ind VARCHAR2(21) := 'STUDENT_CONFIRMED_IND';

Line 932: FROM IGS_AS_SU_SETATMPT_H susah

928: cst_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(susah.rqrmnts_complete_dt),
929: cst_s_completed_source_type, susah.s_completed_source_type,
930: cst_catalog_cal_type, susah.catalog_cal_type ,
931: cst_catalog_seq_num, TO_CHAR(susah.catalog_seq_num) )
932: FROM IGS_AS_SU_SETATMPT_H susah
933: WHERE susah.person_id = p_person_id AND
934: susah.course_cd = p_course_cd AND
935: susah.unit_set_cd = p_unit_set_cd AND
936: susah.sequence_number = p_sequence_number AND