APPS.IGS_PE_WF_GEN dependencies on IGS_CA_INST_ALL

Line 1349: FROM igs_ca_inst_all

1345: AND lookup_code = cp_lookup_code;
1346:
1347: CURSOR term_desc_cur (cp_cal_type VARCHAR2, cp_sequence_number NUMBER) IS
1348: SELECT description
1349: FROM igs_ca_inst_all
1350: WHERE cal_type = cp_cal_type
1351: AND sequence_number = cp_sequence_number;
1352:
1353: l_person_id NUMBER;

Line 1360: l_term_desc igs_ca_inst_all.description%TYPE;

1356: l_old_acad_intent_code VARCHAR2(30);
1357: l_acad_intent_desc VARCHAR2(80);
1358: l_old_acad_intent_desc VARCHAR2(80);
1359:
1360: l_term_desc igs_ca_inst_all.description%TYPE;
1361: l_cal_type igs_ca_inst_all.cal_type%TYPE;
1362: l_cal_seq_num igs_ca_inst_all.sequence_number%TYPE;
1363:
1364: person_dtl_rec person_dtl_cur%ROWTYPE;

Line 1361: l_cal_type igs_ca_inst_all.cal_type%TYPE;

1357: l_acad_intent_desc VARCHAR2(80);
1358: l_old_acad_intent_desc VARCHAR2(80);
1359:
1360: l_term_desc igs_ca_inst_all.description%TYPE;
1361: l_cal_type igs_ca_inst_all.cal_type%TYPE;
1362: l_cal_seq_num igs_ca_inst_all.sequence_number%TYPE;
1363:
1364: person_dtl_rec person_dtl_cur%ROWTYPE;
1365:

Line 1362: l_cal_seq_num igs_ca_inst_all.sequence_number%TYPE;

1358: l_old_acad_intent_desc VARCHAR2(80);
1359:
1360: l_term_desc igs_ca_inst_all.description%TYPE;
1361: l_cal_type igs_ca_inst_all.cal_type%TYPE;
1362: l_cal_seq_num igs_ca_inst_all.sequence_number%TYPE;
1363:
1364: person_dtl_rec person_dtl_cur%ROWTYPE;
1365:
1366: BEGIN