APPS.IGF_GR_PELL_CALC dependencies on IGS_CA_DA

Line 2061: CURSOR c_get_ofst( cp_ofst_da igs_ca_da.dt_alias%TYPE,

2057: fm.fund_id = l_fund_id ;
2058:
2059: l_fund_rec c_fund%ROWTYPE;
2060:
2061: CURSOR c_get_ofst( cp_ofst_da igs_ca_da.dt_alias%TYPE,
2062: cp_tp_Cal_type igs_ca_inst.cal_type%TYPE,
2063: cp_ci_sequence igs_ca_inst.sequence_number%TYPE,
2064: cp_cur_da igs_ca_da.dt_alias%TYPE) IS
2065: SELECT dai.absolute_val ofst_absolute_val,

Line 2064: cp_cur_da igs_ca_da.dt_alias%TYPE) IS

2060:
2061: CURSOR c_get_ofst( cp_ofst_da igs_ca_da.dt_alias%TYPE,
2062: cp_tp_Cal_type igs_ca_inst.cal_type%TYPE,
2063: cp_ci_sequence igs_ca_inst.sequence_number%TYPE,
2064: cp_cur_da igs_ca_da.dt_alias%TYPE) IS
2065: SELECT dai.absolute_val ofst_absolute_val,
2066: dai.derived_val ofst_derived_val
2067: FROM igs_ca_da_inst_ofst ofst,
2068: igs_ca_da_inst_v dai,

Line 2067: FROM igs_ca_da_inst_ofst ofst,

2063: cp_ci_sequence igs_ca_inst.sequence_number%TYPE,
2064: cp_cur_da igs_ca_da.dt_alias%TYPE) IS
2065: SELECT dai.absolute_val ofst_absolute_val,
2066: dai.derived_val ofst_derived_val
2067: FROM igs_ca_da_inst_ofst ofst,
2068: igs_ca_da_inst_v dai,
2069: igs_ca_da_inst rel
2070: WHERE rel.dt_alias = cp_ofst_da
2071: AND rel.cal_type = cp_tp_cal_type

Line 2068: igs_ca_da_inst_v dai,

2064: cp_cur_da igs_ca_da.dt_alias%TYPE) IS
2065: SELECT dai.absolute_val ofst_absolute_val,
2066: dai.derived_val ofst_derived_val
2067: FROM igs_ca_da_inst_ofst ofst,
2068: igs_ca_da_inst_v dai,
2069: igs_ca_da_inst rel
2070: WHERE rel.dt_alias = cp_ofst_da
2071: AND rel.cal_type = cp_tp_cal_type
2072: AND rel.ci_sequence_number = cp_ci_Sequence

Line 2069: igs_ca_da_inst rel

2065: SELECT dai.absolute_val ofst_absolute_val,
2066: dai.derived_val ofst_derived_val
2067: FROM igs_ca_da_inst_ofst ofst,
2068: igs_ca_da_inst_v dai,
2069: igs_ca_da_inst rel
2070: WHERE rel.dt_alias = cp_ofst_da
2071: AND rel.cal_type = cp_tp_cal_type
2072: AND rel.ci_sequence_number = cp_ci_Sequence
2073: AND ofst.dt_alias = cp_cur_da