DBA Data[Home] [Help]

APPS.IGS_AU_GEN_001 dependencies on IGS_PS_TYPE_HIST

Line 543: p_hist_end_dt IGS_PS_TYPE_HIST_ALL.hist_end_dt%TYPE )

539:
540: Function Audp_Get_Cth_Col(
541: p_column_name user_tab_columns.column_name%TYPE ,
542: p_course_type IGS_PS_TYPE_ALL.course_type%TYPE ,
543: p_hist_end_dt IGS_PS_TYPE_HIST_ALL.hist_end_dt%TYPE )
544: RETURN VARCHAR2 AS
545: -- HISTORY
546: -- WHO WHEN WHAT
547: -- sarakshi 3-Oct-2002 Enh#2603626,the cursor c_cth added column fin_aid_program_type in the decode

Line 567: FROM IGS_PS_TYPE_HIST cth

563: 'AWARD_COURSE_IND', cth.award_course_ind,
564: 'RESEARCH_TYPE_IND', cth.research_type_ind,
565: 'PRIMARY_AUTO_SELECT', cth.primary_auto_select,
566: 'FIN_AID_PROGRAM_TYPE', cth.fin_aid_program_type)
567: FROM IGS_PS_TYPE_HIST cth
568: WHERE cth.course_type = p_course_type AND
569: cth.hist_start_dt >= p_hist_end_dt AND
570: DECODE (p_column_name,
571: 'DESCRIPTION', cth.description,