APPS.IGS_FI_GEN_004 dependencies on IGS_FI_F_TYP_CA_INST

Line 463: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.fee_cal_type%TYPE,

459: l_v_load_cal_type igs_ca_inst_all.cal_type%TYPE;
460: l_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;
461:
462: CURSOR c_fee_cal_instance (
463: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.fee_cal_type%TYPE,
464: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.fee_ci_sequence_number%TYPE)
465: IS
466: SELECT 'x'
467: FROM IGS_FI_F_TYP_CA_INST ftci

Line 464: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.fee_ci_sequence_number%TYPE)

460: l_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;
461:
462: CURSOR c_fee_cal_instance (
463: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.fee_cal_type%TYPE,
464: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.fee_ci_sequence_number%TYPE)
465: IS
466: SELECT 'x'
467: FROM IGS_FI_F_TYP_CA_INST ftci
468: WHERE ftci.fee_cal_type = cp_fee_cal_type AND

Line 467: FROM IGS_FI_F_TYP_CA_INST ftci

463: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.fee_cal_type%TYPE,
464: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.fee_ci_sequence_number%TYPE)
465: IS
466: SELECT 'x'
467: FROM IGS_FI_F_TYP_CA_INST ftci
468: WHERE ftci.fee_cal_type = cp_fee_cal_type AND
469: ftci.fee_ci_sequence_number = cp_fee_ci_sequence_number;
470: -- Modified the cursor
471: -- removed the 'DISTINCT' clause, added for update of clause

Line 906: cp_fee_type IGS_FI_F_TYP_CA_INST.FEE_TYPE%TYPE,

902: l_b_fci_lci BOOLEAN := FALSE;
903: l_org_id VARCHAR2(15);
904:
905: CURSOR c_fee_cal_instance (
906: cp_fee_type IGS_FI_F_TYP_CA_INST.FEE_TYPE%TYPE,
907: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.fee_cal_type%TYPE,
908: cp_fee_ci_sequence_number
909: IGS_FI_F_TYP_CA_INST.fee_ci_sequence_number%TYPE) IS
910: SELECT 'x'

Line 907: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.fee_cal_type%TYPE,

903: l_org_id VARCHAR2(15);
904:
905: CURSOR c_fee_cal_instance (
906: cp_fee_type IGS_FI_F_TYP_CA_INST.FEE_TYPE%TYPE,
907: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.fee_cal_type%TYPE,
908: cp_fee_ci_sequence_number
909: IGS_FI_F_TYP_CA_INST.fee_ci_sequence_number%TYPE) IS
910: SELECT 'x'
911: FROM IGS_FI_F_TYP_CA_INST ftci

Line 909: IGS_FI_F_TYP_CA_INST.fee_ci_sequence_number%TYPE) IS

905: CURSOR c_fee_cal_instance (
906: cp_fee_type IGS_FI_F_TYP_CA_INST.FEE_TYPE%TYPE,
907: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.fee_cal_type%TYPE,
908: cp_fee_ci_sequence_number
909: IGS_FI_F_TYP_CA_INST.fee_ci_sequence_number%TYPE) IS
910: SELECT 'x'
911: FROM IGS_FI_F_TYP_CA_INST ftci
912: WHERE ftci.FEE_TYPE = cp_fee_type AND
913: ftci.fee_cal_type = cp_fee_cal_type AND

Line 911: FROM IGS_FI_F_TYP_CA_INST ftci

907: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.fee_cal_type%TYPE,
908: cp_fee_ci_sequence_number
909: IGS_FI_F_TYP_CA_INST.fee_ci_sequence_number%TYPE) IS
910: SELECT 'x'
911: FROM IGS_FI_F_TYP_CA_INST ftci
912: WHERE ftci.FEE_TYPE = cp_fee_type AND
913: ftci.fee_cal_type = cp_fee_cal_type AND
914: ftci.fee_ci_sequence_number = cp_fee_ci_sequence_number;
915: