APPS.IGS_AD_GEN_007 dependencies on IGS_AD_APPL

Line 90: FROM IGS_AD_APPL aa,

86: SELECT ci1.cal_type ||
87: TO_CHAR(ci1.start_dt, 'DDMMYYYY') ||
88: ci2.cal_type ||
89: TO_CHAR(ci2.start_dt, 'DDMMYYYY')
90: FROM IGS_AD_APPL aa,
91: IGS_AD_PS_APPL_INST acai,
92: IGS_CA_INST ci1,
93: IGS_CA_INST ci2
94: WHERE aa.person_id = p_person_id AND

Line 618: v_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE;

614: RETURN VARCHAR2 IS
615: BEGIN --admp_get_saas
616: --Get the s_adm_appl_status for a specified adm_appl_status
617: DECLARE
618: v_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE;
619: CURSOR c_aas IS
620: SELECT s_adm_appl_status
621: FROM IGS_AD_APPL_STAT
622: WHERE adm_appl_status = p_adm_appl_status;

Line 621: FROM IGS_AD_APPL_STAT

617: DECLARE
618: v_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE;
619: CURSOR c_aas IS
620: SELECT s_adm_appl_status
621: FROM IGS_AD_APPL_STAT
622: WHERE adm_appl_status = p_adm_appl_status;
623: BEGIN
624: --initialise v_adm_appl_status
625: v_adm_appl_status := NULL;