APPS.IGS_AD_SS_APPL_UPD_PAGE dependencies on IGS_AD_CAL_CONF

Line 331: FROM igs_ad_cal_conf

327: l_return_status OUT NOCOPY VARCHAR2) AS
328:
329: CURSOR adm_cal_conf_cur IS
330: SELECT adm_appl_due_dt_alias
331: FROM igs_ad_cal_conf
332: WHERE s_control_num = 1;
333:
334: l_adm_appl_due_dt_alias igs_ca_da_inst.dt_alias%TYPE;
335:

Line 444: v_adm_appl_due_dt_alias IGS_AD_CAL_CONF.adm_appl_due_dt_alias%TYPE;

440: l_msg_count OUT NOCOPY NUMBER,
441: l_msg_data OUT NOCOPY VARCHAR2,
442: l_return_status OUT NOCOPY VARCHAR2) AS
443:
444: v_adm_appl_due_dt_alias IGS_AD_CAL_CONF.adm_appl_due_dt_alias%TYPE;
445: v_adm_appl_final_dt_alias IGS_AD_CAL_CONF.adm_appl_final_dt_alias%TYPE;
446: v_due_dt DATE;
447: v_final_dt DATE;
448: l_max_duedt DATE;

Line 445: v_adm_appl_final_dt_alias IGS_AD_CAL_CONF.adm_appl_final_dt_alias%TYPE;

441: l_msg_data OUT NOCOPY VARCHAR2,
442: l_return_status OUT NOCOPY VARCHAR2) AS
443:
444: v_adm_appl_due_dt_alias IGS_AD_CAL_CONF.adm_appl_due_dt_alias%TYPE;
445: v_adm_appl_final_dt_alias IGS_AD_CAL_CONF.adm_appl_final_dt_alias%TYPE;
446: v_due_dt DATE;
447: v_final_dt DATE;
448: l_max_duedt DATE;
449:

Line 453: FROM IGS_AD_CAL_CONF

449:
450: CURSOR c_sacc IS
451: SELECT adm_appl_due_dt_alias,
452: adm_appl_final_dt_alias
453: FROM IGS_AD_CAL_CONF
454: WHERE s_control_num = 1;
455:
456: l_adm_cal_type igs_ca_inst.cal_type%TYPE ;
457: l_adm_sequence_number igs_ca_inst.sequence_number%TYPE;