DBA Data[Home] [Help]

APPS.IGS_AU_GEN_003 dependencies on IGS_AS_SU_ATMPTOUT_H

Line 819: -- ci_sequence_number and for table IGS_AS_SU_ATMPTOUT_H

815: RETURN VARCHAR2 AS
816: BEGIN -- audp_get_suaoh_col
817: -- get the oldest column value (after a given date) for a
818: -- specified column, person_id, course_cd, unit_cd, CAL_TYPE
819: -- ci_sequence_number and for table IGS_AS_SU_ATMPTOUT_H
820: DECLARE
821: cst_grading_schema_cd VARCHAR2(17) := 'GRADING_SCHEMA_CD';
822: cst_version_number VARCHAR2(14) := 'VERSION_NUMBER';
823: cst_grade VARCHAR2(5) := 'GRADE';

Line 847: FROM IGS_AS_SU_ATMPTOUT_H suaoh

843: cst_trnslted_grading_schema_cd, suaoh.translated_grading_schema_cd,
844: cst_translated_version_no, TO_CHAR(suaoh.translated_version_number),
845: cst_translated_grade, suaoh.translated_grade,
846: cst_translated_dt, TO_CHAR(suaoh.translated_dt))
847: FROM IGS_AS_SU_ATMPTOUT_H suaoh
848: WHERE suaoh.person_id = p_person_id AND
849: suaoh.course_cd = p_course_cd AND
850: suaoh.uoo_id = p_uoo_id AND
851: suaoh.outcome_dt = p_outcome_dt AND