[Home] [Help]
1222: cp_inactive igf_ap_td_item_inst_all.inactive_flag%TYPE
1223: ) IS
1224: SELECT 'x'
1225: FROM igf_aw_fund_mast_all fmast,
1226: igf_aw_fund_td_map_all fndtd,
1227: igf_ap_td_item_inst_all tdinst,
1228: igf_ap_td_item_mst_all tdmst
1229: WHERE fmast.fund_id = cp_fund_id
1230: AND tdinst.base_id = cp_base_id
1236: AND tdinst.inactive_flag <> cp_inactive
1237: UNION
1238: SELECT 'x'
1239: FROM igf_aw_fund_mast_all fmast,
1240: igf_aw_fund_td_map_all fndtd,
1241: igf_ap_td_item_inst_v tdinst,
1242: igf_ap_td_item_mst_all tdmst,
1243: igf_ap_fa_base_rec_all fa
1244: WHERE fmast.fund_id = cp_fund_id