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 IGS_FI_F_CAT_FEE_LBL

Line 75: FROM igs_fi_f_cat_fee_lbl_v fcflv,

71: ----------------------------------------------------------------------------*/
72: CURSOR c_fcfldate IS
73: SELECT TRUNC(da1.alias_val) start_dt_alias_val,
74: TRUNC(da2.alias_val) end_dt_alias_val
75: FROM igs_fi_f_cat_fee_lbl_v fcflv,
76: igs_ca_da_inst_v da1,
77: igs_ca_da_inst_v da2
78: WHERE da1.dt_alias = fcflv.start_dt_alias
79: AND da1.sequence_number = fcflv.start_dai_sequence_number

Line 360: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAT%TYPE ,

356: FUNCTION finp_get_fcfl_dai(
357: p_dt_alias_column_name IN VARCHAR2 ,
358: p_dai_seq_num_column_name IN VARCHAR2 ,
359: p_get_column_name IN VARCHAR2 ,
360: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAT%TYPE ,
361: p_fee_cal_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_cal_type%TYPE ,
362: p_fee_ci_sequence_number IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_ci_sequence_number%TYPE ,
363: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE )
364: RETURN VARCHAR2 AS

Line 361: p_fee_cal_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_cal_type%TYPE ,

357: p_dt_alias_column_name IN VARCHAR2 ,
358: p_dai_seq_num_column_name IN VARCHAR2 ,
359: p_get_column_name IN VARCHAR2 ,
360: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAT%TYPE ,
361: p_fee_cal_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_cal_type%TYPE ,
362: p_fee_ci_sequence_number IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_ci_sequence_number%TYPE ,
363: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE )
364: RETURN VARCHAR2 AS
365:

Line 362: p_fee_ci_sequence_number IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_ci_sequence_number%TYPE ,

358: p_dai_seq_num_column_name IN VARCHAR2 ,
359: p_get_column_name IN VARCHAR2 ,
360: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAT%TYPE ,
361: p_fee_cal_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_cal_type%TYPE ,
362: p_fee_ci_sequence_number IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_ci_sequence_number%TYPE ,
363: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE )
364: RETURN VARCHAR2 AS
365:
366: BEGIN

Line 363: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE )

359: p_get_column_name IN VARCHAR2 ,
360: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAT%TYPE ,
361: p_fee_cal_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_cal_type%TYPE ,
362: p_fee_ci_sequence_number IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_ci_sequence_number%TYPE ,
363: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE )
364: RETURN VARCHAR2 AS
365:
366: BEGIN
367: DECLARE

Line 371: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE ,

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,
375: 'START_DT_ALIAS', ftci.start_dt_alias,

Line 372: cp_fee_ci_sequence_number IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE,

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,
375: 'START_DT_ALIAS', ftci.start_dt_alias,
376: 'END_DT_ALIAS', ftci.end_dt_alias,

Line 373: cp_fee_type IGS_FI_F_CAT_FEE_LBL.FEE_TYPE%TYPE ) IS

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,
375: 'START_DT_ALIAS', ftci.start_dt_alias,
376: 'END_DT_ALIAS', ftci.end_dt_alias,
377: 'RETRO_DT_ALIAS', ftci.retro_dt_alias),

Line 389: cp_fee_cat IGS_FI_F_CAT_FEE_LBL.FEE_CAT%TYPE ,

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
393: SELECT DECODE(cp_dt_alias_column_name,

Line 390: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE ,

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
393: SELECT DECODE(cp_dt_alias_column_name,
394: 'START_DT_ALIAS', fcci.start_dt_alias,

Line 392: IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE) IS

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
393: SELECT DECODE(cp_dt_alias_column_name,
394: 'START_DT_ALIAS', fcci.start_dt_alias,
395: 'END_DT_ALIAS', fcci.end_dt_alias,
396: 'RETRO_DT_ALIAS', fcci.retro_dt_alias),

Line 531: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,

527: FUNCTION finp_get_fee_trigger(
528: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
529: p_fee_cal_type IN IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE ,
530: p_fee_ci_sequence_number IN IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
531: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
532: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
533: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
534: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
535: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,