DBA Data[Home] [Help]

APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGF_AP_TD_ITEM_MST

Line 276: FROM igf_ap_td_item_mst im

272: */
273:
274: CURSOR todo_items_for_isir_cur IS
275: SELECT im.*
276: FROM igf_ap_td_item_mst im
277: WHERE im.system_todo_type_code = 'ISIR' -- for ISIR type only
278: AND im.ci_cal_type = g_ci_cal_type
279: AND im.ci_sequence_number = g_ci_sequence_number;
280:

Line 283: FROM igf_ap_td_item_inst ii, igf_ap_td_item_mst im

279: AND im.ci_sequence_number = g_ci_sequence_number;
280:
281: CURSOR check_todo_exists_inst_cur(lp_base_id NUMBER, p_item_seq_num NUMBER) IS
282: SELECT ii.rowid, ii.*
283: FROM igf_ap_td_item_inst ii, igf_ap_td_item_mst im
284: WHERE ii.item_sequence_number = im.todo_number
285: AND im.system_todo_type_code = 'ISIR'
286: AND im.ci_cal_type = g_ci_cal_type
287: AND im.ci_sequence_number = g_ci_sequence_number