APPS.IGS_FI_GEN_008 dependencies on IGS_FI_FEE_RET_SCHD

Line 490: FUNCTION get_fee_retention_amount(p_v_fee_cat IN igs_fi_fee_ret_schd.fee_cat%TYPE,

486:
487: END get_teach_retention;
488:
489:
490: FUNCTION get_fee_retention_amount(p_v_fee_cat IN igs_fi_fee_ret_schd.fee_cat%TYPE,
491: p_v_fee_cal_type IN igs_fi_fee_ret_schd.fee_cal_type%TYPE,
492: p_n_fee_ci_sequence_number IN igs_fi_fee_ret_schd.fee_ci_sequence_number%TYPE,
493: p_v_fee_type IN igs_fi_fee_ret_schd.fee_type%TYPE,
494: p_n_diff_amount IN NUMBER) RETURN NUMBER IS

Line 491: p_v_fee_cal_type IN igs_fi_fee_ret_schd.fee_cal_type%TYPE,

487: END get_teach_retention;
488:
489:
490: FUNCTION get_fee_retention_amount(p_v_fee_cat IN igs_fi_fee_ret_schd.fee_cat%TYPE,
491: p_v_fee_cal_type IN igs_fi_fee_ret_schd.fee_cal_type%TYPE,
492: p_n_fee_ci_sequence_number IN igs_fi_fee_ret_schd.fee_ci_sequence_number%TYPE,
493: p_v_fee_type IN igs_fi_fee_ret_schd.fee_type%TYPE,
494: p_n_diff_amount IN NUMBER) RETURN NUMBER IS
495: /**************************************************************************

Line 492: p_n_fee_ci_sequence_number IN igs_fi_fee_ret_schd.fee_ci_sequence_number%TYPE,

488:
489:
490: FUNCTION get_fee_retention_amount(p_v_fee_cat IN igs_fi_fee_ret_schd.fee_cat%TYPE,
491: p_v_fee_cal_type IN igs_fi_fee_ret_schd.fee_cal_type%TYPE,
492: p_n_fee_ci_sequence_number IN igs_fi_fee_ret_schd.fee_ci_sequence_number%TYPE,
493: p_v_fee_type IN igs_fi_fee_ret_schd.fee_type%TYPE,
494: p_n_diff_amount IN NUMBER) RETURN NUMBER IS
495: /**************************************************************************
496: Created By : Priya Athipatla

Line 493: p_v_fee_type IN igs_fi_fee_ret_schd.fee_type%TYPE,

489:
490: FUNCTION get_fee_retention_amount(p_v_fee_cat IN igs_fi_fee_ret_schd.fee_cat%TYPE,
491: p_v_fee_cal_type IN igs_fi_fee_ret_schd.fee_cal_type%TYPE,
492: p_n_fee_ci_sequence_number IN igs_fi_fee_ret_schd.fee_ci_sequence_number%TYPE,
493: p_v_fee_type IN igs_fi_fee_ret_schd.fee_type%TYPE,
494: p_n_diff_amount IN NUMBER) RETURN NUMBER IS
495: /**************************************************************************
496: Created By : Priya Athipatla
497: Date Created By: 03-Sep-2004

Line 508: CURSOR cur_fee_ret(cp_v_fee_type igs_fi_fee_ret_schd.fee_type%TYPE,

504: **************************************************************************/
505:
506: -- Select retention records for the specified FTCI and Fee Cat
507: -- This cursor will be used for non-Special Fee Types
508: CURSOR cur_fee_ret(cp_v_fee_type igs_fi_fee_ret_schd.fee_type%TYPE,
509: cp_v_fee_cal_type igs_fi_fee_ret_schd.fee_cal_type%TYPE,
510: cp_n_fee_ci_seq_num igs_fi_fee_ret_schd.fee_ci_sequence_number%TYPE,
511: cp_v_fee_cat igs_fi_fee_ret_schd.fee_cat%TYPE) IS
512: SELECT retention_percentage,

Line 509: cp_v_fee_cal_type igs_fi_fee_ret_schd.fee_cal_type%TYPE,

505:
506: -- Select retention records for the specified FTCI and Fee Cat
507: -- This cursor will be used for non-Special Fee Types
508: CURSOR cur_fee_ret(cp_v_fee_type igs_fi_fee_ret_schd.fee_type%TYPE,
509: cp_v_fee_cal_type igs_fi_fee_ret_schd.fee_cal_type%TYPE,
510: cp_n_fee_ci_seq_num igs_fi_fee_ret_schd.fee_ci_sequence_number%TYPE,
511: cp_v_fee_cat igs_fi_fee_ret_schd.fee_cat%TYPE) IS
512: SELECT retention_percentage,
513: retention_amount

Line 510: cp_n_fee_ci_seq_num igs_fi_fee_ret_schd.fee_ci_sequence_number%TYPE,

506: -- Select retention records for the specified FTCI and Fee Cat
507: -- This cursor will be used for non-Special Fee Types
508: CURSOR cur_fee_ret(cp_v_fee_type igs_fi_fee_ret_schd.fee_type%TYPE,
509: cp_v_fee_cal_type igs_fi_fee_ret_schd.fee_cal_type%TYPE,
510: cp_n_fee_ci_seq_num igs_fi_fee_ret_schd.fee_ci_sequence_number%TYPE,
511: cp_v_fee_cat igs_fi_fee_ret_schd.fee_cat%TYPE) IS
512: SELECT retention_percentage,
513: retention_amount
514: FROM igs_fi_fee_ret_schd_f_type_v

Line 511: cp_v_fee_cat igs_fi_fee_ret_schd.fee_cat%TYPE) IS

