APPS.IGS_AU_GEN_002 dependencies on IGS_FI_FEE_TYPE_CI_H

Line 469: p_fee_type IN igs_fi_fee_type_ci_h_all.fee_type%TYPE ,

465: END audp_get_fsrh_col;
466:
467: FUNCTION audp_get_ftcih_col(
468: p_column_name IN user_tab_columns.column_name%TYPE ,
469: p_fee_type IN igs_fi_fee_type_ci_h_all.fee_type%TYPE ,
470: p_fee_cal_type IN igs_fi_fee_type_ci_h_all.fee_cal_type%TYPE ,
471: p_fee_ci_sequence_number IN NUMBER ,
472: p_hist_end_dt IN igs_fi_fee_type_ci_h_all.hist_end_dt%TYPE )
473: RETURN VARCHAR2 AS

Line 470: p_fee_cal_type IN igs_fi_fee_type_ci_h_all.fee_cal_type%TYPE ,

466:
467: FUNCTION audp_get_ftcih_col(
468: p_column_name IN user_tab_columns.column_name%TYPE ,
469: p_fee_type IN igs_fi_fee_type_ci_h_all.fee_type%TYPE ,
470: p_fee_cal_type IN igs_fi_fee_type_ci_h_all.fee_cal_type%TYPE ,
471: p_fee_ci_sequence_number IN NUMBER ,
472: p_hist_end_dt IN igs_fi_fee_type_ci_h_all.hist_end_dt%TYPE )
473: RETURN VARCHAR2 AS
474: /*************************************************************

Line 472: p_hist_end_dt IN igs_fi_fee_type_ci_h_all.hist_end_dt%TYPE )

468: p_column_name IN user_tab_columns.column_name%TYPE ,
469: p_fee_type IN igs_fi_fee_type_ci_h_all.fee_type%TYPE ,
470: p_fee_cal_type IN igs_fi_fee_type_ci_h_all.fee_cal_type%TYPE ,
471: p_fee_ci_sequence_number IN NUMBER ,
472: p_hist_end_dt IN igs_fi_fee_type_ci_h_all.hist_end_dt%TYPE )
473: RETURN VARCHAR2 AS
474: /*************************************************************
475: Created By :
476: Date Created By :

Line 509: FROM igs_fi_fee_type_ci_h ftcih

505: cst_retro_dt_alias, ftcih.retro_dt_alias,
506: cst_retro_dai_sequence_number, TO_CHAR(ftcih.retro_dai_sequence_number),
507: cst_s_chg_method_type, ftcih.s_chg_method_type,
508: cst_rul_sequence_number, TO_CHAR(ftcih.rul_sequence_number))
509: FROM igs_fi_fee_type_ci_h ftcih
510: WHERE ftcih.fee_type = p_fee_type AND
511: ftcih.fee_cal_type = p_fee_cal_type AND
512: ftcih.fee_ci_sequence_number = p_fee_ci_sequence_number AND
513: ftcih.hist_start_dt >= p_hist_end_dt AND