APPS.IGF_AW_RULE dependencies on IGS_CA_INST

Line 67: CURSOR c_alternate_code(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

63: */
64:
65:
66: --Cursor to find the User Parameter Award Year (which is same as Alternate Code) to display in the Log
67: CURSOR c_alternate_code(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
68: cp_ci_sequence_NUMBER igs_ca_inst.sequence_NUMBER%TYPE) IS
69: SELECT alternate_code
70: FROM igs_ca_inst
71: WHERE cal_type = cp_ci_cal_type AND

Line 68: cp_ci_sequence_NUMBER igs_ca_inst.sequence_NUMBER%TYPE) IS

64:
65:
66: --Cursor to find the User Parameter Award Year (which is same as Alternate Code) to display in the Log
67: CURSOR c_alternate_code(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
68: cp_ci_sequence_NUMBER igs_ca_inst.sequence_NUMBER%TYPE) IS
69: SELECT alternate_code
70: FROM igs_ca_inst
71: WHERE cal_type = cp_ci_cal_type AND
72: sequence_NUMBER = cp_ci_sequence_NUMBER;

Line 70: FROM igs_ca_inst

66: --Cursor to find the User Parameter Award Year (which is same as Alternate Code) to display in the Log
67: CURSOR c_alternate_code(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
68: cp_ci_sequence_NUMBER igs_ca_inst.sequence_NUMBER%TYPE) IS
69: SELECT alternate_code
70: FROM igs_ca_inst
71: WHERE cal_type = cp_ci_cal_type AND
72: sequence_NUMBER = cp_ci_sequence_NUMBER;
73:
74: CURSOR c_get_parameters IS

Line 93: l_alternate_code igs_ca_inst.alternate_code%TYPE;

89: l_award_years igf_lookups_view.meaning%TYPE;
90: l1_person_number igf_lookups_view.meaning%TYPE;
91: l_run_types igf_lookups_view.meaning%TYPE;
92: l_para_pass igf_lookups_view.meaning%TYPE;
93: l_alternate_code igs_ca_inst.alternate_code%TYPE;
94:
95: BEGIN
96:
97: igf_aw_gen.set_org_id(p_org_id);

Line 182: CURSOR c_alternate_code(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

178: || masehgal 11-Nov-2002 FA 101 - SAP Obsoletion
179: || removed packaging hold
180: */
181: --Cursor to find the User Parameter Award Year (which is same as Alternate Code) to display in the Log
182: CURSOR c_alternate_code(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
183: cp_ci_sequence_NUMBER igs_ca_inst.sequence_NUMBER%TYPE) IS
184: SELECT alternate_code
185: FROM igs_ca_inst
186: WHERE cal_type = cp_ci_cal_type AND

Line 183: cp_ci_sequence_NUMBER igs_ca_inst.sequence_NUMBER%TYPE) IS

179: || removed packaging hold
180: */
181: --Cursor to find the User Parameter Award Year (which is same as Alternate Code) to display in the Log
182: CURSOR c_alternate_code(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
183: cp_ci_sequence_NUMBER igs_ca_inst.sequence_NUMBER%TYPE) IS
184: SELECT alternate_code
185: FROM igs_ca_inst
186: WHERE cal_type = cp_ci_cal_type AND
187: sequence_NUMBER = cp_ci_sequence_NUMBER;

Line 185: FROM igs_ca_inst

181: --Cursor to find the User Parameter Award Year (which is same as Alternate Code) to display in the Log
182: CURSOR c_alternate_code(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
183: cp_ci_sequence_NUMBER igs_ca_inst.sequence_NUMBER%TYPE) IS
184: SELECT alternate_code
185: FROM igs_ca_inst
186: WHERE cal_type = cp_ci_cal_type AND
187: sequence_NUMBER = cp_ci_sequence_NUMBER;
188: l_alternate_code igs_ca_inst.alternate_code%TYPE;
189:

Line 188: l_alternate_code igs_ca_inst.alternate_code%TYPE;

184: SELECT alternate_code
185: FROM igs_ca_inst
186: WHERE cal_type = cp_ci_cal_type AND
187: sequence_NUMBER = cp_ci_sequence_NUMBER;
188: l_alternate_code igs_ca_inst.alternate_code%TYPE;
189:
190: CURSOR c_year ( x_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%type ,
191: x_ci_sequence_NUMBER igf_ap_fa_base_rec.ci_sequence_NUMBER%type )
192: IS