507: -- This cursor will be used for non-Special Fee Types
508: CURSOR cur_fee_ret(cp_v_fee_type igs_fi_fee_ret_schd.fee_type%TYPE,
509: cp_v_fee_cal_type igs_fi_fee_ret_schd.fee_cal_type%TYPE,
510: cp_n_fee_ci_seq_num igs_fi_fee_ret_schd.fee_ci_sequence_number%TYPE,
511: cp_v_fee_cat igs_fi_fee_ret_schd.fee_cat%TYPE) IS
512: SELECT retention_percentage,
513: retention_amount
514: FROM igs_fi_fee_ret_schd_f_type_v
515: WHERE fee_type = cp_v_fee_type

Line 514: FROM igs_fi_fee_ret_schd_f_type_v

510: cp_n_fee_ci_seq_num igs_fi_fee_ret_schd.fee_ci_sequence_number%TYPE,
511: cp_v_fee_cat igs_fi_fee_ret_schd.fee_cat%TYPE) IS
512: SELECT retention_percentage,
513: retention_amount
514: FROM igs_fi_fee_ret_schd_f_type_v
515: WHERE fee_type = cp_v_fee_type
516: AND fee_cal_type = cp_v_fee_cal_type
517: AND fee_ci_sequence_number = cp_n_fee_ci_seq_num
518: AND ( (fee_cat = cp_v_fee_cat) OR (fee_cat IS NULL) )

Line 530: FROM igs_fi_fee_ret_schd_v

526: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
527: cp_v_relation_ftci VARCHAR2) IS
528: SELECT retention_percentage,
529: retention_amount
530: FROM igs_fi_fee_ret_schd_v
531: WHERE fee_type = cp_v_fee_type
532: AND fee_cal_type = cp_v_fee_cal_type
533: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_number
534: AND s_relation_type = cp_v_relation_ftci

Line 547: l_n_ret_amount igs_fi_fee_ret_schd.retention_amount%TYPE := 0.0;

543: WHERE fee_type = cp_v_fee_type;
544:
545: l_v_s_fee_type igs_fi_fee_type.s_fee_type%TYPE := NULL;
546:
547: l_n_ret_amount igs_fi_fee_ret_schd.retention_amount%TYPE := 0.0;
548: l_n_ret_percent igs_fi_fee_ret_schd.retention_percentage%TYPE := 0.0;
549:
550: -- Retention Amount calculated
551: l_n_amount NUMBER := 0.0;

Line 548: l_n_ret_percent igs_fi_fee_ret_schd.retention_percentage%TYPE := 0.0;

544:
545: l_v_s_fee_type igs_fi_fee_type.s_fee_type%TYPE := NULL;
546:
547: l_n_ret_amount igs_fi_fee_ret_schd.retention_amount%TYPE := 0.0;
548: l_n_ret_percent igs_fi_fee_ret_schd.retention_percentage%TYPE := 0.0;
549:
550: -- Retention Amount calculated
551: l_n_amount NUMBER := 0.0;
552: