DBA Data[Home] [Help]

APPS.IGF_SL_REL_DISB dependencies on IGF_AP_TD_ITEM_INST_ALL

Line 881: cp_status igf_ap_td_item_inst_all.status%TYPE,

877:
878: CURSOR c_fnd_todo(
879: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
880: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
881: cp_status igf_ap_td_item_inst_all.status%TYPE,
882: cp_inactive igf_ap_td_item_inst_all.inactive_flag%TYPE
883: ) IS
884: SELECT 'x'
885: FROM igf_aw_fund_mast_all fmast,

Line 882: cp_inactive igf_ap_td_item_inst_all.inactive_flag%TYPE

878: CURSOR c_fnd_todo(
879: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
880: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
881: cp_status igf_ap_td_item_inst_all.status%TYPE,
882: cp_inactive igf_ap_td_item_inst_all.inactive_flag%TYPE
883: ) IS
884: SELECT 'x'
885: FROM igf_aw_fund_mast_all fmast,
886: igf_aw_fund_td_map_all fndtd,

Line 887: igf_ap_td_item_inst_all tdinst,

883: ) IS
884: SELECT 'x'
885: FROM igf_aw_fund_mast_all fmast,
886: igf_aw_fund_td_map_all fndtd,
887: igf_ap_td_item_inst_all tdinst,
888: igf_ap_td_item_mst_all tdmst
889: WHERE fmast.fund_id = cp_fund_id
890: AND tdinst.base_id = cp_base_id
891: AND fndtd.fund_id = fmast.fund_id