APPS.IGS_AU_GEN_004 dependencies on IGS_PS_UNT_DSCP_HIST_ALL

Line 98: p_unit_cd IGS_PS_UNT_DSCP_HIST_ALL.unit_cd%TYPE ,

94: END;
95: END audp_get_troh_col;
96:
97: Function Audp_Get_Udh_Col(
98: p_unit_cd IGS_PS_UNT_DSCP_HIST_ALL.unit_cd%TYPE ,
99: p_version_number IGS_PS_UNT_DSCP_HIST_ALL.version_number%TYPE ,
100: p_discipline_group_cd IGS_PS_UNT_DSCP_HIST_ALL.discipline_group_cd%TYPE ,
101: p_hist_date IGS_PS_UNT_DSCP_HIST_ALL.hist_start_dt%TYPE )
102: RETURN NUMBER AS

Line 99: p_version_number IGS_PS_UNT_DSCP_HIST_ALL.version_number%TYPE ,

95: END audp_get_troh_col;
96:
97: Function Audp_Get_Udh_Col(
98: p_unit_cd IGS_PS_UNT_DSCP_HIST_ALL.unit_cd%TYPE ,
99: p_version_number IGS_PS_UNT_DSCP_HIST_ALL.version_number%TYPE ,
100: p_discipline_group_cd IGS_PS_UNT_DSCP_HIST_ALL.discipline_group_cd%TYPE ,
101: p_hist_date IGS_PS_UNT_DSCP_HIST_ALL.hist_start_dt%TYPE )
102: RETURN NUMBER AS
103:

Line 100: p_discipline_group_cd IGS_PS_UNT_DSCP_HIST_ALL.discipline_group_cd%TYPE ,

96:
97: Function Audp_Get_Udh_Col(
98: p_unit_cd IGS_PS_UNT_DSCP_HIST_ALL.unit_cd%TYPE ,
99: p_version_number IGS_PS_UNT_DSCP_HIST_ALL.version_number%TYPE ,
100: p_discipline_group_cd IGS_PS_UNT_DSCP_HIST_ALL.discipline_group_cd%TYPE ,
101: p_hist_date IGS_PS_UNT_DSCP_HIST_ALL.hist_start_dt%TYPE )
102: RETURN NUMBER AS
103:
104: BEGIN -- audp_get_udh_col

Line 101: p_hist_date IGS_PS_UNT_DSCP_HIST_ALL.hist_start_dt%TYPE )

97: Function Audp_Get_Udh_Col(
98: p_unit_cd IGS_PS_UNT_DSCP_HIST_ALL.unit_cd%TYPE ,
99: p_version_number IGS_PS_UNT_DSCP_HIST_ALL.version_number%TYPE ,
100: p_discipline_group_cd IGS_PS_UNT_DSCP_HIST_ALL.discipline_group_cd%TYPE ,
101: p_hist_date IGS_PS_UNT_DSCP_HIST_ALL.hist_start_dt%TYPE )
102: RETURN NUMBER AS
103:
104: BEGIN -- audp_get_udh_col
105: -- Get the oldest column value (after a given date) for the percentage