eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_GEN_001 dependencies on USER_TAB_COLUMNS

Line 369: CURSOR c_ftci_dai (cp_dt_alias_column_name user_tab_columns.column_name%TYPE,

365:
366: BEGIN
367: DECLARE
368: -- cursor to get dt alias's for the fee type calendar instance
369: CURSOR c_ftci_dai (cp_dt_alias_column_name user_tab_columns.column_name%TYPE,
370: cp_dai_seq_num_column_name user_tab_columns.column_name%TYPE,
371: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE ,
372: cp_fee_ci_sequence_number IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE,
373: cp_fee_type IGS_FI_F_CAT_FEE_LBL.FEE_TYPE%TYPE ) IS

Line 370: cp_dai_seq_num_column_name user_tab_columns.column_name%TYPE,

366: BEGIN
367: DECLARE
368: -- cursor to get dt alias's for the fee type calendar instance
369: CURSOR c_ftci_dai (cp_dt_alias_column_name user_tab_columns.column_name%TYPE,
370: cp_dai_seq_num_column_name user_tab_columns.column_name%TYPE,
371: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE ,
372: cp_fee_ci_sequence_number IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE,
373: cp_fee_type IGS_FI_F_CAT_FEE_LBL.FEE_TYPE%TYPE ) IS
374: SELECT DECODE(cp_dt_alias_column_name,

Line 387: CURSOR c_fcci_dai (cp_dt_alias_column_name user_tab_columns.column_name%TYPE,

383: WHERE ftci.FEE_TYPE = cp_fee_type AND
384: ftci.fee_cal_type = cp_fee_cal_type AND
385: ftci.fee_ci_sequence_number = cp_fee_ci_sequence_number;
386: -- cursor to get dt alias's for the fee category calendar instance
387: CURSOR c_fcci_dai (cp_dt_alias_column_name user_tab_columns.column_name%TYPE,
388: cp_dai_seq_num_column_name user_tab_columns.column_name%TYPE,
389: cp_fee_cat IGS_FI_F_CAT_FEE_LBL.FEE_CAT%TYPE ,
390: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE ,
391: cp_fee_ci_sequence_number

Line 388: cp_dai_seq_num_column_name user_tab_columns.column_name%TYPE,

384: ftci.fee_cal_type = cp_fee_cal_type AND
385: ftci.fee_ci_sequence_number = cp_fee_ci_sequence_number;
386: -- cursor to get dt alias's for the fee category calendar instance
387: CURSOR c_fcci_dai (cp_dt_alias_column_name user_tab_columns.column_name%TYPE,
388: cp_dai_seq_num_column_name user_tab_columns.column_name%TYPE,
389: cp_fee_cat IGS_FI_F_CAT_FEE_LBL.FEE_CAT%TYPE ,
390: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE ,
391: cp_fee_ci_sequence_number
392: IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE) IS