DBA Data[Home] [Help]

APPS.IGS_AU_GEN_001 dependencies on IGS_PS_REF_CD_HIST_ALL

Line 61: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,

57: RETURN NUMBER;
58: PRAGMA RESTRICT_REFERENCES(Audp_Get_Coh_Col, WNDS);
59:
60: Function Audp_Get_Crch_Col(
61: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
62: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
63: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
64: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
65: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )

Line 62: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,

58: PRAGMA RESTRICT_REFERENCES(Audp_Get_Coh_Col, WNDS);
59:
60: Function Audp_Get_Crch_Col(
61: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
62: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
63: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
64: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
65: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )
66: RETURN VARCHAR2;

Line 63: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,

59:
60: Function Audp_Get_Crch_Col(
61: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
62: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
63: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
64: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
65: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )
66: RETURN VARCHAR2;
67: PRAGMA RESTRICT_REFERENCES(Audp_Get_Crch_Col, WNDS);

Line 64: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,

60: Function Audp_Get_Crch_Col(
61: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
62: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
63: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
64: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
65: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )
66: RETURN VARCHAR2;
67: PRAGMA RESTRICT_REFERENCES(Audp_Get_Crch_Col, WNDS);
68:

Line 65: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )

61: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
62: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
63: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
64: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
65: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )
66: RETURN VARCHAR2;
67: PRAGMA RESTRICT_REFERENCES(Audp_Get_Crch_Col, WNDS);
68:
69: Function Audp_Get_Cth_Col(