APPS.IGS_FI_VAL_FTCI dependencies on IGS_CA_INST_REL

Line 42: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;

38: BEGIN -- finp_val_ftci_account
39: -- Validate the IGS_FI_F_TYP_CA_INST calendar instance
40: -- is a subordinate of the IGS_FI_ACC finace calendar instance.
41: DECLARE
42: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
43: CURSOR c_cir IS
44: SELECT sub_cal_type
45: FROM IGS_CA_INST_REL
46: WHERE sub_cal_type = p_fee_cal_type AND

Line 45: FROM IGS_CA_INST_REL

41: DECLARE
42: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
43: CURSOR c_cir IS
44: SELECT sub_cal_type
45: FROM IGS_CA_INST_REL
46: WHERE sub_cal_type = p_fee_cal_type AND
47: sub_ci_sequence_number = p_fee_ci_sequence_number ;
48: BEGIN
49: -- Set the default message number

Line 81: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;

77: RETURN BOOLEAN AS
78: gv_other_detail VARCHAR2(255);
79: BEGIN
80: DECLARE
81: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
82: cst_cal_cat CONSTANT VARCHAR2(8):= 'TEACHING';
83: CURSOR c_cir IS
84: SELECT cir.sub_cal_type
85: FROM IGS_CA_INST_REL cir

Line 85: FROM IGS_CA_INST_REL cir

81: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
82: cst_cal_cat CONSTANT VARCHAR2(8):= 'TEACHING';
83: CURSOR c_cir IS
84: SELECT cir.sub_cal_type
85: FROM IGS_CA_INST_REL cir
86: WHERE cir.sub_cal_type = p_fee_cal_type AND
87: cir.sub_ci_sequence_number = p_fee_ci_sequence_number AND
88: cir.sup_cal_type IN ( SELECT ct.CAL_TYPE
89: FROM IGS_CA_TYPE ct