APPS.IGF_DB_DISB dependencies on IGF_AP_TD_ITEM_INST_ALL

Line 1221: cp_status igf_ap_td_item_inst_all.status%TYPE,

1217: 'REPROCESSED','TOLERANCE','WAIVED');
1218: CURSOR c_fnd_todo(
1219: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1220: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1221: cp_status igf_ap_td_item_inst_all.status%TYPE,
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,

Line 1222: cp_inactive igf_ap_td_item_inst_all.inactive_flag%TYPE

1218: CURSOR c_fnd_todo(
1219: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1220: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1221: cp_status igf_ap_td_item_inst_all.status%TYPE,
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,

Line 1227: igf_ap_td_item_inst_all tdinst,

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
1231: AND fndtd.fund_id = fmast.fund_id