APPS.IGF_AW_COA_CALC dependencies on IGS_CA_INST

Line 81: g_cal_type igs_ca_inst.cal_type%TYPE;

77: --------------------------------------------------------------------------------
78:
79: g_b_header BOOLEAN;
80: g_coa_updated VARCHAR2(1) ;
81: g_cal_type igs_ca_inst.cal_type%TYPE;
82: g_sequence_number igs_ca_inst.sequence_number%TYPE;
83:
84: E_SKIP_STUDENT EXCEPTION;
85: E_SKIP_STD_NO_ITEMS EXCEPTION;

Line 82: g_sequence_number igs_ca_inst.sequence_number%TYPE;

78:
79: g_b_header BOOLEAN;
80: g_coa_updated VARCHAR2(1) ;
81: g_cal_type igs_ca_inst.cal_type%TYPE;
82: g_sequence_number igs_ca_inst.sequence_number%TYPE;
83:
84: E_SKIP_STUDENT EXCEPTION;
85: E_SKIP_STD_NO_ITEMS EXCEPTION;
86: E_SKIP_STD_NO_TERMS EXCEPTION;

Line 1676: igs_ca_inst ca

1672: ) IS
1673: SELECT ca.alternate_code term,
1674: SUM(NVL(terms.amount,0)) amount
1675: FROM igf_aw_coa_itm_terms terms,
1676: igs_ca_inst ca
1677: WHERE ca.cal_type = terms.ld_cal_type
1678: AND ca.sequence_number = terms.ld_sequence_number
1679: AND terms.base_id = c_base_id
1680: GROUP BY base_id,