DBA Data[Home] [Help]

APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_FI_FEE_TYPE

Line 15: igs_fi_fee_type ft,

11: SELECT ftci.fee_cal_type, ftci.fee_ci_sequence_number
12: FROM igs_fi_f_typ_ca_inst ftci,
13: igs_ca_da_inst_v daiv,
14: igs_ca_da_inst_v daiv1,
15: igs_fi_fee_type ft,
16: igs_fi_fee_str_stat stat
17: WHERE ftci.fee_type = ft.fee_type
18: AND ft.s_fee_type = 'DOCUMENT'
19: AND ftci.fee_type_ci_status = stat.fee_structure_status

Line 729: igs_fi_fee_type ft,

725: ft.description description
726: FROM igs_fi_f_typ_ca_inst ftci,
727: igs_ca_da_inst_v daiv,
728: igs_ca_da_inst_v daiv1,
729: igs_fi_fee_type ft,
730: igs_fi_fee_str_stat stat
731: WHERE ftci.fee_type = ft.fee_type
732: AND ft.s_fee_type = 'DOCUMENT'
733: AND ftci.fee_type_ci_status = stat.fee_structure_status

Line 2519: igs_fi_fee_type ft,

2515: ft.description description
2516: FROM igs_fi_f_typ_ca_inst ftci,
2517: igs_ca_da_inst_v daiv,
2518: igs_ca_da_inst_v daiv1,
2519: igs_fi_fee_type ft,
2520: igs_fi_fee_str_stat stat
2521: WHERE ftci.fee_type = ft.fee_type
2522: AND ft.s_fee_type = 'DOCUMENT'
2523: AND ftci.fee_type_ci_status = stat.fee_structure_status