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_CA_INST

Line 401: FROM IGS_FI_F_CAT_CA_INST fcci

397: DECODE(cp_dai_seq_num_column_name,
398: 'START_DAI_SEQUENCE_NUMBER', fcci.start_dai_sequence_number,
399: 'END_DAI_SEQUENCE_NUMBER', fcci.end_dai_sequence_number,
400: 'RETRO_DAI_SEQUENCE_NUMBER', fcci.retro_dai_sequence_number)
401: FROM IGS_FI_F_CAT_CA_INST fcci
402: WHERE fcci.FEE_CAT = cp_fee_cat AND
403: fcci.fee_cal_type = cp_fee_cal_type AND
404: fcci.fee_ci_sequence_number = cp_fee_ci_sequence_number;
405: v_ftci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;

Line 528: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,

524: return NULL;
525: END finp_get_fdf_st_dt;
526: --
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 ,

Line 529: p_fee_cal_type IN IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE ,

525: END finp_get_fdf_st_dt;
526: --
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 ,

Line 530: p_fee_ci_sequence_number IN IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,

526: --
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 ,

Line 1039: CURSOR c_fcci ( cp_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,

1035: daiv.sequence_number = ftci.end_dai_sequence_number AND
1036: daiv.CAL_TYPE = ftci.fee_cal_type AND
1037: daiv.ci_sequence_number = ftci.fee_ci_sequence_number;
1038: -- this cursor finds the fee cat cal instance end date alias instance value
1039: CURSOR c_fcci ( cp_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
1040: cp_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE,
1041: cp_fee_ci_sequence_num IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE) IS
1042: SELECT daiv.alias_val
1043: FROM IGS_CA_DA_INST_V daiv,

Line 1040: cp_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE,

1036: daiv.CAL_TYPE = ftci.fee_cal_type AND
1037: daiv.ci_sequence_number = ftci.fee_ci_sequence_number;
1038: -- this cursor finds the fee cat cal instance end date alias instance value
1039: CURSOR c_fcci ( cp_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
1040: cp_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE,
1041: cp_fee_ci_sequence_num IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE) IS
1042: SELECT daiv.alias_val
1043: FROM IGS_CA_DA_INST_V daiv,
1044: IGS_FI_F_CAT_CA_INST fcci

Line 1041: cp_fee_ci_sequence_num IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE) IS

1037: daiv.ci_sequence_number = ftci.fee_ci_sequence_number;
1038: -- this cursor finds the fee cat cal instance end date alias instance value
1039: CURSOR c_fcci ( cp_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
1040: cp_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE,
1041: cp_fee_ci_sequence_num IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE) IS
1042: SELECT daiv.alias_val
1043: FROM IGS_CA_DA_INST_V daiv,
1044: IGS_FI_F_CAT_CA_INST fcci
1045: WHERE fcci.FEE_CAT = cp_fee_cat AND

Line 1044: IGS_FI_F_CAT_CA_INST fcci

1040: cp_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE,
1041: cp_fee_ci_sequence_num IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE) IS
1042: SELECT daiv.alias_val
1043: FROM IGS_CA_DA_INST_V daiv,
1044: IGS_FI_F_CAT_CA_INST fcci
1045: WHERE fcci.FEE_CAT = cp_fee_cat AND
1046: fcci.fee_cal_type = cp_fee_cal_type AND
1047: fcci.fee_ci_sequence_number = cp_fee_ci_sequence_num AND
1048: daiv.DT_ALIAS = fcci.end_dt_alias AND