APPS.IGF_AW_FISAP dependencies on IGS_CA_INST

Line 43: l_ci_cal_type igs_ca_inst.cal_type%TYPE;

39: || Change History :
40: || Who When What
41: || (reverse chronological order - newest change first)
42: */
43: l_ci_cal_type igs_ca_inst.cal_type%TYPE;
44: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
45: l_tot_fseog NUMBER := 0;
46: l_tot_match NUMBER := 0;
47: l_total NUMBER := 0;

Line 44: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

40: || Who When What
41: || (reverse chronological order - newest change first)
42: */
43: l_ci_cal_type igs_ca_inst.cal_type%TYPE;
44: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
45: l_tot_fseog NUMBER := 0;
46: l_tot_match NUMBER := 0;
47: l_total NUMBER := 0;
48: l_fseog_pcntg NUMBER(5,2) := 0;

Line 50: l_alternate_code igs_ca_inst.alternate_code%TYPE;

46: l_tot_match NUMBER := 0;
47: l_total NUMBER := 0;
48: l_fseog_pcntg NUMBER(5,2) := 0;
49: l_match_pcntg NUMBER(5,2) := 0;
50: l_alternate_code igs_ca_inst.alternate_code%TYPE;
51:
52: --Cursor to find the SUM of Amounts for FSEOG funds
53: CURSOR c_fseog_sum(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
54: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)

Line 53: CURSOR c_fseog_sum(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

49: l_match_pcntg NUMBER(5,2) := 0;
50: l_alternate_code igs_ca_inst.alternate_code%TYPE;
51:
52: --Cursor to find the SUM of Amounts for FSEOG funds
53: CURSOR c_fseog_sum(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
54: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)
55: IS
56: SELECT SUM (NVL (DECODE (
57: p_sum_type,

Line 54: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)

50: l_alternate_code igs_ca_inst.alternate_code%TYPE;
51:
52: --Cursor to find the SUM of Amounts for FSEOG funds
53: CURSOR c_fseog_sum(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
54: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)
55: IS
56: SELECT SUM (NVL (DECODE (
57: p_sum_type,
58: 'PAID', awd.paid_amt,

Line 73: CURSOR c_match_sum(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

69: AND fmast.fund_code = fcat.fund_code
70: AND awd.fund_id = fmast.fund_id;
71:
72: --Cursor to find the SUM of Amounts for Matching funds
73: CURSOR c_match_sum(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
74: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)
75: IS
76: SELECT SUM (NVL (DECODE (
77: p_sum_type,

Line 74: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)

70: AND awd.fund_id = fmast.fund_id;
71:
72: --Cursor to find the SUM of Amounts for Matching funds
73: CURSOR c_match_sum(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
74: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)
75: IS
76: SELECT SUM (NVL (DECODE (
77: p_sum_type,
78: 'PAID', awd.paid_amt,

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

87: WHERE ci_cal_type = cp_ci_cal_type
88: AND ci_sequence_number = cp_ci_sequence_number);
89:
90: --Cursor to find the User Parameter Award Year (which is same as Alternate Code)
91: CURSOR c_alternate_code(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
92: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
93: SELECT alternate_code
94: FROM igs_ca_inst
95: WHERE cal_type = cp_ci_cal_type

Line 92: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS

88: AND ci_sequence_number = cp_ci_sequence_number);
89:
90: --Cursor to find the User Parameter Award Year (which is same as Alternate Code)
91: CURSOR c_alternate_code(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
92: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
93: SELECT alternate_code
94: FROM igs_ca_inst
95: WHERE cal_type = cp_ci_cal_type
96: AND sequence_number = cp_ci_sequence_number;

Line 94: FROM igs_ca_inst

90: --Cursor to find the User Parameter Award Year (which is same as Alternate Code)
91: CURSOR c_alternate_code(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
92: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
93: SELECT alternate_code
94: FROM igs_ca_inst
95: WHERE cal_type = cp_ci_cal_type
96: AND sequence_number = cp_ci_sequence_number;
97:
98: BEGIN