APPS.IGS_AU_GEN_002 dependencies on IGS_FI_FUND_SRC_HIST

Line 393: p_funding_source igs_fi_fund_src_hist_all.funding_source%TYPE ,

389: END;
390: END audp_get_fosh_col;
391:
392: FUNCTION audp_get_fsh_col(
393: p_funding_source igs_fi_fund_src_hist_all.funding_source%TYPE ,
394: p_column_name user_tab_columns.column_name%TYPE ,
395: p_hist_end_dt igs_fi_fund_src_hist_all.hist_end_dt%TYPE )
396: RETURN VARCHAR2 AS
397:

Line 395: p_hist_end_dt igs_fi_fund_src_hist_all.hist_end_dt%TYPE )

391:
392: FUNCTION audp_get_fsh_col(
393: p_funding_source igs_fi_fund_src_hist_all.funding_source%TYPE ,
394: p_column_name user_tab_columns.column_name%TYPE ,
395: p_hist_end_dt igs_fi_fund_src_hist_all.hist_end_dt%TYPE )
396: RETURN VARCHAR2 AS
397:
398: BEGIN -- audp_get_fsh_col
399: -- get the oldest column value (after a given date) for a given

Line 409: FROM igs_fi_fund_src_hist fsh

405: decode (p_column_name,
406: 'DESCRIPTION', fsh.description,
407: 'GOVT_FUNDING_SOURCE', TO_CHAR(fsh.govt_funding_source),
408: 'CLOSED_IND', fsh.closed_ind)
409: FROM igs_fi_fund_src_hist fsh
410: WHERE fsh.funding_source = p_funding_source AND
411: fsh.hist_start_dt >= p_hist_end_dt AND
412: decode (p_column_name,
413: 'DESCRIPTION', fsh.description,