APPS.IGS_FI_GEN_005 dependencies on IGS_FI_FEE_STR_STAT

Line 100: IGS_FI_FEE_STR_STAT fss,

96: ftci.fee_cal_type,
97: ftci.fee_ci_sequence_number,
98: ft.s_fee_trigger_cat
99: FROM IGS_FI_F_TYP_CA_INST ftci,
100: IGS_FI_FEE_STR_STAT fss,
101: IGS_FI_FEE_TYPE ft
102: WHERE (p_fee_type IS NULL OR
103: ftci.FEE_TYPE = p_fee_type) AND
104: fss.FEE_STRUCTURE_STATUS = ftci.fee_type_ci_status AND

Line 110: IGS_FI_FEE_STR_STAT fss

106: ft.FEE_TYPE = ftci.FEE_TYPE AND
107: ftci.FEE_TYPE IN
108: (SELECT FEE_TYPE
109: FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,
110: IGS_FI_FEE_STR_STAT fss
111: WHERE fcflv.FEE_CAT = p_fee_cat AND
112: fcflv.fee_cal_type = ftci.fee_cal_type AND
113: fcflv.fee_ci_sequence_number = ftci.fee_ci_sequence_number AND
114: fcflv.FEE_TYPE = ftci.FEE_TYPE AND