APPS.IGS_AU_GEN_001 dependencies on IGS_AD_APPL_HIST

Line 5: p_person_id IN IGS_AD_APPL_HIST_ALL.person_id%TYPE ,

1: PACKAGE BODY IGS_AU_GEN_001 AS
2: /* $Header: IGSAU01B.pls 115.7 2003/12/03 20:48:58 knag ship $ */
3: Function Audp_Get_Aah_Col(
4: p_column_name IN user_tab_columns.column_name%TYPE ,
5: p_person_id IN IGS_AD_APPL_HIST_ALL.person_id%TYPE ,
6: p_admission_appl_number IN NUMBER ,
7: p_hist_end_dt IN IGS_AD_APPL_HIST_ALL.hist_end_dt%TYPE )
8: RETURN VARCHAR2 AS
9:

Line 7: p_hist_end_dt IN IGS_AD_APPL_HIST_ALL.hist_end_dt%TYPE )

3: Function Audp_Get_Aah_Col(
4: p_column_name IN user_tab_columns.column_name%TYPE ,
5: p_person_id IN IGS_AD_APPL_HIST_ALL.person_id%TYPE ,
6: p_admission_appl_number IN NUMBER ,
7: p_hist_end_dt IN IGS_AD_APPL_HIST_ALL.hist_end_dt%TYPE )
8: RETURN VARCHAR2 AS
9:
10: BEGIN -- audp_get_aah_col
11: -- get the oldest column value (after a given date) for a

Line 13: -- for IGS_AD_APPL_HIST table

9:
10: BEGIN -- audp_get_aah_col
11: -- get the oldest column value (after a given date) for a
12: -- specified column and person_id, admission_appl_number
13: -- for IGS_AD_APPL_HIST table
14: DECLARE
15: cst_appl_dt CONSTANT VARCHAR2(7) := 'APPL_DT';
16: cst_acad_cal_type CONSTANT VARCHAR2(13) := 'ACAD_CAL_TYPE';
17: cst_acad_ci_sequence_number CONSTANT VARCHAR2(23) := 'ACAD_CI_SEQUENCE_NUMBER';

Line 40: FROM IGS_AD_APPL_HIST aah

36: cst_s_admission_process_type, aah.s_admission_process_type,
37: cst_adm_appl_status, aah.ADM_APPL_STATUS,
38: cst_adm_fee_status, aah.ADM_FEE_STATUS,
39: cst_tac_appl_ind, aah.tac_appl_ind)
40: FROM IGS_AD_APPL_HIST aah
41: WHERE aah.person_id = p_person_id AND
42: aah.admission_appl_number = p_admission_appl_number AND
43: aah.hist_start_dt >= p_hist_end_dt AND
44: DECODE (