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_AD_VAL_AA dependencies on IGS_PE_ALT_PERS_ID

Line 884: -- If the IGS_PE_ALT_PERS_ID record is dated, then it must be effective

880: DECLARE -- Validate the IGS_AD_APPL.tac_appl_ind.
881: -- Validations are -
882: -- If the IGS_AD_APPL.tac_appl_ind = 'Y' then an alternate_person_id
883: -- record must exist for the person with an s_person_id_type of 'TAC'.
884: -- If the IGS_PE_ALT_PERS_ID record is dated, then it must be effective
885: -- as of the IGS_AD_APPL.appl_dt.
886: cst_error CONSTANT VARCHAR2(1) := 'E';
887: cst_warn CONSTANT VARCHAR2(1) := 'W';
888: cst_course CONSTANT IGS_AD_APPL.s_admission_process_type%TYPE := 'COURSE';

Line 889: v_pe_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE;

885: -- as of the IGS_AD_APPL.appl_dt.
886: cst_error CONSTANT VARCHAR2(1) := 'E';
887: cst_warn CONSTANT VARCHAR2(1) := 'W';
888: cst_course CONSTANT IGS_AD_APPL.s_admission_process_type%TYPE := 'COURSE';
889: v_pe_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE;
890: -- gmaheswa: Added START_DT <> END_DT OR END_DT IS NULL condition as part of bug 3882788
891: CURSOR c_api_pit IS
892: SELECT api.pe_person_id
893: FROM IGS_PE_ALT_PERS_ID api,

Line 893: FROM IGS_PE_ALT_PERS_ID api,

889: v_pe_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE;
890: -- gmaheswa: Added START_DT <> END_DT OR END_DT IS NULL condition as part of bug 3882788
891: CURSOR c_api_pit IS
892: SELECT api.pe_person_id
893: FROM IGS_PE_ALT_PERS_ID api,
894: IGS_PE_PERSON_ID_TYP pit
895: WHERE api.pe_person_id = p_person_id AND
896: (api.start_dt IS NULL OR
897: (api.start_dt <= p_appl_dt AND