APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_GE_S_GEN_CAL_CON

Line 273: CURSOR c_census_dt_alias (cp_n_s_control_num igs_ge_s_gen_cal_con.s_control_num%TYPE) IS

269: || bannamal 27-May-2005 Bug#4077763 Fee Calculation Performance Enhancement.
270: || Replaced the literal used in the cursor c_census_dt_alias by cursor parameter.
271: || (reverse chronological order - newest change first)
272: ----------------------------------------------------------------------------*/
273: CURSOR c_census_dt_alias (cp_n_s_control_num igs_ge_s_gen_cal_con.s_control_num%TYPE) IS
274: SELECT census_dt_alias
275: FROM igs_ge_s_gen_cal_con
276: WHERE s_control_num = cp_n_s_control_num;
277:

Line 275: FROM igs_ge_s_gen_cal_con

271: || (reverse chronological order - newest change first)
272: ----------------------------------------------------------------------------*/
273: CURSOR c_census_dt_alias (cp_n_s_control_num igs_ge_s_gen_cal_con.s_control_num%TYPE) IS
274: SELECT census_dt_alias
275: FROM igs_ge_s_gen_cal_con
276: WHERE s_control_num = cp_n_s_control_num;
277:
278: CURSOR c_check_dt_alias (cp_dt_alias igs_ca_da_inst.dt_alias%TYPE,
279: cp_cal_type igs_ca_da_inst.cal_type%TYPE,

Line 287: l_v_census_dt_alias igs_ge_s_gen_cal_con.census_dt_alias%TYPE;

283: WHERE dt_alias = cp_dt_alias
284: AND cal_type = cp_cal_type
285: AND ci_sequence_number = cp_ci_sequence_number;
286:
287: l_v_census_dt_alias igs_ge_s_gen_cal_con.census_dt_alias%TYPE;
288: l_d_check_dt_alias igs_ca_da_inst_v.alias_val%TYPE;
289: BEGIN
290:
291: p_d_cns_dt_als_val := NULL;