APPS.IGF_AP_INST_APP dependencies on IGF_AP_TD_ITEM_INST_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 76: p_status IN igf_ap_td_item_inst_all.status%TYPE,

72: END update_ToDo_status;
73:
74: PROCEDURE update_ToDo (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
75: p_application_code igf_ap_appl_status_all.application_code%TYPE,
76: p_status IN igf_ap_td_item_inst_all.status%TYPE,
77: x_return_status OUT NOCOPY VARCHAR2)
78: IS
79: ------------------------------------------------------------------
80: --Created by : upinjark, Oracle India

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