DBA Data[Home] [Help]

APPS.IGS_AD_GEN_004 dependencies on IGS_AD_PS_APPL_INST_APLSUMR_V

Line 279: v_commencement_period IGS_AD_PS_APPL_INST_APLSUMR_V.commencement_period%TYPE;

275: RETURN VARCHAR2 IS
276: BEGIN -- admp_get_comm_perd
277: -- This module retrieves the commencement period
278: DECLARE
279: v_commencement_period IGS_AD_PS_APPL_INST_APLSUMR_V.commencement_period%TYPE;
280: CURSOR c_aasv IS --modified the cursor to use base tables instead of IGS_AD_PS_APPL_INST_APLSUMR_V. Bug: 3150054
281: SELECT SUBSTR(IGS_AD_GEN_002.admp_get_acai_acadcd(
282: aav.person_id,
283: aav.admission_appl_number,

Line 280: CURSOR c_aasv IS --modified the cursor to use base tables instead of IGS_AD_PS_APPL_INST_APLSUMR_V. Bug: 3150054

276: BEGIN -- admp_get_comm_perd
277: -- This module retrieves the commencement period
278: DECLARE
279: v_commencement_period IGS_AD_PS_APPL_INST_APLSUMR_V.commencement_period%TYPE;
280: CURSOR c_aasv IS --modified the cursor to use base tables instead of IGS_AD_PS_APPL_INST_APLSUMR_V. Bug: 3150054
281: SELECT SUBSTR(IGS_AD_GEN_002.admp_get_acai_acadcd(
282: aav.person_id,
283: aav.admission_appl_number,
284: aav.acad_cal_type,