eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AU_GEN_002 dependencies on IGS_FI_FD_SRC_RSTN_H

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

Line 446: FROM igs_fi_fd_src_rstn_h fsrh

442: DECLARE
443: v_column_value VARCHAR2(1) := NULL;
444: CURSOR c_fsrh IS
445: SELECT fsrh.dflt_ind
446: FROM igs_fi_fd_src_rstn_h fsrh
447: WHERE fsrh.course_cd = p_course_cd AND
448: fsrh.version_number = p_version_number AND
449: fsrh.funding_source = p_funding_source AND
450: fsrh.hist_start_dt >= p_hist_date AND