DBA Data[Home] [Help]

APPS.IGF_AP_INST_APP dependencies on IGF_AP_TD_ITEM_MST_ALL

Line 27: FROM igf_ap_td_item_inst_all tdinst, igf_ap_td_item_mst_all tdmst, Igf_ap_fa_base_rec_all baseRec

23: CURSOR c_td_item (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
24: cp_application_code igf_ap_appl_status_all.application_code%TYPE)
25: IS
26: SELECT tdmst.todo_number
27: FROM igf_ap_td_item_inst_all tdinst, igf_ap_td_item_mst_all tdmst, Igf_ap_fa_base_rec_all baseRec
28: WHERE tdmst.system_todo_type_code = 'INSTAPP'
29: AND baseRec.ci_cal_type = tdmst.ci_cal_type
30: AND baseRec.ci_sequence_number = tdmst.ci_sequence_number
31: AND baseRec.base_id = tdinst.base_id

Line 97: FROM igf_ap_td_item_inst_all tdinst, igf_ap_td_item_mst_all tdmst, Igf_ap_fa_base_rec_all baseRec

93: CURSOR c_td_item (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
94: cp_application_code igf_ap_appl_status_all.application_code%TYPE)
95: IS
96: SELECT tdmst.todo_number
97: FROM igf_ap_td_item_inst_all tdinst, igf_ap_td_item_mst_all tdmst, Igf_ap_fa_base_rec_all baseRec
98: WHERE tdmst.system_todo_type_code = 'INSTAPP'
99: AND baseRec.ci_cal_type = tdmst.ci_cal_type
100: AND baseRec.ci_sequence_number = tdmst.ci_sequence_number
101: AND baseRec.base_id = tdinst.base_id