APPS.IGS_AU_GEN_002 dependencies on IGS_FI_F_CAT_F_LBL_H

Line 289: p_fee_cat IN igs_fi_f_cat_f_lbl_h_all.fee_cat%TYPE ,

285: END audp_get_dh_col;
286:
287: FUNCTION audp_get_fcflh_col(
288: p_column_name IN user_tab_columns.column_name%TYPE ,
289: p_fee_cat IN igs_fi_f_cat_f_lbl_h_all.fee_cat%TYPE ,
290: p_fee_cal_type IN VARCHAR2 ,
291: p_fee_ci_sequence_number IN NUMBER ,
292: p_fee_type IN igs_fi_f_cat_f_lbl_h_all.fee_type%TYPE ,
293: p_hist_end_dt IN DATE )

Line 292: p_fee_type IN igs_fi_f_cat_f_lbl_h_all.fee_type%TYPE ,

288: p_column_name IN user_tab_columns.column_name%TYPE ,
289: p_fee_cat IN igs_fi_f_cat_f_lbl_h_all.fee_cat%TYPE ,
290: p_fee_cal_type IN VARCHAR2 ,
291: p_fee_ci_sequence_number IN NUMBER ,
292: p_fee_type IN igs_fi_f_cat_f_lbl_h_all.fee_type%TYPE ,
293: p_hist_end_dt IN DATE )
294: RETURN VARCHAR2 AS
295: /*************************************************************
296: Created By :

Line 323: FROM igs_fi_f_cat_f_lbl_h fcflh

319: cst_start_dt_alias, fcflh.start_dt_alias,
320: cst_start_dai_sequence_number, TO_CHAR(fcflh.start_dai_sequence_number),
321: cst_s_chg_method_type, fcflh.s_chg_method_type,
322: cst_rul_sequence_number, TO_CHAR(fcflh.rul_sequence_number))
323: FROM igs_fi_f_cat_f_lbl_h fcflh
324: WHERE fcflh.fee_cat = p_fee_cat AND
325: fcflh.fee_cal_type = p_fee_cal_type AND
326: fcflh.fee_ci_sequence_number = p_fee_ci_sequence_number AND
327: fcflh.fee_type = p_fee_type AND