APPS.IGF_AP_GEN dependencies on IGF_AP_TD_ITEM_MST_ALL

Line 880: cp_todo_number igf_ap_td_item_mst_all.todo_number%TYPE

876: l_inst c_inst%ROWTYPE;
877:
878: -- Get the system to do type code of the item
879: CURSOR c_system_todo_type(
880: cp_todo_number igf_ap_td_item_mst_all.todo_number%TYPE
881: ) IS
882: SELECT system_todo_type_code
883: FROM igf_ap_td_item_mst_all
884: WHERE todo_number = cp_todo_number;

Line 883: FROM igf_ap_td_item_mst_all

879: CURSOR c_system_todo_type(
880: cp_todo_number igf_ap_td_item_mst_all.todo_number%TYPE
881: ) IS
882: SELECT system_todo_type_code
883: FROM igf_ap_td_item_mst_all
884: WHERE todo_number = cp_todo_number;
885: l_system_todo_type c_system_todo_type%ROWTYPE;
886:
887: l_seq_val NUMBER;

Line 910: FROM igf_ap_td_item_mst_all

906: CURSOR c_td_item(
907: cp_item_sequence_number igf_ap_td_item_inst_all.item_sequence_number%TYPE
908: ) IS
909: SELECT description
910: FROM igf_ap_td_item_mst_all
911: WHERE todo_number = cp_item_sequence_number;
912: l_desc igf_ap_td_item_mst_all.description%TYPE;
913:
914: -- Get award year alternate code

Line 912: l_desc igf_ap_td_item_mst_all.description%TYPE;

908: ) IS
909: SELECT description
910: FROM igf_ap_td_item_mst_all
911: WHERE todo_number = cp_item_sequence_number;
912: l_desc igf_ap_td_item_mst_all.description%TYPE;
913:
914: -- Get award year alternate code
915: CURSOR c_award_year(
916: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE