APPS.IGF_AP_TD_ITEM_INST_PKG dependencies on IGF_AP_ST_INST_APPL_ALL

Line 452: FROM igf_ap_st_inst_appl_all

448: AND td_mst.todo_number = td_inst.item_sequence_number
449: AND td_inst.base_id = cp_base_id
450: AND td_inst.item_sequence_number = cp_item_sequence_number
451: AND appl_setup.question_id NOT IN (SELECT question_id
452: FROM igf_ap_st_inst_appl_all
453: WHERE base_id = td_inst.base_id);
454:
455: l_inst_appl c_inst_appl%ROWTYPE;
456:

Line 494: create all the questions in the IGF_AP_ST_INST_APPL_ALL,

490: IF l_appl_code.system_todo_type_code = 'INSTAPP' THEN
491: IF p_action = 'INSERT' THEN
492: /*
493: For an institutional application to do item, on insert,
494: create all the questions in the IGF_AP_ST_INST_APPL_ALL,
495: and create a record for the status also.
496: */
497: lv_base_id := new_references.base_id;
498: lv_item_sequence_number := new_references.item_sequence_number;