APPS.IGS_AU_GEN_001 dependencies on IGS_PS_REF_CD_HIST

Line 503: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,

499: END;
500: END audp_get_coh_col;
501:
502: Function Audp_Get_Crch_Col(
503: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
504: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
505: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
506: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
507: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )

Line 504: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,

500: END audp_get_coh_col;
501:
502: Function Audp_Get_Crch_Col(
503: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
504: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
505: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
506: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
507: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )
508: RETURN VARCHAR2 AS

Line 505: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,

501:
502: Function Audp_Get_Crch_Col(
503: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
504: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
505: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
506: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
507: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )
508: RETURN VARCHAR2 AS
509:

Line 506: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,

502: Function Audp_Get_Crch_Col(
503: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
504: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
505: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
506: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
507: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )
508: RETURN VARCHAR2 AS
509:
510: BEGIN -- audp_get_crch_col

Line 507: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )

503: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
504: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
505: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
506: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
507: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )
508: RETURN VARCHAR2 AS
509:
510: BEGIN -- audp_get_crch_col
511: -- get the oldest column value (after a given date) for the descritpion

Line 518: FROM IGS_PS_REF_CD_HIST crch

514: DECLARE
515: v_column_value VARCHAR2(2000) := NULL;
516: CURSOR c_crch IS
517: SELECT crch.description
518: FROM IGS_PS_REF_CD_HIST crch
519: WHERE crch.course_cd = p_course_cd AND
520: crch.version_number = p_version_number AND
521: crch.reference_cd_type = p_reference_cd_type AND
522: crch.reference_cd = p_reference_cd AND