APPS.IGS_AU_GEN_001 dependencies on IGS_AD_PS_APPL_HIST

Line 75: p_person_id IN IGS_AD_PS_APPL_HIST_ALL.person_id%TYPE ,

71: END audp_get_aah_col;
72:
73: Function Audp_Get_Acah_Col(
74: p_column_name IN user_tab_columns.column_name%TYPE ,
75: p_person_id IN IGS_AD_PS_APPL_HIST_ALL.person_id%TYPE ,
76: p_admission_appl_number IN NUMBER ,
77: p_nominated_course_cd IN VARCHAR2 ,
78: p_hist_end_dt IN IGS_AD_PS_APPL_HIST_ALL.hist_end_dt%TYPE )
79: RETURN VARCHAR2 AS

Line 78: p_hist_end_dt IN IGS_AD_PS_APPL_HIST_ALL.hist_end_dt%TYPE )

74: p_column_name IN user_tab_columns.column_name%TYPE ,
75: p_person_id IN IGS_AD_PS_APPL_HIST_ALL.person_id%TYPE ,
76: p_admission_appl_number IN NUMBER ,
77: p_nominated_course_cd IN VARCHAR2 ,
78: p_hist_end_dt IN IGS_AD_PS_APPL_HIST_ALL.hist_end_dt%TYPE )
79: RETURN VARCHAR2 AS
80:
81: BEGIN -- audp_get_acah_col
82: -- get the oldest column value (after a given date) for a

Line 84: -- IGS_AD_PS_APPL_HIST table

80:
81: BEGIN -- audp_get_acah_col
82: -- get the oldest column value (after a given date) for a
83: -- specified column and admission_cd, nominated_course_cd for
84: -- IGS_AD_PS_APPL_HIST table
85: DECLARE
86: cst_transfer_course_cd CONSTANT VARCHAR2(18) := 'TRANSFER_COURSE_CD';
87: cst_basis_for_admission_type CONSTANT
88: VARCHAR2(24) := 'BASIS_FOR_ADMISSION_TYPE';

Line 107: FROM IGS_AD_PS_APPL_HIST acah

103: cst_course_rank_set, acah.course_rank_set,
104: cst_course_rank_schedule, acah.course_rank_schedule,
105: cst_req_for_reconsideratn_ind, acah.req_for_reconsideration_ind,
106: cst_req_for_adv_standing_ind, acah.req_for_adv_standing_ind)
107: FROM IGS_AD_PS_APPL_HIST acah
108: WHERE acah.person_id = p_person_id AND
109: acah.admission_appl_number = p_admission_appl_number AND
110: acah.nominated_course_cd = p_nominated_course_cd AND
111: acah.hist_start_dt >= p_hist_end_dt AND