APPS.IGS_FI_LB_FCIS_PKG dependencies on IGS_CA_INST_ALL

Line 84: CURSOR cur_fci_desc( cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,

80: || Change History :
81: || Who When What
82: || (reverse chronological order - newest change first)
83: */
84: CURSOR cur_fci_desc( cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
85: cp_n_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
86: SELECT description
87: FROM igs_ca_inst_all
88: WHERE cal_type = cp_v_cal_type

Line 85: cp_n_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS

81: || Who When What
82: || (reverse chronological order - newest change first)
83: */
84: CURSOR cur_fci_desc( cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
85: cp_n_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
86: SELECT description
87: FROM igs_ca_inst_all
88: WHERE cal_type = cp_v_cal_type
89: AND sequence_number = cp_n_seq_num;

Line 87: FROM igs_ca_inst_all

83: */
84: CURSOR cur_fci_desc( cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
85: cp_n_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
86: SELECT description
87: FROM igs_ca_inst_all
88: WHERE cal_type = cp_v_cal_type
89: AND sequence_number = cp_n_seq_num;
90: l_v_cal_desc igs_ca_inst_all.description%TYPE;
91:

Line 90: l_v_cal_desc igs_ca_inst_all.description%TYPE;

86: SELECT description
87: FROM igs_ca_inst_all
88: WHERE cal_type = cp_v_cal_type
89: AND sequence_number = cp_n_seq_num;
90: l_v_cal_desc igs_ca_inst_all.description%TYPE;
91:
92: BEGIN
93:
94: IF ( get_uk_for_validation (