DBA Data[Home] [Help]

APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_FI_FEE_STR_STAT

Line 16: igs_fi_fee_str_stat stat

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
20: AND stat.s_fee_structure_status = 'ACTIVE'

Line 730: igs_fi_fee_str_stat stat

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
734: AND stat.s_fee_structure_status = 'ACTIVE'

Line 2520: igs_fi_fee_str_stat stat

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
2524: AND stat.s_fee_structure_status = 'ACTIVE'