APPS.IGS_AU_GEN_002 dependencies on IGS_FI_FD_SRC_RSTN_H_ALL

Line 432: p_course_cd igs_fi_fd_src_rstn_h_all.course_cd%TYPE ,

428: END;
429: END audp_get_fsh_col;
430:
431: FUNCTION audp_get_fsrh_col(
432: p_course_cd igs_fi_fd_src_rstn_h_all.course_cd%TYPE ,
433: p_version_number igs_fi_fd_src_rstn_h_all.version_number%TYPE ,
434: p_funding_source igs_fi_fd_src_rstn_h_all.funding_source%TYPE ,
435: p_column_name user_tab_columns.column_name%TYPE ,
436: p_hist_date igs_fi_fd_src_rstn_h_all.hist_start_dt%TYPE )

Line 433: p_version_number igs_fi_fd_src_rstn_h_all.version_number%TYPE ,

429: END audp_get_fsh_col;
430:
431: FUNCTION audp_get_fsrh_col(
432: p_course_cd igs_fi_fd_src_rstn_h_all.course_cd%TYPE ,
433: p_version_number igs_fi_fd_src_rstn_h_all.version_number%TYPE ,
434: p_funding_source igs_fi_fd_src_rstn_h_all.funding_source%TYPE ,
435: p_column_name user_tab_columns.column_name%TYPE ,
436: p_hist_date igs_fi_fd_src_rstn_h_all.hist_start_dt%TYPE )
437: RETURN VARCHAR2 AS

Line 434: p_funding_source igs_fi_fd_src_rstn_h_all.funding_source%TYPE ,

430:
431: FUNCTION audp_get_fsrh_col(
432: p_course_cd igs_fi_fd_src_rstn_h_all.course_cd%TYPE ,
433: p_version_number igs_fi_fd_src_rstn_h_all.version_number%TYPE ,
434: p_funding_source igs_fi_fd_src_rstn_h_all.funding_source%TYPE ,
435: p_column_name user_tab_columns.column_name%TYPE ,
436: p_hist_date igs_fi_fd_src_rstn_h_all.hist_start_dt%TYPE )
437: RETURN VARCHAR2 AS
438:

Line 436: p_hist_date igs_fi_fd_src_rstn_h_all.hist_start_dt%TYPE )

432: p_course_cd igs_fi_fd_src_rstn_h_all.course_cd%TYPE ,
433: p_version_number igs_fi_fd_src_rstn_h_all.version_number%TYPE ,
434: p_funding_source igs_fi_fd_src_rstn_h_all.funding_source%TYPE ,
435: p_column_name user_tab_columns.column_name%TYPE ,
436: p_hist_date igs_fi_fd_src_rstn_h_all.hist_start_dt%TYPE )
437: RETURN VARCHAR2 AS
438:
439: BEGIN -- audp_get_fsrh_col
440: -- get the oldest column value (after a given date) for the dflt_ind column