APPS.IGS_GR_GEN_002 dependencies on IGS_CA_DA_INST_V

Line 33: -- Nalin Kumar 10-Mar-2003 Modified c_crd_sca cursor to considered IGS_CA_DA_INST_V.ALIAS_VAL instead of IGS_CA_DA_INST_V.ABSOLUTE_VAL

29: -- Nalin Kumar 05-Dec-2002 Modified the grdpl_ins_new_graduand procedure to fix Bug# 2683072.
30: -- Nalin Kumar 10-Dec-2002 Modified the grdp_upd_gac_order procedure to fix Bug# 2691809.
31: -- Nalin Kumar 18-DEC-2002 Modified this procedure to fix Bug# 2690151.
32: -- Added the code to log the parameters value in the log file.
33: -- Nalin Kumar 10-Mar-2003 Modified c_crd_sca cursor to considered IGS_CA_DA_INST_V.ALIAS_VAL instead of IGS_CA_DA_INST_V.ABSOLUTE_VAL
34: -- This is to fix Bug# 2760539.
35: -- Nalin Kumar 12-Dec-2003 Modified grdp_upd_gac_order procedure to fix Bug# 3294453.
36: -- iJeddy The Fourth of July, 2005 Bug 4473024, added a join on award_cd to the Cursor c_crd_sca
37: -- sepalani 19-Apr-2006 Modified Cursor c_gr_upd on procedure GRDP_PRC_GAC for Bug# 5074150

Line 129: igs_ca_da_inst_v dai1,

125: igs_en_spa_awd_aim spaa,
126: igs_ps_ver crv ,
127: igs_gr_crmn_round crd ,
128: igs_gr_crm_round_prd crdp,
129: igs_ca_da_inst_v dai1,
130: igs_ca_da_inst_v dai2
131: WHERE (p_grd_cal_type IS NULL OR
132: (crd.grd_cal_type = p_grd_cal_type AND
133: crd.grd_ci_sequence_number = p_grd_ci_sequence_number)) AND

Line 130: igs_ca_da_inst_v dai2

126: igs_ps_ver crv ,
127: igs_gr_crmn_round crd ,
128: igs_gr_crm_round_prd crdp,
129: igs_ca_da_inst_v dai1,
130: igs_ca_da_inst_v dai2
131: WHERE (p_grd_cal_type IS NULL OR
132: (crd.grd_cal_type = p_grd_cal_type AND
133: crd.grd_ci_sequence_number = p_grd_ci_sequence_number)) AND
134: dai1.cal_type = crd.grd_cal_type AND