APPS.IGS_AD_VAL_ACAI dependencies on IGS_AD_CAL_CONF

Line 545: IGS_AD_CAL_CONF.adm_appl_chng_of_pref_dt_alias%TYPE;

541: BEGIN -- admp_val_chg_of_pref
542: -- Description: Validate change of preferences
543: DECLARE
544: v_chng_of_pref_dt_alias
545: IGS_AD_CAL_CONF.adm_appl_chng_of_pref_dt_alias%TYPE;
546: v_chng_of_pref_dt DATE;
547: CURSOR c_sacco IS
548: SELECT sacco.adm_appl_chng_of_pref_dt_alias
549: FROM IGS_AD_CAL_CONF sacco

Line 549: FROM IGS_AD_CAL_CONF sacco

545: IGS_AD_CAL_CONF.adm_appl_chng_of_pref_dt_alias%TYPE;
546: v_chng_of_pref_dt DATE;
547: CURSOR c_sacco IS
548: SELECT sacco.adm_appl_chng_of_pref_dt_alias
549: FROM IGS_AD_CAL_CONF sacco
550: WHERE sacco.s_control_num = 1;
551: BEGIN
552: p_message_name := NULL;
553: OPEN c_sacco;

Line 1404: FROM IGS_AD_CAL_CONF

1400: DECLARE
1401: CURSOR c_sacc IS
1402: SELECT adm_appl_due_dt_alias,
1403: adm_appl_final_dt_alias
1404: FROM IGS_AD_CAL_CONF
1405: WHERE s_control_num = 1 AND
1406: adm_appl_due_dt_alias IS NOT NULL AND
1407: adm_appl_final_dt_alias IS NOT NULL;
1408: v_sacc_rec c_sacc%ROWTYPE;