APPS.IGS_EN_ELGBL_PERSON dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 1471: CURSOR c_load_cal (cp_teach_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,

1467:
1468: --
1469: -- cursor to fetch load cal type and load seq number based on teach cal type and teach seq number
1470: --
1471: CURSOR c_load_cal (cp_teach_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
1472: cp_teach_ci_seq_no igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS
1473: SELECT load_cal_type,
1474: load_ci_sequence_number
1475: FROM igs_ca_teach_to_load_v

Line 1472: cp_teach_ci_seq_no igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS

1468: --
1469: -- cursor to fetch load cal type and load seq number based on teach cal type and teach seq number
1470: --
1471: CURSOR c_load_cal (cp_teach_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
1472: cp_teach_ci_seq_no igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS
1473: SELECT load_cal_type,
1474: load_ci_sequence_number
1475: FROM igs_ca_teach_to_load_v
1476: WHERE teach_cal_type = cp_teach_cal_type

Line 1475: FROM igs_ca_teach_to_load_v

1471: CURSOR c_load_cal (cp_teach_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
1472: cp_teach_ci_seq_no igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS
1473: SELECT load_cal_type,
1474: load_ci_sequence_number
1475: FROM igs_ca_teach_to_load_v
1476: WHERE teach_cal_type = cp_teach_cal_type
1477: AND teach_ci_sequence_number = cp_teach_ci_seq_no;
1478: rec_load_cal c_load_cal%ROWTYPE;
1479: lv_validate_timeslot CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('IGS_EN_VAL_TIMESLOT');